cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patella
New Member

Autofill a dynamic collection

Hello,

I am trying to build a collection that includes the dates of all Mondays in a year.  For example in 2020 the records would be 6-Jan, 13–Jan, ... all the way to 28-Dec.  is this possible?  How?

Thanks,

Pat

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks @eka24 !

Your suggestion led me into the right direction and I found the same solution explained somewhat better (at least for me) here: https://www.dynamicpeople.nl/en/news/while-loop-powerapps/.  The timer trick works and if I make the control invisible it does not even impact the UI design.  All good!

Side-comment: I am just wondering how to best estimate the Duration property and what happens if I underestimate... my loop is quite simple and runs well even with 1 millisec.  Is there a real risk here and what is a possible mitigation (other than setting it very high, just to be on the safe side)?

(and it is a shame that there is no better way in PowerApps to build "proper" loops)

Regards,

Pat

View solution in original post

2 REPLIES 2
eka24
Super User
Super User

This post https://powerusers.microsoft.com/t5/Building-Power-Apps/Collect-weeks-between-two-dates/m-p/618947#M...

will address your request

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Thanks @eka24 !

Your suggestion led me into the right direction and I found the same solution explained somewhat better (at least for me) here: https://www.dynamicpeople.nl/en/news/while-loop-powerapps/.  The timer trick works and if I make the control invisible it does not even impact the UI design.  All good!

Side-comment: I am just wondering how to best estimate the Duration property and what happens if I underestimate... my loop is quite simple and runs well even with 1 millisec.  Is there a real risk here and what is a possible mitigation (other than setting it very high, just to be on the safe side)?

(and it is a shame that there is no better way in PowerApps to build "proper" loops)

Regards,

Pat

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,006)