web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Generating Dataverse R...

Power Automate

Unanswered

Generating Dataverse Records

(0) Share

Report

Report

Posted on by mkxx96

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)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,768 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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']))

Was this reply helpful? Yes No

Join the conversation