PowerApps Dynamic Calendar - Gallery view to Calendar view

[@lawrencechiu2802]

AMAZING! Instruction were very clear and easy to follow. This Calendar is bad ass!! All heil Deepak, you are a Guru!!!! Thank you, thank you and thank you,

[@DeepakShrivastava]

Thank you ☺️

[@christopherlawes9286]

Thank you so much! This is the best PowerApps Calendar Tutorial I have seen on KZbin.

[@DeepakShrivastava]

You're very welcome! Thanks a lot.

[@Zodiac65ForU]

This is the best breakdown and very useful examples. One question remains: what if an item is more than one day, can a duration be shown on the calendar?

[@Zodiac65ForU]

How do you code it so that items display bar covers multiple days e.g., and event is three days so the bar with item should cover three days, not repeating same item on each of the three days.

[@jcneto25]

Thats Amazing. You really solved a very challenging problem on power apps. Thank you !

[@kato249]

I just wanted to add my thanks to what I think is easily one of the best 'how to' tutorials on KZbin, especially for PowerApps. Some of the coding appears a little out of date which had me digging around but that's to be expected with something as early in its development cycle. Thank you!

[@DeepakShrivastava]

Thank you 😊

[@onesoldierserving]

This is absolutely wonderful! Thank you for making this video!

[@DeepakShrivastava]

You are so welcome!

[@MichaelDeBlasis1369]

You should have seen my face when you color coded everything to the statuses. I've been looking for a way to do that for 2 weeks and just came across this video. Ty so much.

[@DeepakShrivastava]

Happy it helped you 😀

[@LapaConsult_Ex_Macraris]

Thank You for the great and simple techniques to create a Calendar View in PowerApps. I wass able to adapt it to European calendar week begins on Monday. I would like to share the techniques learned here with my *italian audience* here on KZbin. Have a nice day.

[@DeepakShrivastava]

Thanks a lot.

[@richardtaylor3097]

Amazing video, thanks so much for sharing your knowledge.

[@jonatasxavier]

The best video I´ve seen so far. The calendar is ready and working, but just showing the start date, how could I show the range between the start date and the due date. Subscribed after this video! Excelente content!

[@berggrog1]

Really Nice work and good use or some functions I had not used before. I changed the if statement for the CountRows to show more tasks to a with statement like With({wCountTasks:CountRows(Filter('Tasks','Due Date'=ThisItem.Value))},If(wCountProjectTasks>2,"+"&wCountProjectTasks&" more","no more tasks")) Saves that second call to the tables for the count. Apparently everyone uses with these days. Really great video and simple solution. Thank you for making the video. Really helped.

[@EpicBizHero]

Thank you so much Deepak! EXTREMELY HELPFUL!!!

[@spen2431]

1 word.. "Excellent", Thanks for sharing . 💥🤯👍

[@spen2431]

^^Oh... and you now have a new subscriber 👍

[@btoz6237]

Thank you Deepak, this is an excellent calendar video

[@icodeint2780]

Dude thanks, was looking for that for months.

[@micovillanueva9142]

Hi, just a question, Im trying to do this step by step, However everytime I input the "ForAll(Sequence(42),Value+varCurrentDate)" code where it should be in the video (@7:44), The dates from the calendar just vanish. I did not skip any step. Thanks always for the tutorials!

[@MichaelDeBlasis1369]

Did you ever figure out why?

[@uwuwonyo7502]

@@MichaelDeBlasis1369 try putting the Set(varCurrentDate, Date(Year(Today()),Month(Today()),1)) on the OnVisible property of the screen of the calendar itself instead of on app OnStart

[@Jethro-uq3sm]

I had the same issue, I just had to save the app and reopen it.

[@julien8979]

Thank you for sharing Deepak. I would suggest later another video on how we can transform the same app gallery view to a calendar view in a responsive design app version.

[@DeepakShrivastava]

Thanks for the idea! I have it my plan 👍

[@AkishaAnthony]

Thank you. This tutorial was very helpful.

[@vitorfidry8616]

Hello Deepak, how are you? Excellent video! Could you show me how did you develop the cancel buttom, please?

[@LynnlynninVA]

AWESOME tutorial. Very straight forward. BRAVO SIR!!!!! You have gained a new subscriber after watching this.

[@DeepakShrivastava]

Thank You for watching and subscribing! keep sharing.

[@pravinshingadia7337]

New subscriber today. Your videos are awesome - some of the best I've seen on this subject

[@FernandoGutierrez-mp1fg]

Thanks to share your knowledge, your videos have been so useful in my job.

[@DeepakShrivastava]

Thank you for watching 👍🏻

[@jeremyweaver2908]

Such a great PowerApps Calendar tutorial. Easy to build and connect with gallery data. In my calendar build, it's slightly more unique in which I have connected with two date columns. I have a business need to show two dates so our team can see all work being scheduled. I was able to show both date columns on the calendar but am having difficulty with the color fill property. Might you have any suggestions on how to color fill say a "Start" date with one color and an "End" date with another color? It's like the color formatting if having a column called Status, but yet unique as it's two different date columns. I'm getting close with different formulas, but can only get one date field to work properly as if it's ignoring the other date column, even though they both show on the calendar view.

[@EuropasOcean]

Great tutorial, thank you so much! I wish that you provided the project/app code for the calendar

[@mrtanner87]

Great Video. Thanks very much. Just wondering how would I adjust this to allow for two dates - a from and a to like in a leave calender?

[@happyir8]

You are helping me, thanks😀

[@MichaelDeBlasis1369]

Great videos Deepak! Keep them coming

[@DeepakShrivastava]

More to come!

[@dblumenstetter]

Hi - great video. Can you explain the month buttons again, right now i can only go one month ahead and one month behind today(). Did I miss something? Thanks, really great content.

[@mohdsamaco5541]

this is great demo , thank you for sharing it , i have one question for the date in my excel DataSource although it is only date but when it is pushed to powerapps it has time in it how can I remove the time from my excel & only have date so I can match the date with the calendar ?

[@squid1306]

Thanks Deepak, I've created your calendar based on your tutorial (thanks) Can you upload a video that builds upon that, accounting for the following - tasks have a start and end date, so are spread across multiple days (instead of a single date, in your example you've used due date) Also, a form that a team member can use on the calendar to add a new task with start/due date. Thank you

[@YaryRivera]

Amazing work :) Thank you so much! Can you please tell me how I can show a date range on the button? I have an asset request calendar and I need to show all the days the asset is checked out for. Any help would be amazing :)

[@msrz110]

Hi, can you guide on how you made the home page of the application or is there any tutorial uploaded?

[@bernarat]

Great content! Thank you so much for posting this

[@DeepakShrivastava]

Glad you enjoyed it!

[@EllieCarter5225]

Thank you so much for creating this video. Unfortunately, I can not get in the first pahse of setup for the bittons to have the gallery navigate to previous and next screens. Did I miss something?

[@timothycruce8446]

Hi @DeepakShrivastava, I found this video today and I guess Microsoft did some updates because it will not let me use the Set(varCurrentDate,Date(Year(Today()),Month(Today()),1)) as it says that, "Behavior function in a non-behavior property. You can't use this property to change values elsewhere in the app. Incompatible type. We can't evaluate your formula because the context variable types are incompatible with the types of values in other places in your app." Time stamp on video: 7:33

[@Abdiaspeguero]

This is a great video, thanks for sharing!

[@DeepakShrivastava]

Glad you enjoyed it!

[@coordinadorserviciocummins4415]

great job, is it possible you can tell me how you got the priority of the task and what connector do you use to access it (Planner?)

[@prapulrede5641]

Hii bro wen i changed the varCurrentDate instead of today() my cells has got empty may i know the reason

[@sueannwong3344]

Hi Deepa, Great video thank you so much!!!🎉 Have a question: How do we have the tasks appear on all dates from Start Date to Due Date instead of just on Due Date?

[@jaysonravena4460]

Hi Deepak, Thank you for this video. Is it possible to widen the colored button events title base on start date and end date? Thank you

[@DeepakShrivastava]

Thanks for watching. you can do it by adding some logic to it . but i would not recommend that knowing the limited space in the box..

[@chengcheng7682]

Hi Deepak, very nice video 😃. May I know is that possible to limit number slot per day? Example only allow 2 submission per day.

[@DeepakShrivastava]

Thank You. Yes you can, just check total number entry for the given date before submitting and if it is more than 2 show an message.

[@lorenasoto5391]

Thank you for the video, how can i modify the filter to show due date and start date, to see when the activity was completed

[@clebertakahashi5028]

Tanks a lot, you helped me a lot!!

[@DeepakShrivastava]

Glad to hear that!

[@ajaychoudhary5596]

Awesome video Deepak 👍 I am big fan of you. 🙏

[@DeepakShrivastava]

Thank You 🙏🏻

[@DenisseAydeeDiaz]

Hi! I am trying to follow your video! but I am having an issue, Set(varCurrentDate,Date(Year(Today()),Month(Today()),1)), when creating the variable I see there is nothing stored it says "varCurrentDate=Blank" and my calendars goes blank. I have noticed when I am trying to create variables or name records I need to add ".Value" when other people don't have to I don't know why. In date scenario how can I make it work?

[@cLockwork90]

Hi Deepak, excellent video. It's exactly what I was looking for and it works amazing. One question. Is there an easy way to convert this calendar into a weekly one? I'm using this calendar for a team holiday tracker and there is a possibility that more people will be off at the same time, which means that not all lines will be visible. Thanks again for showing us how it's done.

[@DeepakShrivastava]

Thanks for watching. Yes you can I was planning to make another video on that as that will require some work on gallery setup, I have not done it yet but it is possible .

[@sandeepshandilya400]

@@DeepakShrivastava Hi Deepak, even i have a similar requirement as @Gabriel Mihal, so can you please help me out with a solution to create a holiday tracker on Microsoft Teams.

[@AlejandroHernandez-w6j]

Thanks for this awesome tutorial!! Im looking to create an app were Im able to see my collegues out of office days, how can I do to show the whole days instead of only the first day they add, for example, I will be out from 10/10/2023-13/10/2023, the calendar will show only 10/10/2023, I want all of them, please help me with this task!!!

[@god_hacker581]

Very nice video, thanks for sharing !!!!

[@DeepakShrivastava]

Thank You!

[@Prabinesh]

Could we automatically adjust the gallery height to accommodate all the text of the event within a day? I suppose we would need to utilize a flexible-height gallery for that purpose. However, in attempting to do so, I discovered that there is no wrap count available, which makes it challenging to create a calendar using this method. Do you have any suggestions or ideas on how to overcome this limitation?

[@DeepakShrivastava]

To show all the events for given day , you should use a popup instead changing the height of template ( that will be easily possible)

[@Prabinesh]

@@DeepakShrivastava Agreed! Thanks, Deepak.

[@hongleung9141]

Hi Deepak, This was an Excellent video. But i've some items cannot shown on Calendar view when the event added on Gallery view. How can i fix it? Thank you so much!

[@DeepakShrivastava]

Thanks for watching. is it because of limited space or you are getting any error?

[@tikshaaggarwal2000]

Hi deepak, i need an implementation to merge a record to 1 if occuring for diffrent days. Example Project 1 needs to have on 3jan to 5 jan, then in UI i want to show that as single record instead of 3 records for each day. Same as we see in outlook calender. How to implement that. Please any suggestions.

[@ronakgarg3650]

Hi thanks for the amazing tutorial, Is it possible to have horizontal lanes in power app calendar where a team can easily see which tasks are assigned to users based on there initials ? We would like to kind of replicate the calendar view of Teams when we book meetings ? Is that possible

[@chyfamily11]

Very good Power app, I have created the dynamic calendar with the help of your video, but I can't add my data sheet into it, its in Google sheet. Can't figure it out how to connect my excel data sheet with it. Could you help please. Many Thanks

[@alysonmcgill4350]

Hi Deepak, this is a great video. I am using Dataverse as my data source and I am looking to show the date range of an event, I can get the start and end date when using filter(datasource, starttime=ThisItem.value || endtime =ThisItem.value) but this does not show the dates it is on in between, do you know if this is possible when using dataverse?

[@adeniyanadewunmi3766]

Hi Alyson. Have you found a solution to this as I'm stuck right here

[@alysonmcgill4350]

@@adeniyanadewunmi3766 yeah I used Filter(data source, ‘startdate’ = Datevalue(this item.value)) hope this helps you

[@FilmtographyMedia]

Thanks for this. I used If(CountRows(gal.AllItems)>1, Navigate('scrCal'))

[@akilabenjamin7079]

Super Thank you so much

[@DroneEyes]

Great video Deepak! Would be possible for you to share the Power App file with us? Thanks

[@BryanMendez120]

Hi Deepak, is it possible to create a calendar like this in Power Apps in Phone view? what is recommended when creating a responsive application for Calendars? Thanks

[@DeepakShrivastava]

You should be able to create, but as you know gallery control is not automatic responsive so you need to design and add logic to make it responsive. Little bit work possible.

[@chrisaldaco2836]

What formula you use for the cancel button? Can’t get it to close after I open it.

[@jeevanruprai8707]

Hi Deepak, I love this tutorial and have gotten pretty far but the Filter function doesn't seem to show my list items beneath the dates. The data is definitely there as I tested the Sharepoint list using another Gallery but I cant seem to see it when I apply Filter(). How do I fix this?

[@sandrolima5216]

amazing, thanks.

[@0001omkarpatil]

Same i create calendar but when I save and close app .and again open app the inner gallery not working like progress gallery

[@christerrussberg3059]

Thanks for sharing: But I wonder if you have any examples where you have a "start date" and "end date" and you want to show that timeslot in the gallery ie show one week of holiday.

[@zaingondal3400]

Did you figure out a way to do this?

[@muzammiltaleb4993]

Hi, How to make the horizontal and vertical scrollable gallery, I have implemented but It is not working Mobile Device. Any suggestions Thanks you

[@ayodejiosikoya1354]

Please what did you use for the cancel button? i mean the code

[@nivekkled]

Wow. Thank you!

[@DeepakShrivastava]

You're welcome!

[@davidrico8755]

Nice video

[@lilaniakershaw3813]

Excellent video - but... When i follow along, at the 7.40 point, when I apply the varCurrentDate it not only doesn't work, but removes all the data. No idea what i'm doing wrong

[@DeepakShrivastava]

Thanks for watching. Please make sure you set varCurrentDate to today(). and save and run your app so this variable have todays date.

[@lilaniakershaw3813]

@@DeepakShrivastava Thanks. I found that i needed to force the Run OnStart function in the development mode, and now it works perfectly. I clearly missed that part of the tutorial.

[@bernarat]

@@lilaniakershaw3813 what do you mean "force the run onstart function"? I'm running into the same issue.. thanks!

[@ariefsaferman]

why I can't set my variable currentdate? there is no onstart property on my powerapps, please helpp

[@bzflowerbee]

I have a table that contains Date, Location, Name, Status. I know how to connect data, create screens and from this screen to another screen. But, when i want to add a datepicker to the app, I'm totally lost. What I want to do is user pick the date they wan to see the location and name on that date. Is this complicate to do? Any helps and suggestions is appreciated. Thank you.🙏🙏

[@pawanmishra6549]

Thanks Deepak 👍

[@DeepakShrivastava]

Welcome 👍

[@mridulgrover21]

This was helpful, but I want to check every time i am adding Countrows option, the count is not correct. For ex if I have in total for that particular day 4 items, so ideally 2 should appear and it should say +2 but it is saying +4 more. Also when user click on +3 more items, how should I make user to see the remaining buttons/items which are not visible.

[@mridulgrover21]

@DeepakSrivastava - Can u suggest

[@rachnarajput1190]

i also make app on start Set(varCurrentDate,Date(Year(Today()),Month(Today()),1)) but when do it as ForAll(Sequence(42),Value+varCurrentDate) in gallery is show blank

[@MacacoPekines]

Hi Deepak, When I create VarCurrentDate it says tha is = Blank Do you know the reason?

[@bhuvanamaddineni9552]

Hi I want to save monthly ticket data of each month using power apps. any suggestions on this please

[@DeepakShrivastava]

It’s difficult to explain how you can do it here but you can definitely achieve this using PA basic understanding

[@bhuvanamaddineni9552]

@@DeepakShrivastava am searching for this many videos

[@bhuvanamaddineni9552]

@@DeepakShrivastava am example video..

[@JorgeOyanadel]

Extraordinario

[@TerafabGuitare]

Merci beaucoup

[@DeepakShrivastava]

Thank You!

[@10405wooded]

How to we handle the Scheduling Conflicts?

[@imranhakim2872]

Hi Deepak, im trying to set the varCurrentDate variable into the gallery, but when i finished up the code the text value in the label didn't show. What should i do?

[@davidrico8755]

HAPPEND TO ME TOO lol

[@vaibhavwarkar9629]

Can u help me to make video regarding MS teams calender view in powerapps

[@Aby202]

When i replace Today () with varCurrentDate, everything in the gallery goes blank, how to fix this?

[@raymondvanderhorst3418]

Hi Deepak, Thanks for the nice calendar. I would like it if you press the date that you get a _SelectedDate back. How can I build this?

[@DeepakShrivastava]

Thanks for watching. You can set a variable on "OnSelect" action of the gallery with "thisItem". "thisItem" will have the date and other details.

[@AndrewSmith-qd8hd]

I did not work for me, once I used the +varCurrentDate) variable, everything disappeared. Can you also show us how to conect the calendar to yammer please?

[@mohankrishnanagamangalam9452]

Click on ellipsis next to App and then select 'Run OnStart'. This will fix your issue.

[@DeepakShrivastava]

I hope you were able to get it working based on below comment. I will check on how we can connect Yammer to calendar. do you know any use case for this integration?

[@jasonearls6831]

the !varshoform didnt work for me, when i press the button the form is still present on the screen any tips?

[@esterraful]

anyone discovered solution for not working varCurrentDate? not sure what do to, i tried to run it with zero results.

[@nitisakphotaram6288]

Hi after I set variable VarCurrentdate and put it in with value+VarCurrentdate the date in calendar does not show

[@paulwoods4349]

I have the same problem.

[@lnwzaskrrt9710]

My varCurrentDate = Blank ? how to fix ???

[@qaerdogan]

That's why I left the C# :)))))

[@M87user]

How to modify it not to display Sundays and Saturdays?

[@rachnarajput1190]

my varCurrentDate is blank.why?

[@Priyankayadav-uz7ek]

What is the code written on Cancel button

[@sidneialmeida6750]

Show!!!!

[@largpack]

i can see delegation warnings everywhere... which makes me hate and stop using powerapps for now ;)

[@ErdemKurcan-r3y]

Hi Deepak Shrivastava thanks for the video, I am having a trouble that ThisItem.Value, value is not recognised warning. How Can I solve it, great thanks in advance.

[@derrickiciabowles4051]

I don't see that anyone answered so to help everyone else who may run into this, if the calendar goes blank after updating to varCurrentDate, click the 3 dots next to "App" and click Run OnStart. Dates Should Appear

[@DeepakShrivastava]

Thanks for the update. Yes for a variavle that you define at App on start you should do it to test. once you publish the app it will work anyway.

[@esterraful]

hi, i am sorry , but i did how you suggested and it doesnt work i stuck with that

[@MarconiPereira]

To highlight the current date in light blue color (fill property), this method is not working... I tried twice and it didn't work... any hints? If(ThisItem.Value=Today(),ColorFade(RGBA(58, 150, 221, 1),80%),White)

[@MarconiPereira]

Actually I made it... code is: If(ThisItem.Value=Today(),ColorFade(RGBA(58, 150, 221, 1),80%),Color.White)

[@DeepakShrivastava]

you are awesome!

[@michaelporch1171]

If(ThisItem.Value=Today(),ColorFade(RGBA(58,150,221,1),80%),Color.White)