Answered

Power Apps Date and Microsoft List

(0) Share

Report

Posted on by DHall-1

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DHall-1 ,

I've made a test for your reference:

1\I assume there is a SharePoint list

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

Best Regards,

Bof

Was this reply helpful? Yes No
DHall-1 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DHall-1 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No