Build CALENDAR Control in POWER APPS in Minutes | Connect to SharePoint List

Sdílet
Vložit
  • čas přidán 16. 07. 2024
  • Looking for a Calendar Control in Power Apps? Then this step-by-step tutorial video on how to build a Calendar control in PowerApps within minutes is for you.
    I will showcase a simple way to create a Calendar control in Power Apps using the Calendar Screen Template & connect it to SharePoint List. This out of the box screen template in power apps gives us a calendar control experience connected to Outlook calendar.
    The Calendar control is built using multiple galleries and has all the logic in place to calculate days in each month, 1st and last date of the month, move calendar control between months and more.
    I will show how we can simply take the components of the calendar control from this screen template and build our own calendar control.
    I will show how to connect the Calendar View (control) to a Gallery connected to a SharePoint List.
    The Calendar view will highlight events for specific dates.
    I will also show how to add a nested gallery in the calendar control itself to showcase all the events for a given date range, color code the Calendar items, connect the calendar to a form control & more.
    Video covers the following:
    ✅ Build Calendar in Power Apps
    ✅ Calendar Screen Template
    ✅ Connect Calendar to SharePoint List
    ✅ Create nested gallery in Calendar Gallery to show multiple events per day.
    ✅ Color code Calendar items
    ✅ Calendar from SharePoint Data
    Power Apps Calendar Control Screen Documentation:
    docs.microsoft.com/en-us/powe...
    Power App (recruitment tracker):
    Power App Video link • Form Control in Power ...
    Download Link github.com/rdorrani/PowerApps...
    #Calendar #PowerApps #SharePoint #Microsoft
    Table of Contents:
    00:00 - Introduction
    00:41 - Calendar control in PowerApps
    01:17 - Power Apps Gallery connected to Calendar (SharePoint data)
    02:07 - SharePoint data on Calendar with Color Code
    03:16 - Filter Calendar Data
    03:48 - Track Dates in Calendar View
    05:11 - Calendar Control in Power Apps? Easy to build one?
    06:05 - Build a Calendar Control in minutes
    10:12 - Calendar Screen Template Documentation
    10:25 - Get the Calendar Control from the Template
    12:58 - Customize the Calendar
    14:36 - Connect Calendar Control to a data source (SharePoint)
    17:27 - Calendar Control with Color Codes
    18:55 - Build Color Coded Calendar from SharePoint List
    21:57 - Connect Calendar with Form Control
    24:19 - Subscribe to Reza Dorrani CZcams channel
    🤝 Let’s connect on social:
    🔗 Reza Dorrani LinkedIn: / rezadorrani
    🐦 Reza Dorrani Twitter: / rezadorrani

Komentáře • 411

  • @dougydoe
    @dougydoe Před 2 lety +13

    Great video again. I have seen the Calendar and other screen templates but I've never had the need to use them in Apps..... well, until now. Lol. One thing your videos do to me is to open up my imagination and appreciate what is possible. Thank you for always pushing me to strive for more.

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      Glad it was helpful! Thank You so much for watching.

  • @mattfreeman8482
    @mattfreeman8482 Před 10 měsíci +5

    I can not thank you enough for all the time, experience, knowledge and detail you put in to this video. This is definetly one of my most favorite videos on PowerApps. Keep up the amazing work Reza! 😍😍😍

  • @MrAllybell
    @MrAllybell Před rokem +1

    Another great video Reza, you've an answer for everything. Much appreaciated!

  • @CloudhoundCoUk
    @CloudhoundCoUk Před 2 lety +2

    Another magnificent packed presentation. I particularly like the link to real-world use. Thank you.

  • @adrianoberholzer1873
    @adrianoberholzer1873 Před rokem +1

    I could not praise this video more! Thank you

  • @sandyspringer55
    @sandyspringer55 Před rokem +1

    I am only half way through the video but THANK YOU!! I always find the exact solution I am looking for on your page and it’s always the simplest and well explained option out there.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Thanks Sandy 😊

    • @sandyspringer55
      @sandyspringer55 Před rokem

      @@RezaDorrani although I added a reset filter for the reset fields and now it’s broken 😞 accessibly issues with labels. And now no information shows from my list even with all filters removed. Any ideas?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@sandyspringer55 Video description has link to download sample app. You can check the logic I used in it.

  • @DNCubeVlogs
    @DNCubeVlogs Před 2 lety +1

    Thanks Reza, Thanks a lot. Every time you will change the developer design aspects. Love you again. Once again thanks for your great efforts and insights for us.

    • @RezaDorrani
      @RezaDorrani  Před 2 lety +1

      You are most welcome. Thank You for your kind words.

  • @necdetsaritas8722
    @necdetsaritas8722 Před 2 lety +1

    This weekend was wonderful through your great video. Thanks Reza

  • @chrisproctor2854
    @chrisproctor2854 Před rokem +1

    Another awesome video where I learned some things that I can't wait to implement!

  • @kearley8792
    @kearley8792 Před rokem +1

    This is a great video. Easy to follow and well-explained. Thank you very much!

  • @maryampour8914
    @maryampour8914 Před 2 lety +2

    Thank you so much Reza! it's simply just brilliant 🙂

  • @russthedutch
    @russthedutch Před 2 lety +1

    Amazing as always, learning so much because of your channel!!

  • @oluwatobiyusuf
    @oluwatobiyusuf Před 2 lety +1

    Awesome trick around calendar control. Thank you Reza for another amazing content. New knowledge learnt

  • @simonball5602
    @simonball5602 Před 10 měsíci +1

    Another great video Reza. Genius- thank you.

  • @EpicBizHero
    @EpicBizHero Před rokem

    Thanks so much Reza! You are Truly Appreciated!!!

  • @Samshujayanagar
    @Samshujayanagar Před 6 měsíci +1

    Thank you for this video Reza. You are amazing and keep up the great work 👍🏼

  • @Richkotite1
    @Richkotite1 Před rokem +1

    This is a great video. Easy to follow and well-explained. Thank you very much

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Glad to hear that! Thanks for watching.

  • @MichaelDeBlasis1369
    @MichaelDeBlasis1369 Před 3 měsíci +1

    You make the best videos Reza! They are all so clear and well laid out. And so consistent on the lessons and layout. Well done Sir.

    • @RezaDorrani
      @RezaDorrani  Před 3 měsíci

      Many thanks!
      A lot goes into making these videos and it feels amazing to receive such appreciation

    • @christianhuidobro7452
      @christianhuidobro7452 Před 3 měsíci

      @@RezaDorrani hola, podrias subir el video para poder crear la lista?

  • @kingthranduil8807
    @kingthranduil8807 Před 7 měsíci +1

    Amazing! Exactly what I needed! thanks for the video!

  • @SadekInfos7392
    @SadekInfos7392 Před rokem +1

    Thanks a lot for your efforts, life seems so easy with your videos and your neat way🙏🙏🙏🙏

  • @adrianoberholzer1873
    @adrianoberholzer1873 Před rokem +1

    Brilliant video!! Thank you so much!

  • @jamiemcgrath3305
    @jamiemcgrath3305 Před 2 lety +1

    I'm sure you must have seen my Reddit post the other day looking for this! Amazing thank you

    • @RezaDorrani
      @RezaDorrani  Před 2 lety +1

      Sorry, I did not but I'm happy to know that this is what you were looking for.

    • @jamiemcgrath3305
      @jamiemcgrath3305 Před 2 lety

      @@RezaDorrani one thing I was trying to do also was to have a comparison with a SharePoint list data against a users calendar. I am making a training booking app currently and wanted them to be able to easily see at a glance if they were free during that time, potentially piling together an agenda for their day with the training time overlaid. Is this possible? Really struggling to get my head around the calendar connector functionality

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      @@jamiemcgrath3305 Possible but I would have to try it out to learn more about it. I will recommend posting your issues/queries on the forums at powerusers.microsoft.com/

  • @coffeecuppepsi
    @coffeecuppepsi Před 10 měsíci +1

    thank you for this, exactly what i needed

  • @MrPirani
    @MrPirani Před 2 lety +1

    Beautifully done!

  • @MegaKumar0
    @MegaKumar0 Před 2 lety +1

    Another great video Reza.. thanks 🙏.

  • @dsars79
    @dsars79 Před rokem +1

    @Reza thanks for sharing. It is almost catering all my needs. Thanks once again.

  • @jasmingutierrez9280
    @jasmingutierrez9280 Před 10 měsíci

    Great! Another masterpiece, Sir. Thanks for this. ☺️

  • @lathanishikanthreddy8278
    @lathanishikanthreddy8278 Před 2 lety +1

    Thanks a ton Reza!!!

  • @UncleF115
    @UncleF115 Před rokem

    came from shane young's DIY calendar video, these 5 sec technique saved me!

  • @SHAli1474
    @SHAli1474 Před 2 lety +2

    Hi Reza
    Haven't finished the video yet but got to give you a thumbs up :).
    Great Idea
    Thanks for educating us.

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      Hope you enjoyed it!

    • @SHAli1474
      @SHAli1474 Před rokem

      @@RezaDorrani Watching it again to build an app for Holiday Tracking. Can't appreciate enough for these amazing videos. But Thanks a lot.👍👍👍

  • @JPPVCC
    @JPPVCC Před rokem +2

    Reza: Many thanks for this. Not just for me but for my client. This is going to make a significant difference in their productivity and analysis. I'd like to help others as well. My client's needs were a bit different and I wanted to have just a single button on the Interview calendar that counted the number of events for that day. At a glance they can now see how many field service calls are loaded by day. I achieved this by adding the vertical gallery, but adding just one button and setting the Text to:
    "Total PMs: " & Text(
    CountRows(
    Filter(
    'SP List',
    Your Date Column= (DateValue(
    (DateAdd(
    _firstDayInView,
    ThisItem.Value,
    TimeUnit.Days
    ))
    ))
    )
    )
    )
    If there is a better way I'm always interested!
    Thanks again,
    JP

  • @rthoughts7232
    @rthoughts7232 Před 2 lety +1

    this new template will be very very helpful. thanks for video

  • @Chgrtours
    @Chgrtours Před 2 lety +1

    Thank you Reza!

  • @tariksalihovic
    @tariksalihovic Před měsícem

    Thx a lot 🙌 tried to figure out how to copy parts of the component and logic, but now i know 🎉

  • @Mr007Rajan
    @Mr007Rajan Před rokem +1

    Matching my use case thanks a lot

  • @ytubid
    @ytubid Před 2 lety +3

    Thanks for sharing this awesome video, Reza! Happy to send u a small gift! :)

  • @poshady2
    @poshady2 Před 2 lety +1

    Great video as usual 👍

  • @nicolettevandenheever4230

    Thanks for you video's I learn a lot from it.

  • @adamshrinah2595
    @adamshrinah2595 Před 2 lety

    Great video, thanks

  • @navarrocloud
    @navarrocloud Před 20 dny +1

    Very nice explanation. Thank you for sharing.

  • @spen2431
    @spen2431 Před 2 lety +1

    Amazing 👍💥

  • @Test-oc1fr
    @Test-oc1fr Před rokem +1

    Amazing work ❤

  • @zerocool200380
    @zerocool200380 Před 2 lety +1

    Great video Reza

  • @silasmangeni5976
    @silasmangeni5976 Před rokem +1

    Fantastic video on the calendar control, can you do one where you incorporate date and time?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I make videos when I get multiple requests on a particular topic.
      Every quarter I ask subscribers for topic suggestions on the Community Tab of my CZcams channel.
      Subscribers vote for topics and the highest voted topics get added to my backlog.
      Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

  • @davidmashworth
    @davidmashworth Před rokem +1

    Awesome video as usual!
    Any ideas on how I would use a Gallery as a source rather than a SharePoint list? Also how would we format entries based on start and end dates (not just singular entries)?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      A gallery itself needs a data source. Calendar is a gallery.

  • @zerokhan858
    @zerokhan858 Před měsícem +1

    thanks reza!!

  • @robinisathakur
    @robinisathakur Před 2 lety +1

    Hey Reza, if you needed to see a day view of the calendar and move between days (like classic SharePoint calendar) while displaying events within that day, would you have the calendar in the left of the screen and display the events in the right portion in time order? Just thinking of scenarios of where there are more than two events on a specific day, the PA calendar screen alone doesn’t quite have the screen real estate to deal with that.

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      That would be an option for sure.
      When user selects a specific day in calendar, a connected gallery on the right hand side can list out all the events for that specific date.

  • @johandeweerdt
    @johandeweerdt Před 2 lety +2

    Hi, great video as always.
    I wanted to check something. Have you ever tried to add multi-day events? Where looking for a good way to visualize these on a weekly basis... So a combination of multi-day vs one day events...

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      I had tried that a while ago on a project. Complicated to handle in power apps.

  • @jasonmoreton461
    @jasonmoreton461 Před 4 měsíci +1

    Brilliant video- very helpful and as usual easy to follow. I am intrigued by the modal pop up you showed in the video do you have a video on how to go about that at all please?

    • @RezaDorrani
      @RezaDorrani  Před 4 měsíci

      Thanks!
      czcams.com/video/8T9Pa58H1Co/video.htmlsi=NJmLxgvUpb4DBZE7

  • @siscovasallo
    @siscovasallo Před rokem +2

    Hi Reza. I'm new to Power apps and love your videos. I used this to create a Calendar app for my team at work. Could you please create a follow up video showing how to create recurring items in this app? (e.g., enter an item once and have it repeat every day, week or month)?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have no plans for a follow up video. I make videos when I receive multiple requests on a topic. I have ideas in my backlog with over 30+ requests

    • @siscovasallo
      @siscovasallo Před rokem +1

      @@RezaDorrani thanks anyways. Your videos are great! Thank you for sharing all this knowledge and tips. I was able to build a great app in days with little coding experience just by watching your videos!

  • @rukmanandhan4913
    @rukmanandhan4913 Před rokem +1

    Thanks for all your thoughts

  • @iulianburlacu
    @iulianburlacu Před rokem +1

    Awesome content Reza. This solved a lot of issues for me. Is it possible tho. to select multiple dates with this component?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Possible but would require a lot of changes to component. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @christinapeko999
    @christinapeko999 Před 23 dny +1

    Thanks❤

  • @cristinay4685
    @cristinay4685 Před rokem +1

    Hi Reza, thank you so much for this video. Could you make a video showing how to prevent the selection of certain dates? For example, I want to create an appointments app, but only Tuesdays and Thursdays are open. Thank you!

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I make videos when I receive multiple requests on a topic. No plans to make a video on this. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @marieraymond6512
    @marieraymond6512 Před 10 měsíci +1

    Your video is AWESOME as usual. Is there a way to create recurring events?

    • @RezaDorrani
      @RezaDorrani  Před 10 měsíci

      Most welcome!
      I am not aware of any option for creating recurring events via power apps.

  • @markbrown8315
    @markbrown8315 Před 10 měsíci +2

    Hi Reza, thanks for a great video. I was just wondering if there is a way to change this calendar to a Week view.

    • @RezaDorrani
      @RezaDorrani  Před 10 měsíci +2

      Welcome!
      There is no out of the box option to do that. You would need to update entire app to show the week view. Possible but not something I have tried.

  • @fanzfanzilla
    @fanzfanzilla Před rokem +1

    Hello RD, thank you for another valuable tutorial video. I downloaded the calendar app. I wanted to test it in my environment using your asset and travel SharePoint lists. It will be very helpful, if you could share both lists if possible with the sample data. Thanks again.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      They are based on the standard list templates asset and travel. Just create a list using those templates.

    • @fanzfanzilla
      @fanzfanzilla Před rokem +1

      Thanks RD. I appreciate it.

    • @fanzfanzilla
      @fanzfanzilla Před rokem

      A quick question is there a way to use MS Teams Shared Calendar in PowerApps?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@fanzfanzilla Not sure. Check on forums at powerusers.microsoft.com/

  • @user-jv7iq9hh4i
    @user-jv7iq9hh4i Před 8 měsíci +1

    amazing

  • @fundacionsancebrian
    @fundacionsancebrian Před 2 měsíci +1

    Great video with a perfect explanation. I have a question, how would I change the code if the week starts on a Monday? Thanks

    • @RezaDorrani
      @RezaDorrani  Před 2 měsíci

      Most welcome!
      The code is based on a template and there is logic where it probably reads day of the week to start from. I do not have a video reference on changing start day of the week scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @wendythiessen3718
    @wendythiessen3718 Před rokem +1

    Great Video! I have been learning so much from you, thank you for all the videos you make they are great!
    I am having one problem, once I have followed your instructions when I click on the button created on the calendar using the nested gallery, it goes to my form screen but it tells me "No item to display" do you have any idea why this might be?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Typical it relates to a misconfiguration with gallery and form. Video description has link to download app. You can check the logic in it.
      Alternatively, I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @home-tecserwiskomputerowyw5379

    Thanks, another wonderful recording! And can you tell us how to make one event that lasts several days and that overlaps another event display in one line?

    • @RezaDorrani
      @RezaDorrani  Před 2 dny

      Thanks!
      For event lasting several days on a line - this is something I would have to try it out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @alikarnib9776
    @alikarnib9776 Před 2 lety +1

    Awesome work.
    Might u perhaps know how to change the first day of the week?

    • @RezaDorrani
      @RezaDorrani  Před 2 lety +1

      That would require updates to the code base related to the template. There would be multiple changes needed. I would have to try it out to provide the steps.
      Always check the forums first to see if someone has done something similar. I just did and seems someone may have done it - powerusers.microsoft.com/t5/Building-Power-Apps/Change-calendar-page-starting-day-to-monday/m-p/501377#M152449

  • @Jenny-zr6xe
    @Jenny-zr6xe Před rokem +2

    Amazing video! A common scenario is that calendar events fall across a range of dates. At 16:40 you show how to make the dot visible based on the 'Due date'. How can we make the dots visible across a range of dates inclusive of 'Start date' to 'Due date', instead of just the 'Due date'? Thank you :)

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      You would filter on date range. I have done videos on gallery filters. I’ll recommend to check those videos.

    • @faizzatulshafika3152
      @faizzatulshafika3152 Před 6 měsíci

      Hi Sir, I'm having the same problem which i can't make the dots visble on the date range. I have seen the powerapps community platform but also fail. Mind to share the code for it if you got it? I've been stuck there for a week now.

  • @rafi9143
    @rafi9143 Před měsícem +1

    Perfect video, you also do mentoring or advice/support, I am doing a project with MS Dataverse as a data source. Kind regards.

    • @RezaDorrani
      @RezaDorrani  Před měsícem +1

      Most welcome!
      I do not offer 1:1 support.

  • @andythemouse
    @andythemouse Před 11 měsíci +1

    hi reza, thanks for sharing this, i created the calendar in my app following your video. there is now a request for a weekly calendar, wondering if you have a video for that?

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci +1

      I do not have a video on that. Check on forums in case someone has done something similar
      powerusers.microsoft.com

  • @brucemarriott3841
    @brucemarriott3841 Před 9 měsíci +1

    Awesome thank you just what I needed, I have struck a couple of issues where my Patient List exceeded 5000, so split into 3. How can I accommodate this scenario, the other thing is that I have Clinics on certain days (but not all) and want to add a placeholder to these days, and then add a selected Patient to that Clinic slot.
    I am a novice and appreciate your efforts, thank you showing the way.😀

    • @RezaDorrani
      @RezaDorrani  Před 9 měsíci

      Most welcome!
      I do not have any video references for your patient scenario. I would recommend checking or posting your query on forums in case someone has done something similar
      powerusers.microsoft.com

    • @brucemarriott3841
      @brucemarriott3841 Před 9 měsíci

      Thanks for that I will try the Forum@@RezaDorrani

    • @brucemarriott3841
      @brucemarriott3841 Před 8 měsíci

      Thanks again I decided to build from scratch, I have followed your demo but not getting very far, the Dots on calendar day do not show, the Visible property formula seems ok. I connected to Data source, select the date column, and return the Title field. Is there anything simple I may have missed ?
      Appreciated.

    • @RezaDorrani
      @RezaDorrani  Před 8 měsíci

      @@brucemarriott3841 I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @esterraful
    @esterraful Před rokem +1

    thank you for this tutorial! it already helped me a lot. I have only one question. How did you create a gallery inside of Month Gallery?i stuck at this point

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Video description has link to download sample app. You can check code in there.

    • @esterraful
      @esterraful Před rokem

      @@RezaDorrani thank you :) i found it. once again great tutorial

  • @michael498176
    @michael498176 Před 5 měsíci

    Great video, Reza! Is it possible to select a range of days using the calendar control?

    • @RezaDorrani
      @RezaDorrani  Před 5 měsíci

      Thanks!
      Not an option with the gallery control.

  • @radhakrishna.t8511
    @radhakrishna.t8511 Před 2 lety

    Hi Reza, it was very well explained. Is there a possibility to show 2 or 3 months data rather than a single month

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      Possible, it would require changing logic of the calendar control. Would be work.

  • @scarmentube
    @scarmentube Před rokem +1

    Great video! Thank you so much for your time and effort to share your knowledge, is very appreciated.
    I do have one question I haven't found an answer for yet.....hopefully you will be able to help.
    Do you know when you have the List and then you create the Calendar view from the list and when you click on a particular day of that calendar view, the default form for a new event will open and the Start Date is set for the date you clicked on the calendar.
    However, when I customize the form in power apps, I cannot find a way to map this behavior. I would like the power app form to also get the date the user has selected on the calendar when clicking +New........Do you know any way to do this?
    Thanks in advance!

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I have not tried this scenario. I believe Power Apps would probably not get information for the date the user clicked + new event on.
      I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

    • @scarmentube
      @scarmentube Před rokem +1

      @@RezaDorrani , thank you so much for your answer, I'll have a look. And once again, thanks for sharing with us.

  • @stephencuff
    @stephencuff Před rokem +1

    Magic work as usual Reza. In my instance I created similar to your Recruitment buttons - I have selected current month March. At the bottom of the calendar I can see some of the April events without any matching calendar boxes. I am struggling to debug this - if something leaps to mind as to why this is happing, I'd love the guidance. :)

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Calendar may show a few days of previous and next month depending upon number of days in current month. Is that your issue or is it showcasing april events in march month?

    • @stephencuff
      @stephencuff Před rokem

      @@RezaDorrani Hi Rezi, the calendar is showing April events in boxes that are not inside the 0-41 gallery boxes. They appear as if there were gallery boxes 43, 44 and 45.
      These 'overflow' events are correctly shown in the April view. Any helps to debug would be fantasic.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@stephencuff I am not sure about what the steps to fix would be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

    • @stephencuff
      @stephencuff Před rokem +1

      @@RezaDorrani Thanks Reza! Cheers.

  • @mercedescusi7653
    @mercedescusi7653 Před rokem +1

    Excellent video!! Any ideas on how I could schedule or program (from the form) certain tasks that are repeated ? for example, register just one time a task wich is repeated every day from monday 8 to monday 15 from 9 to 12hr and the callendar shows this task in each day automatically. thanks!!

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @iteachersl1016
    @iteachersl1016 Před rokem +1

    Supper

  • @robinisathakur
    @robinisathakur Před 2 lety

    That’s really good Reza! I get that this is a demo, but I s this sustainable on SharePoint, given the supported max of 500-2000 for a result set?

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      If delegation is taken into consideration, then Yes. I have built calendars with SP lists over 50k records.
      Delegation - czcams.com/play/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD.html

  • @rahullal2058
    @rahullal2058 Před rokem +1

    Great Video ,Thanks Reza. I have connected my work progress tracker everything looks fine , Would it be possible to change the fill of circle 1 to Red if the item is overdue ?.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Possible using formulas. I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

    • @rahullal2058
      @rahullal2058 Před rokem

      @@RezaDorrani Am trying with following formula in fill property of circle 1 , " If(LookUp('System Admin Controls','Actual date completion'=DateAdd(_firstDayInView,ThisItem.Value,Days)).'Due date'=LookUp('System Admin Controls','Actual date completion'=DateAdd(_firstDayInView,ThisItem.Value,Days)).'Actual date completion',Red,Green) " Due to some error on the formula it is not working as expected .

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@rahullal2058 Not possible for error checking here on chat. I would recommend posting your issue on forums powerusers.microsoft.com/

  • @alzsz6670
    @alzsz6670 Před 8 měsíci +1

    Awesome video, is there anyway we can disable the previous days from today ?

    • @RezaDorrani
      @RezaDorrani  Před 8 měsíci

      You can check if date < today and accordingly make the controls within calendar read only. This is not something I have a video reference for though.

  • @mayankranjan8154
    @mayankranjan8154 Před rokem +1

    Amazing Videos! At 18:41 u have shown how we are filtering the record from drop down. How you have populated user dropdown with all the created by name and ALL??

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Check video description. I believe I shared the App. You can check the code there + I have done many videos on gallery filtering (that include All logic). You can check those.

  • @artistlee5553
    @artistlee5553 Před 3 měsíci +1

    Thank you very much for the video. As a beginner, this vedeo is perfect for me! One question is, how can i expand my calendar vertically? It seems to extend parallel as your video..

    • @RezaDorrani
      @RezaDorrani  Před 3 měsíci

      Welcome!
      Not sure what extend parallel means. The calendar is a gallery and a gallery has scrollbar.

    • @artistlee5553
      @artistlee5553 Před 3 měsíci

      @@RezaDorrani 13:13 on your video, you could expand left and right of the copied calendar. But I would like to resize by expanding up and down..

    • @RezaDorrani
      @RezaDorrani  Před 3 měsíci +1

      @@artistlee5553 You can try that also but you would also need to adjust the template size of gallery. I have done detailed videos on gallery control so I will recommend checking that out.

  • @christerrussberg3059
    @christerrussberg3059 Před měsícem

    Hi Reza, great video as always. But I have a question regarding this calender. Do you see it possible to get a year view ie have all the months for current year as starting point of the app??

    • @RezaDorrani
      @RezaDorrani  Před měsícem

      Most welcome!
      Not sure if thats an option. Something that I haven’t explored

  • @berfinyldz571
    @berfinyldz571 Před rokem +1

    Hi Reza, thank you for all this information.
    I want to design a datepicker in this color labeled calender format for annual leaves. But I want to exclude holidays so that user can't select an holiday date for annual leave. Just like locking cells in excel. Do you know how I can solve this?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have done a video on calculating business days - czcams.com/video/QVvhDe6puq0/video.html
      May be a combination of logic in video linked and this one may get you there.
      I will also recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @NoCommentLeftUnsaid
    @NoCommentLeftUnsaid Před rokem +1

    Very thorough video, once again. I downloaded the app, but I wonder if you have a link to the list structure that you used? It takes a bit of trial and error to recreate it from the hints in the video.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Thanks!
      I do not have any links related to the list structure as there is no easy way to export SP list templates in modern SharePoint.

    • @NoCommentLeftUnsaid
      @NoCommentLeftUnsaid Před rokem +1

      @@RezaDorrani Thank you, the screenshot of the SharePoint list is then what I will work from!

  • @AmyCustomer
    @AmyCustomer Před rokem +1

    @Reza Dorrani I'm attempting to put the calendar only (the 5 components of it) into a container that is vertical. Of course it stacked everything. I put a horizontal container around the title and two arrows and that worked fine, the weekday names are fine, but in the calendar body I don't know how to vertically align the 3 components of the month view (title, subcircle, circle). I think I need a small vertical container but am unable to make that work No matter what I do, the little dot indicating an appointment is BESIDE the title and subcircle not under it. Can you do a quick video on how to do this within a responsive page that has both horizontal and vertical containers? It's the only thing that's not working right. Your video is awesome and I just need this help to make it look good. Thanks very much.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Hi Amy, thanks for liking the video.
      I would have to try it out and make a video on it. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted ideas get added to my backlog. I will recommend posting this idea in next topic suggestion post.

    • @AmyCustomer
      @AmyCustomer Před rokem

      @@RezaDorrani Thank you Reza, I will check out the monthly suggestions. But theoretically, wouldn't it work perfectly if PowerApps had a z-container? one that would allow you to stack elements on the z-axis? I think that would be the easiest way to solve this problem. Are you aware of anything that manipulates the z-index like containers that go horizontal or vertical?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@AmyCustomer Im not aware of that

  • @tomekliebert9282
    @tomekliebert9282 Před rokem +1

    Hi Reza,
    Thanks for the videos, your work and a lot of inspiration you give :)
    I have a problem with the "Travel request" calendar. The type of my cells in the Sharepoint table "Travel start date" and "Travel end date" are date and time. In a situation where I select the date 01/06/2022 without the time, it's ok (I can see the date in the calendar), but when I select the date with the time, e.g. 06.01.2022 11:10 (start) it doesn't show up on my calendar.
    Thank you very much in advance for your answer :)

    • @RezaDorrani
      @RezaDorrani  Před rokem

      It’s probably bcoz without a time element it take it as 12 am. I do not have any video references on this scenario or dates and times in power apps. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

    • @hazeyn
      @hazeyn Před rokem

      @@RezaDorrani Can you share or can anyone do to solve the hour and minute problem?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@hazeyn I recommend posting your ask on the forums.

  • @utoroprincewill7808
    @utoroprincewill7808 Před rokem

    Great video, a question, what if I want to use the form from Powerapps to book for 3 interviewees who will come for an appointment 3 days ahead from a current start date to an end date i.e say from 1/1/2023 to 3/1/2023, so in this case after the start to end date is specified the tool create the interviews 3 items in a recurring manner

    • @RezaDorrani
      @RezaDorrani  Před rokem

      This is a specific scenario and one that I would have to try out to know the steps. I will recommend checking on forums in case someone has done something similar
      powerusers.microsoft.com

  • @akshay._.solanki
    @akshay._.solanki Před rokem

    Hi Reza, Great information as always
    I learn so much from you about Power Apps
    In this video, when you are showcasing the color code calendar screen from 17:55 to 18:56
    I am trying to replicate the same scenario where I have a SP list with two date columns, start date and end date
    First, when I try to remove the circle and subcircle from the MonthDay Gallery I get errors
    Second, You mentioned to add second gallery inside of it which I tried as well but it is not showing the data in it as well
    By any chance can you put source code for those calendar gallery apps in your video description so I can take detailed peek into the code for specifically the color code logic calendar screen
    Thanks :)

    • @akshay._.solanki
      @akshay._.solanki Před rokem

      Also, the calendar is not showing todays date , do you know what could be the reason for that?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      The video gives a full walkthrough (step-by-step). I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @shannonmarceau
    @shannonmarceau Před rokem

    Rez, trying to recreate this in Teams using a list as the data source. When I go to add the button in your recruitment tracker scenario, I add the Filter( 'Recruitment tracker'., Interview Date' etc. My code is colored appropriately in that it looks correct, but I get an error that says 'This formula uses scope, which is not presently supported for evaluation' and I don't see the button in the calendar where I have events. Any Ideas?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @jerriciakambonde3123
    @jerriciakambonde3123 Před rokem +1

    Great video, thank you! I used a SharePoint list as my data source. Followed the steps in the video but my calendar in PowerApps does not display the events e.g. the dot on each day with an event. How to resolve this please? Thanks!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @adrianrodriguez2107
    @adrianrodriguez2107 Před 7 měsíci +2

    How could I set the calendar not in english format but in European format, so as to say, that the starting day of the week to be monday and the latest Sunday?
    Great video btw, very helpfull ^^

    • @RezaDorrani
      @RezaDorrani  Před 7 měsíci +1

      Thanks!
      I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @chulitoalbo3958
    @chulitoalbo3958 Před 6 měsíci +1

    HI! Great Video Reza! :) Is it possible to modify this calendar so that multiple date fields can be selected, marked, and when clicked again, the marking is removed? I would like to collect the marked date fields and store them in a SharePoint list. Thank You! =)

    • @RezaDorrani
      @RezaDorrani  Před 6 měsíci

      Possible by adding option for user to check multiple items in gallery. I dont have a specific video reference on it though.

  • @mangeshpg
    @mangeshpg Před 2 lety

    Hi Reza, Amazing video!
    By help of ur video i created the calendar in my powerapp, I have a sharepoint list, which has columns named date 1 to date 31, total 31 colums, i wanted to save the data a user enters for the particular date in the gallery, for example a user types "XYZ" on date 6, date 9, date 22 of the month, then XYZ should get saved as a one line item in respective date 6,9,22 columns in SharePoint list. Could u please guide me, what additional steps i can do?

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @txaussteve
    @txaussteve Před rokem

    I really love this calendar. It is amazing. Quick question, when scrolling forward, it stops on Dec 31, 2022. Can the calendar go into the new year and if yes, how?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      If you look at the standard template screen, it does allow beyond dec of current year.

    • @txaussteve
      @txaussteve Před rokem

      @@RezaDorrani Not sure if this is the correct approach, but I went to the right arrow (To advance to the next month which currently stops on December) I selected the visible property and found this: _firstDayOfMonth

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@txaussteve Not sure. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

  • @jjavi8685
    @jjavi8685 Před 2 měsíci

    Reza great Video, on the last section when you can click on an itemto go back to edit form data, how can I create new item clearing out the form, I am having an issue where the variable set does not clear when trying to add new items. Thanks!!!!

    • @RezaDorrani
      @RezaDorrani  Před 2 měsíci

      I did not understand the question. clearing form is resetform function

  • @sharadpatil1320
    @sharadpatil1320 Před 2 lety +1

    Hello Reza, How can we stop power automate flow going into the infinte loop ?
    Scenario - Let's say we have a flow which is getting triggered on update of account name field on account and is updating same field with microsoft dataverse's actions. This action will trigger our flow again and makes it to run infinitely.

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      Not exactly your scenario but czcams.com/video/oKN4_5o2NUA/video.html

  • @misterrat3036
    @misterrat3036 Před rokem +1

    Hello, Excellent contribution and help... However, I still have some doubts... What happens in the event that an event is overwritten on the same date and time. There is some way in powerapps to compare both fields and that in the event that you are choosing a date that already has an event, it will notify you that that date is already occupied. Is it possible to do that?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Possible! For that before adding event, you would need to query list to check if that date is already taken and accordingly notify the user.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@nicolascorreacavieres5392 I do not have a video reference on this and will have to try it out to provide the steps. I recommend posting your query on forums at powerusers.microsoft.com/

  • @erol9280
    @erol9280 Před rokem

    Hey Reza! Reaching out to learn if you have had a chance to think through how to customize the Calendar Control for Weekly Views? I suspect that might be helpful for a lot of folks.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I do not have video plans for a weekly calendar view.
      I make videos when I get multiple requests on a particular topic.
      Every quarter I ask subscribers for topic suggestions on the Community Tab of my CZcams channel.
      Subscribers vote for topics and the highest voted topics get added to my backlog.
      Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

  • @dahianaparramolina3044

    Good morning, I am trying to create a flow and I need a bit of help.
    i have 3 lists (customer complain - internal complain - improvement request) I want this to go into an app where the users can fill it up after this the reviewer will decide if this requires a corrective action if yes i want this to populate a 4th list moving the relevant column fields across, but also i want this 4th list to be a choice too in case someone wants to directly create a corrective action. my questions are
    1do I create the 4 lists and link them through a lookup formula?
    1 do I only create 3 l?
    what would be the best way to make this work, thanks for your help

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      This looks like a specific scenario and something that I have not done before. You could go either ways. Depends on a lot of factors (data source, capacity etc.).
      I recommend checking on forums at powerusers.microsoft.com/ in case others have done something similar.

  • @user-lq5xc2yt5l
    @user-lq5xc2yt5l Před 11 měsíci

    Hi, please can you make a video how to select multiple dates in this calendar template, Your videos are so helpful ,please post a video to select multiple dates , Thanks in advance

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci +1

      I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.

  • @FernandoGabrielRodriguez-mm8hl

    Hi, im using something similar to this, but to show meetings for people, and the issue that I have is that if I have a meeting with several participants on 1 day, it will show one button per participant, is there a way where I can just show only 1 button for that type of meeting? Say I have a meeting with 3 participants and the meeting type is "Review" and another meeting with 5 partcipants and the meeting type is "Evaluation" I want it to show 1 button for review and 1 button for evaluation

    • @RezaDorrani
      @RezaDorrani  Před rokem

      As long as your gallery items property is on meetings data source, it should work. I would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @rubenpuertosmartinez
    @rubenpuertosmartinez Před rokem

    can you setup the calendar? I have more than one clendar in my outlook and always is setting up my one, but I would like to set the calendar information to point to a shared calendar. Thanks again :)

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @user-um7cg4uu8w
    @user-um7cg4uu8w Před 6 měsíci

    thanks for this video, do you have more in depth explanation /video of how you created these 18:55 - Build Color Coded Calendar from SharePoint List
    21:57 - Connect Calendar with Form Control
    like how you did the form control , and drop downs in the color coded calendar.. etc..

    • @RezaDorrani
      @RezaDorrani  Před 6 měsíci

      This video is the best reference I have.
      Video description may have link to download sample app.