web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps Date and Mi...
Power Apps
Answered

Power Apps Date and Microsoft List

(0) ShareShare
ReportReport
Posted on by 18

On my Power App, I have dates set start to end. The entries are then placed on a shared Microsoft List. If staff would like to take leave for 02/19 - 02/23. That is how it would be entered and that is how it is placed on the List. Is there a way the date can be fixed to  automatically separate into individual days on the list, such as 02/19, 02/20, etc? 

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @DHall-1 ,

     

    I've made a test for your reference:

    1\I assume there is a SharePoint list

    vbofengmsft_0-1708650712118.png

    2\Formula

    With(
     {
     Start:Date(2024,2,19),
     End:Date(2024,2,23)
     },
     ForAll(
     Sequence(DateDiff(Start,End,TimeUnit.Days)+1,0,1),
     Patch(
     BofTest0223,
     Defaults(BofTest0223),
     {LeaveDate:DateAdd(Start,Value,TimeUnit.Days)}
     )
     )
    )

    3\Result

    vbofengmsft_1-1708651028011.png

     

    Best Regards,

    Bof

     

  • DHall-1 Profile Picture
    18 on at

    Can you do a screenshot of where I should place this at in my app? I am still new to building Power Apps.

  • DHall-1 Profile Picture
    18 on at

    Still looking for assistance on where I would enter the formula above to split the dates that was entered on the Leave Power App and placed on Microsoft List

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard