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 RUclips, 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!
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
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!
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 RUclips. Have a nice day.
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.
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.
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?
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.
This is so good and I've got it working so far. But what I have, is a list with multiple dates. ie. Review date, due date, meeting date. For each date, I want to display a button with the title of the row (and some added text which I can do). Do I need to add a gallery for each date column, or can I somehow filter all items that have dates in each of the columns and then they display a button on each date? Sorry, hope that makes sense.
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! 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, 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.
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.
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?
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.
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, 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.
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 ?
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.
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?
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 :)
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 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 - 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.
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
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
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.
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.
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.
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
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
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 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 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, 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!
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?
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)
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.
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
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
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 RUclips.
You're very welcome! Thanks a lot.
I just wanted to add my thanks to what I think is easily one of the best 'how to' tutorials on RUclips, 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 helps me a lot. Thank you for your expertise!
This is absolutely wonderful! Thank you for making this video!
You are so welcome!
Thats Amazing. You really solved a very challenging problem on power apps. Thank you !
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.
@@Jethro-uq3sm Thank you! It works after I reopened.
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!
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 RUclips. Have a nice day.
Thanks a lot.
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.
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.
I have this question too! Bump!
Amazing video, thanks so much for sharing your knowledge.
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
AWESOME tutorial. Very straight forward. BRAVO SIR!!!!! You have gained a new subscriber after watching this.
Thank You for watching and subscribing! keep sharing.
Thank you so much Deepak! EXTREMELY HELPFUL!!!
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?
Dude thanks, was looking for that for months.
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 😀
Thank you Deepak, this is an excellent calendar video
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!
This is so good and I've got it working so far. But what I have, is a list with multiple dates. ie. Review date, due date, meeting date. For each date, I want to display a button with the title of the row (and some added text which I can do). Do I need to add a gallery for each date column, or can I somehow filter all items that have dates in each of the columns and then they display a button on each date? Sorry, hope that makes sense.
Thank you. This tutorial was very helpful.
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.
Great content! Thank you so much for posting this
Glad you enjoyed it!
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, 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.
Hii bro wen i changed the varCurrentDate instead of today() my cells has got empty may i know the reason
Hi, can you guide on how you made the home page of the application or is there any tutorial uploaded?
Awesome video Deepak 👍 I am big fan of you. 🙏
Thank You 🙏🏻
This is a great video, thanks for sharing!
Glad you enjoyed it!
What formula you use for the cancel button? Can’t get it to close after I open it.
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😀
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?
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?
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..
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.
why I can't set my variable currentdate? there is no onstart property on my powerapps, please helpp
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.🙏🙏
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, How to make the horizontal and vertical scrollable gallery, I have implemented but It is not working Mobile Device. Any suggestions Thanks you
Same i create calendar but when I save and close app .and again open app the inner gallery not working like progress gallery
Very nice video, thanks for sharing !!!!
Thank You!
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.
Hello Deepak, how are you? Excellent video! Could you show me how did you develop the cancel buttom, please?
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 ?
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?
Tanks a lot, you helped me a lot!!
Glad to hear that!
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.
Please what did you use for the cancel button? i mean the code
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..
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?
the !varshoform didnt work for me, when i press the button the form is still present on the screen any tips?
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 :)
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
Can u help me to make video regarding MS teams calender view in powerapps
Great tutorial, thank you so much! I wish that you provided the project/app code for the calendar
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 - 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.
anyone discovered solution for not working varCurrentDate? not sure what do to, i tried to run it with zero results.
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
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 @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
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!
When i replace Today () with varCurrentDate, everything in the gallery goes blank, how to fix this?
Wow. Thank you!
You're welcome!
Super Thank you so much
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.
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
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
How to we handle the Scheduling Conflicts?
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
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
My varCurrentDate = Blank ? how to fix ???
amazing, thanks.
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!!!
How to modify it not to display Sundays and Saturdays?
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, 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?
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?
What is the code written on Cancel button
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!
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.
Nice video
my varCurrentDate is blank.why?
Great video Deepak! Would be possible for you to share the Power App file with us? Thanks
Extraordinario
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.
Merci beaucoup
Thank You!
That's why I left the C# :)))))
Show!!!!
i can see delegation warnings everywhere... which makes me hate and stop using powerapps for now ;)
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.
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
Thanks for this. I used If(CountRows(gal.AllItems)>1, Navigate('scrCal'))
If(ThisItem.Value=Today(),ColorFade(RGBA(58,150,221,1),80%),Color.White)