PowerApps Dynamic Calendar - Gallery view to Calendar view  

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,

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

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

I just wanted to add my thanks to what I think is easily one of the best 'how to' tutorials on RU-vid, 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!

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?

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.

Thank you Deepak, this is an excellent calendar video

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 RU-vid. Have a nice day.

Amazing video, thanks so much for sharing your knowledge.

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!

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

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

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.

Dude thanks, was looking for that for months.

Thank you so much Deepak! EXTREMELY HELPFUL!!!

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.

Thank you. This tutorial was very helpful.

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

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!

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

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

Great videos Deepak! Keep them coming

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.

You are helping me, thanks😀

Great content! Thank you so much for posting this

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

Tanks a lot, you helped me a lot!!

This is a great video, thanks for sharing!

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?

Very nice video, thanks for sharing !!!!

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.

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.

Super Thank you so much

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

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

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

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 :)

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 ?

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?

amazing, thanks.

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?

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

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?

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

Wow. Thank you!

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?

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.

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?)

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.

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

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?

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!

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

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

Extraordinario

Thanks Deepak 👍

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!!!

Nice video

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

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

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

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?

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

Merci beaucoup

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

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.

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

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

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.🙏🙏

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

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

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

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.

How to we handle the Scheduling Conflicts?

How to modify it not to display Sundays and Saturdays?

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?

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

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

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?

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

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

What is the code written on Cancel button

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?

my varCurrentDate is blank.why?

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

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

Show!!!!

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

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

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.

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

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)

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