You’re offline. This is a read only version of the page.
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 |
Thanks , will have a check and will update you
Hi @Arunkumar333 ,
I understand now. You can use below expression in Update a row action:
Share
Report
All responses (
Answers (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,
Hi , i have updated the question, thanks for taking to reply , can you pls check now
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.
Best regards,
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
