web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Based on a condition, ...

Power Automate

Answered

Based on a condition, add 30 days more in a column

(0) Share

Report

Report

Posted on by JasonCastro

111

If these conditions are respected, I need to take the value of the [END_DATE] column and do the following calculation: ([END_DATE]+30 days - current date), and save this value in the column [TIME_EXPIRE]

I tried to use the add days function, but I couldn't do the math bringing the values of the column [END_DATE]

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JasonCastro

Do you want to get the time difference between the end date plus 30 days and the current date, this store this value to the column Time Expire?
Based on your description, I have made a simple test for your reference.
1. Here is the flow:
div(div(sub(ticks(addDays(items('Apply_to_each')?['EndDate'],30)),ticks(utcNow())), 10000000), 86400)

2. Result:

Best regards,
Sylvia

Was this reply helpful? Yes No

Join the conversation