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,
I just wanted to add my thanks to what I think is easily one of the best 'how to' tutorials on CZcams, 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 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 CZcams. Have a nice day.
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!
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.
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.
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 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
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.
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.
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?
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?
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
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.
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.
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 .
@@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.
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! 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!
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!!!
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
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?
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.
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.🙏🙏
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. 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.
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.
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?
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?
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?
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
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.
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)
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 ☺️
Thank you so much! This is the best PowerApps Calendar Tutorial I have seen on CZcams.
You're very welcome! Thanks a lot.
This is absolutely wonderful! Thank you for making this video!
You are so welcome!
I just wanted to add my thanks to what I think is easily one of the best 'how to' tutorials on CZcams, 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!
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 CZcams. Have a nice day.
Thanks a lot.
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 . 💥🤯👍
^^Oh... and you now have a new subscriber 👍
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.
Happy it helped you 😀
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.
Thank You for watching and subscribing! keep sharing.
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!
Did you ever figure out why?
@@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
I had the same issue, I just had to save the app and reopen it.
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.
Thank you for watching 👍🏻
Great videos Deepak! Keep them coming
More to come!
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.
Thanks for the idea! I have it my plan 👍
You are helping me, thanks😀
Great content! Thank you so much for posting this
Glad you enjoyed it!
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!!
Glad to hear that!
This is a great video, thanks for sharing!
Glad you enjoyed it!
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 !!!!
Thank You!
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. 🙏
Thank 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
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.
Wow. Thank you!
You're welcome!
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?
To show all the events for given day , you should use a popup instead changing the height of template ( that will be easily possible)
@@DeepakShrivastava Agreed! Thanks, Deepak.
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.
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 .
@@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.
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.
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.
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!
Thanks for watching. is it because of limited space or you are getting any error?
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
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..
Extraordinario
Thanks Deepak 👍
Welcome 👍
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?
Hi Alyson. Have you found a solution to this as I'm stuck right here
@@adeniyanadewunmi3766 yeah I used Filter(data source, ‘startdate’ = Datevalue(this item.value)) hope this helps you
Great video Deepak! Would be possible for you to share the Power App file with us? Thanks
Merci beaucoup
Thank You!
Hi I want to save monthly ticket data of each month using power apps. any suggestions on this please
It’s difficult to explain how you can do it here but you can definitely achieve this using PA basic understanding
@@DeepakShrivastava am searching for this many videos
@@DeepakShrivastava am example video..
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.
Did you figure out a way to do this?
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
Thanks for watching. Please make sure you set varCurrentDate to today(). and save and run your app so this variable have todays date.
@@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.
@@lilaniakershaw3813 what do you mean "force the run onstart function"? I'm running into the same issue.. thanks!
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.
@DeepakSrivastava - Can u suggest
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?
Click on ellipsis next to App and then select 'Run OnStart'. This will fix your issue.
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?
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?
HAPPEND TO ME TOO lol
Hi after I set variable VarCurrentdate and put it in with value+VarCurrentdate the date in calendar does not show
I have the same problem.
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?
Thanks for watching. You can set a variable on "OnSelect" action of the gallery with "thisItem". "thisItem" will have the date and other details.
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
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.
hi, i am sorry , but i did how you suggested and it doesnt work i stuck with that
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)
Actually I made it... code is:
If(ThisItem.Value=Today(),ColorFade(RGBA(58, 150, 221, 1),80%),Color.White)
you are awesome!
If(ThisItem.Value=Today(),ColorFade(RGBA(58,150,221,1),80%),Color.White)