Unanswered

Model Driven app Data Import

(1) Share

Report

Posted on by HarrisonP04

Hi Guys,

I have a requirement whereby I need to pull in all 52 weeks of the year every single year into my model driven app as records in an entity called Weeks for example. This entity will then be used to generate Timesheets from for employees to submit.

Could anyone point me in the right direction for how I could solve this please?

Thank you very much, Harrison.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (1)

Report

Hi @HarrisonP04,

Try creating an instant Power Automate flow which creates a number range of 1-52 then add those numbers as rows in your Weeks entity then run the flow once.

More info on Power Automate number ranges:

https://d365demystified.com/2021/11/07/range-function-in-power-automate-quick-tip/

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
HarrisonP04 10 on at

Like (1)

Report

@KeithAtherton That's worked perfectly, Thank you very much. I now just need to figure out a way to get this to work so that I can generate weeks for 5 years in advance for example but im thinking maybe I can put a year field on the week record and do it that way.

Thank you mate.

Was this reply helpful? Yes No
KeithAtherton 3,705 Most Valuable Professional on at

Like (1)

Report

My pleasure! Thanks for the update, great to hear you got it working.

Great idea, I'd go for that too (example below).

You could use a loop in a flow to add 1-52 for 5 years (loops).

Year Week

2023 1

2023 2

... ...

2024 1

2024 2

... ...

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No