How to Create Loop based on Start Date

(0) Share

Report

Posted on by krfajar

153

Hi All,
I newbie in Power Automate.
I have field Start Date and End Date, created as many months as input.

Example:

I have a Start Date = 04 May and End Date = 04 July

Then the billing will be made as many months as the input.

Billing 1 = 04 May (Start Date+7)

Billing 2 = 04 June (Start Date(04 June)+7))

Billing 3 = 04 July (Start Date(04 July)+7))

if my logic is like this how should I create it?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Use your list with the Start date and End date as the data source. Then create a recurrence flow that runs at whatever interval you want to use to check whether a bill should be sent or not. In your case its probably either monthly or daily depending on whether the start dates are all the same day of the month. When the flow runs you will do a Get Items on the list. Then evaluate the start date to see if its less than UtcNow() and whether the billing has already been done (see comment in next sentence about last billing). If it is then do the billing for that record and update the start date (or another field like last billing) to the current date. Then the next time you start the flow do the same thing again and it will do billing for anything that is due that hasn't already been done.

Was this reply helpful? Yes No
krfajar 153 on at

Like (0)

Report

Hi @Pstork1 thanks for your response.
Please review my flow. Is this what you mean?

Thank you

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Please break your screenshot up into multiple files. The resolution on this one is too low to make out any details.

Was this reply helpful? Yes No
krfajar 153 on at

Like (0)

Report

Hi @Pstork1 Please review

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Yes that will run once a month. But there isn't really enough detail to figure out what you are trying to do. For example there are two loops that both run on value. I assume one is from the first Get Items and the other is from the second but which is which? Then you have a condition, but I can't see what's in the formula you are evaluating. Its hard to tell what this flow is supposed to accomplish without a lot more of the details about the logic involved.

Was this reply helpful? Yes No
manzil 21 on at

Like (0)

Report

Was this reply helpful? Yes No