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,
@DeepakShrivastava8 ай бұрын
Thank you ☺️
@Zodiac65ForU11 ай бұрын
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.
@EpicBizHero Жыл бұрын
Thank you so much Deepak! EXTREMELY HELPFUL!!!
@micovillanueva91427 ай бұрын
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!
@MichaelDeBlasis13696 ай бұрын
Did you ever figure out why?
@uwuwonyo75026 ай бұрын
@@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-uq3sm5 ай бұрын
I had the same issue, I just had to save the app and reopen it.
@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.
@YaryRivera7 ай бұрын
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 :)
@mrtanner877 ай бұрын
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😀
@akilabenjamin7079 Жыл бұрын
Super Thank you so much
@sandrolima5216 Жыл бұрын
amazing, thanks.
@hongleung91412 жыл бұрын
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!
@DeepakShrivastava2 жыл бұрын
Thanks for watching. is it because of limited space or you are getting any error?
@FilmtographyMedia Жыл бұрын
Thanks for this. I used If(CountRows(gal.AllItems)>1, Navigate('scrCal'))
@M87user10 ай бұрын
How to modify it not to display Sundays and Saturdays?
@ariefsaferman2 жыл бұрын
why I can't set my variable currentdate? there is no onstart property on my powerapps, please helpp
@lilaniakershaw38132 жыл бұрын
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
@DeepakShrivastava2 жыл бұрын
Thanks for watching. Please make sure you set varCurrentDate to today(). and save and run your app so this variable have todays date.
@lilaniakershaw38132 жыл бұрын
@@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.
@bernarat2 жыл бұрын
@@lilaniakershaw3813 what do you mean "force the run onstart function"? I'm running into the same issue.. thanks!
@imranhakim28722 жыл бұрын
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
@esterraful Жыл бұрын
anyone discovered solution for not working varCurrentDate? not sure what do to, i tried to run it with zero results.
@christopherlawes92862 жыл бұрын
Thank you so much! This is the best PowerApps Calendar Tutorial I have seen on KZbin.
@DeepakShrivastava2 жыл бұрын
You're very welcome! Thanks a lot.
@Zodiac65ForU2 жыл бұрын
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?
@BryanMendez1207 ай бұрын
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
@DeepakShrivastava7 ай бұрын
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.
@timothycruce844623 күн бұрын
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
@msrz110 Жыл бұрын
Hi, can you guide on how you made the home page of the application or is there any tutorial uploaded?
@prabineshbajracharya4987 ай бұрын
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?
@DeepakShrivastava7 ай бұрын
To show all the events for given day , you should use a popup instead changing the height of template ( that will be easily possible)
@prabineshbajracharya4987 ай бұрын
@@DeepakShrivastava Agreed! Thanks, Deepak.
@DenisseAydeeDiaz4 ай бұрын
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?
@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?
@AlejandroHernandez-w6j11 ай бұрын
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!!!
@muzammiltaleb49936 ай бұрын
Hi, How to make the horizontal and vertical scrollable gallery, I have implemented but It is not working Mobile Device. Any suggestions Thanks you
@vitorfidry86163 ай бұрын
Hello Deepak, how are you? Excellent video! Could you show me how did you develop the cancel buttom, please?
@tikshaaggarwal20009 ай бұрын
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.
@dblumenstetter7 ай бұрын
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.
@largpackАй бұрын
i can see delegation warnings everywhere... which makes me hate and stop using powerapps for now ;)
@chrisaldaco283610 күн бұрын
What formula you use for the cancel button? Can’t get it to close after I open it.
@prapulrede5641 Жыл бұрын
Hii bro wen i changed the varCurrentDate instead of today() my cells has got empty may i know the reason
@MarconiPereira8 ай бұрын
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)
@MarconiPereira8 ай бұрын
Actually I made it... code is: If(ThisItem.Value=Today(),ColorFade(RGBA(58, 150, 221, 1),80%),Color.White)
@DeepakShrivastava8 ай бұрын
you are awesome!
@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
@bhuvanamaddineni95526 ай бұрын
Hi I want to save monthly ticket data of each month using power apps. any suggestions on this please
@DeepakShrivastava5 ай бұрын
It’s difficult to explain how you can do it here but you can definitely achieve this using PA basic understanding
@bhuvanamaddineni95525 ай бұрын
@@DeepakShrivastava am searching for this many videos
@bhuvanamaddineni95525 ай бұрын
@@DeepakShrivastava am example video..
@onesoldierserving7 ай бұрын
This is absolutely wonderful! Thank you for making this video!
@DeepakShrivastava7 ай бұрын
You are so welcome!
@rachnarajput1190 Жыл бұрын
my varCurrentDate is blank.why?
@LapaConsult_Ex_Macraris2 жыл бұрын
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.
@DeepakShrivastava2 жыл бұрын
Thanks a lot.
@chengcheng76822 жыл бұрын
Hi Deepak, very nice video 😃. May I know is that possible to limit number slot per day? Example only allow 2 submission per day.
@DeepakShrivastava2 жыл бұрын
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.
@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!
@DeepakShrivastava8 ай бұрын
Thank you 😊
@julien89792 жыл бұрын
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.
@DeepakShrivastava2 жыл бұрын
Thanks for the idea! I have it my plan 👍
@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
@Priyankayadav-uz7ek4 ай бұрын
What is the code written on Cancel button
@squid13068 ай бұрын
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
@jaysonravena44602 жыл бұрын
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
@DeepakShrivastava2 жыл бұрын
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..
@EllieCarter522510 ай бұрын
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?
@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.
@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
@Aby2022 жыл бұрын
When i replace Today () with varCurrentDate, everything in the gallery goes blank, how to fix this?
@bzflowerbee2 жыл бұрын
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.🙏🙏
@alysonmcgill43502 жыл бұрын
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?
@adeniyanadewunmi37662 жыл бұрын
Hi Alyson. Have you found a solution to this as I'm stuck right here
@alysonmcgill43502 жыл бұрын
@@adeniyanadewunmi3766 yeah I used Filter(data source, ‘startdate’ = Datevalue(this item.value)) hope this helps you
@pravinshingadia73372 ай бұрын
New subscriber today. Your videos are awesome - some of the best I've seen on this subject
@ErdemKurcan-r3y9 ай бұрын
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.
@EuropasOcean Жыл бұрын
Great tutorial, thank you so much! I wish that you provided the project/app code for the calendar
@jonatasxavier11 ай бұрын
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!
@cLockwork902 жыл бұрын
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.
@DeepakShrivastava2 жыл бұрын
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 .
@sandeepshandilya4002 жыл бұрын
@@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.
@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 ?
@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
@DroneEyes2 жыл бұрын
Great video Deepak! Would be possible for you to share the Power App file with us? Thanks
@richardtaylor30976 ай бұрын
Amazing video, thanks so much for sharing your knowledge.
@MacacoPekines2 жыл бұрын
Hi Deepak, When I create VarCurrentDate it says tha is = Blank Do you know the reason?
@vaibhavwarkar9629 Жыл бұрын
Can u help me to make video regarding MS teams calender view in powerapps
@10405wooded Жыл бұрын
How to we handle the Scheduling Conflicts?
@jasonearls68312 жыл бұрын
the !varshoform didnt work for me, when i press the button the form is still present on the screen any tips?
@btoz62373 ай бұрын
Thank you Deepak, this is an excellent calendar video
@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?
@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
@coordinadorserviciocummins44152 жыл бұрын
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?)
@ayodejiosikoya13542 жыл бұрын
Please what did you use for the cancel button? i mean the code
@AkishaAnthony Жыл бұрын
Thank you. This tutorial was very helpful.
@mridulgrover212 жыл бұрын
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.
@mridulgrover212 жыл бұрын
@DeepakSrivastava - Can u suggest
@LynnlynninVA2 жыл бұрын
AWESOME tutorial. Very straight forward. BRAVO SIR!!!!! You have gained a new subscriber after watching this.
@DeepakShrivastava2 жыл бұрын
Thank You for watching and subscribing! keep sharing.
@MichaelDeBlasis13695 ай бұрын
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.
@DeepakShrivastava5 ай бұрын
Happy it helped you 😀
@raymondvanderhorst34182 жыл бұрын
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?
@DeepakShrivastava2 жыл бұрын
Thanks for watching. You can set a variable on "OnSelect" action of the gallery with "thisItem". "thisItem" will have the date and other details.
@icodeint27802 жыл бұрын
Dude thanks, was looking for that for months.
@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.
@zaingondal34006 ай бұрын
Did you figure out a way to do this?
@AndrewSmith-qd8hd2 жыл бұрын
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?
@mohankrishnanagamangalam94522 жыл бұрын
Click on ellipsis next to App and then select 'Run OnStart'. This will fix your issue.
@DeepakShrivastava2 жыл бұрын
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?
@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.
@FernandoGutierrez-mp1fg2 жыл бұрын
Thanks to share your knowledge, your videos have been so useful in my job.