Answered

Adding days to date until certain date

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I want to create a loop that will run until dates passed from PowerApp: Date1 = Date2, lets say there is 3 days difference in date and for each date i want to create a new item on SharePoint list, how should i increment Date1 by 1 until it meets Date2 date?

As if im going to use adddays(date1,1) inside the loop it will never increment over date1+1 value

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous

Hey there. Check out a "Do Until" loop. With that, you can basically do exactly what you're asking about by going until the two dates equal.

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
Verified answer

rsaikrishna 3,703 on at

Like (5)

Report

@Anonymous

Created a sample to address your requirement.

Took 3 variables:
varDateFromPowerApp : Assuming as value coming from PowerApps
varDate2: Date value available locally to compare.
varTempDate: For temporary usage in the flow.

Expressions in the below IF condition:
Left value: formatDateTime(variables('varDateFromPowerApp'),'MM/dd/yyyy')
Right value: formatDateTime(variables('varDate2'),'MM/dd/yyyy')

Here is the entire Do Until block:

Expressions in Do Until:
Left value: formatDateTime(variables('varTempDate'), 'MM/dd/yyyy')
Right Value: formatDateTime(variables('varDate2'),'MM/dd/yyyy')

Compose action Expression:
addDays(formatDateTime(variables('varTempDate'),'MM/dd/yyyy'),1)

Please review the above flow and let me know if you have any questions.

Regards
Krishna Rachakonda
If my reply helped you solving the issue, please mark the reply as Accepted Solution.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Anonymous

The solution proposed by @rsaikrishna will likely work for you. However, you'll want to put a Delay action inside of the loop and set it to a one day delay. Otherwise, the loop will just run continuously a few times and create a few SharePoint items within a few seconds.

Also, you'll want to click on "Change limits" inside of the Do Until loop. The default for the loop is to run for the lesser of 60 loops or 1 hour(it shows as PT1H). You'll want to change it so that it will run for a number of days. For example, to run for 7 days, set the time out to P7D. Also ,remember that a Flow can run for a maximum of 30 days.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ScottShearer Thanks for your tips! I actually do want to create separate entries on my list 🙂

@rsaikrishna that worked perfectly! Thanks!

Was this reply helpful? Yes No
Julien Groud on at

Like (0)

Report

Thanks for sharing your answer and feedback.

Was this reply helpful? Yes No
leipapuu1 14 on at

Like (0)

Report

Help needed and much appreciated...

I was happy to find this post, as I was facing simimlar question. However, for some reason the solution is not working for me.

I have a flow that sends a Forms pro survey invite to a contact. If the contact does not answer before set reminder date (7 - 14 days after) is reached, the flow will send him/her a reminder email. I am trying to use Do Until step to create a wait-condition similar to old workflows: wait until a date field is passed. Giving users the possibility to update the date field manually while the waiting period is on. The Do-Until-step simply won't react to my condition, even though the previous Compose-step shows it is true.

I also tried to use this in the Do-Until-step, it didn't work either:
@equals(greaterOrEquals(formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd'), formatDateTime(variables('ReminderDate'), 'yyyy-MM-dd')), true)

The part of the flow looks like this:

The test run looks like this, and stays like this until the flow stops (due to timeout) in an hour or so.

Was this reply helpful? Yes No
leipapuu1 14 on at

Like (0)

Report

This problem was elsewhere and I solved it.

I was using the data queried in the do-until-step after the step. This is obviously not allowed. That caused the problem in my case. So the date comparison clauses are ok and works with the do-until-step.

I do think that it is quite difficult to debug the do-until-step. It took me 3 days to understand, what is the problem since the workflow instance logic is hidden until all the delays are completed.

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (0)

Report

Hi @rsaikrishna we followed your step by step. It works for us. However it is not giving the last date. Out of 5 whole days from start to finish, the output is 1st day, 2nd day, 3rd day, 4th day. The 5th day, which is the same as the end date, is not being created. Any ideas? We use the "is equal to" in the condition...

Was this reply helpful? Yes No