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 :
Power Platform Community / Forums / Power Automate / Generating Dataverse R...
Power Automate
Unanswered

Generating Dataverse Records

(0) ShareShare
ReportReport
Posted on by 40

I need some help on creating a flow for this. 

 

Given the following requirements:

Frequency - Number of records

Interval (In Years)

 

How do you generate Dataverse records based on that using an on-demand flow given that those fields are dynamic? I know for sure you can't use Delay as it only works for 30 days. I've used Do-Until to run until the number of records are met but I don't know how to distribute them over a given Interval. 

 

Appreciate your thoughts. 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,175 Most Valuable Professional on at
    Re: Generating Dataverse Records

    Hi @mkxx96,

     

    You could use a range function to create an array of the Frequency - number of records. Within an apply to each you can loop through those items and calculate the interval of the current item and add it to a new row.

     

    Below is an example

     

    1. A range function in the apply to each

    range(1,triggerBody()['number'])

     

    2. Multiply the current item with the frequency and add it to the current year to find the next interval year.

    add(int(utcNow('yyyy')), mul(item(),triggerBody()['number_1']))

     

    range_multiplyinterval.png

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard