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

Community site session details

Session Id : rBa/nQMc5AYurbxV9APiRF
Power Platform Community / Forums / Power Apps - Building Power Apps / Model Driven app Data ...
Power Apps - Building Power Apps
Answered

Model Driven app Data Import

Like (1) ShareShare
ReportReport
Posted on 18 Oct 2023 10:49:31 by HarrisonP04 10

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:
Dataflows
I have the same question (0)
  • Verified answer
    KeithAtherton Profile Picture
    KeithAtherton 3,690 Most Valuable Professional on 18 Oct 2023 at 11:07:52
    Re: Model Driven app Data Import

    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.

  • HarrisonP04 Profile Picture
    HarrisonP04 10 on 18 Oct 2023 at 11:16:30
    Re: Model Driven app Data Import

    @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.

  • KeithAtherton Profile Picture
    KeithAtherton 3,690 Most Valuable Professional on 18 Oct 2023 at 11:21:02
    Re: Model Driven app Data Import

    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.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans