Answered

Changing the date Based on Condition Using power automate flow

(0) Share

Report

Posted on by Arunkumar333

I am new to Power automate, any idea is much welcome pls

I am creating a recurrence flow , the condition is a new date should be created in the column new based on the condition , condition is if the column date should be updated to today + 90 days plus it should be pushed to end of month .

ex - date 31/08/2023 , then the date i want to autogenerate using the flow is today + 90 days (7/8/2023 + 90 ) and it should be pushed to end of month , so the date i want is Nov/30/23 , is this possible with power automate?

stage	company	date	new
stage1	HCl	12-10-2023
stage2	TCS	31-11-2023
stage3	TCS	21-06-2023
stage3	HP	02-04-2023
stage4	HP	07-08-2023
stage1	HP	08-05-2023

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Arunkumar333 ,

Could you please share more details about your scenario? I cannot understand the condition you was saying. Using the table you provided, please complete it in the "new" column assuming today is 8/7/2023.

stage company date new

stage1 HCl 12-03-2023 ?

stage2 TCS 31-05-2023 ?

stage3 TCS 21-06-2023 ?

stage3 HP 02-04-2023 ?

stage4 HP 07-04-2023 ?

stage1 HP 08-05-2023 ?

Best regards,

Was this reply helpful? Yes No
Arunkumar333 18 on at

Like (0)

Report
Copy link

Link copied!

Hi , i have updated the question, thanks for taking to reply , can you pls check now

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Arunkumar333 ,

I understand now. You can use below expression in Update a row action:

subtractFromTime(addToTime(startOfMonth(addToTime(items('Apply_to_each')?['date'],90,'day')),1,'month'),1,'second','dd-MM-yyyy')

The logic is:

1. add 90 days to current date column value

2. get the start of the calculated date

3. add a month to this day to get the start of next month

4. subtract 1 second to get the last of the month

Best regards,

Was this reply helpful? Yes No
Arunkumar333 18 on at

Like (0)

Report
Copy link

Link copied!

Thanks , will have a check and will update you

Was this reply helpful? Yes No