Automatically update only month and year when match the date

(0) Share

Report

Posted on by pritadewii

190

Hi.

I want to update the date on excel list automatically, but I just wanna to update the month and year only. Is this possible? and how to make a flow with this condition?

example:

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (2)

v-jefferni on at

Like (0)

Report

Hi @pritadewii ,

Could you please share more details? Do you have two tables in Excel worksheet?

Best regards,

Was this reply helpful? Yes No
pritadewii 190 on at

Like (0)

Report

Hi @v-jefferni thank you for replying.

No, I don't have two tables in excel, only one. I want to update those 3 columns with today's month and year (the date is not included, still the same).

Example:
BillingDate ReminderDate DueDate
2023-12-11 2023-12-12 2023-12-13

the "yyyy-MM" could change dynamically when match the month and year

Do you know how to solved this? Thank you.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @pritadewii ,

Still not sure of what you want to do to the table. But you can use addToTime function in expression to add 1 month to each field dynamic content.

I assume the Update a row action is inside an Apply to each control, then the expression for BillingDate filed will be as follows:

addToTime(items('Apply_to_each')?['BillingDate'],1,'Month','yyyy-MM-dd')

Best regards,

Was this reply helpful? Yes No
pritadewii 190 on at

Like (0)

Report

Thank you for the answer @v-jefferni

What I mean is I want to update the date (only month and year) at the column more dynamically. Example today is December 2023 so the column value "2023-12-11", the next month (which is January 2024) the column automatically update month and year, so the column value "2024-01-11", for the next month again is February 2024, the column value contains "2024-02-11". The date always has same value that is 11.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @pritadewii ,

May I have a look at your real Excel table? You can cover sensitive info, snapshot and attach it in your reply.

Best regards,

Was this reply helpful? Yes No
pritadewii 190 on at

Like (0)

Report

this is my excel list:

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report

Hi @pritadewii ,

If you need to add 1 month to the three columns of all the entries, you can just use a List rows present in a table action, Apply to each, then Update a row. In Update a row action, the fields of the three columns use the expression I wrote before.

Best regards,

Was this reply helpful? Yes No
pritadewii 190 on at

Like (0)

Report

Hi @v-jefferni

Thank you, I've just tried your advice and I think it works on my flow.

Was this reply helpful? Yes No