QUiero un flow que guarde en un excel segun una fecha y otro campo que me diga los dias transcurridos restando la fecha del dia de hoy menos la fecha que tengo
Solved! Go to Solution.
Hi @guriemar,
Could you please share more details about your requirement in English?
Where are the excel saved in?
Will the date in excel table always in a same year?
I have made a test on my side and have created a excel table as below:
you could refer to screenshot below to crete the flow:
The expression in the Compose as below:
div(sub(ticks(utcNow()),ticks(items('Apply_to_each')?['Date'])),864000000000)
The flow would run successfully as below:
Best regards,
Alice
Hi @guriemar,
Could you please share more details about your requirement in English?
Where are the excel saved in?
Will the date in excel table always in a same year?
I have made a test on my side and have created a excel table as below:
you could refer to screenshot below to crete the flow:
The expression in the Compose as below:
div(sub(ticks(utcNow()),ticks(items('Apply_to_each')?['Date'])),864000000000)
The flow would run successfully as below:
Best regards,
Alice
Thanks for your support, just what I needed
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
27 | |
22 | |
15 | |
13 |
User | Count |
---|---|
141 | |
42 | |
42 | |
34 | |
30 |