Date formating

(0) Share

Report

Posted on by Richard_C

Hi this is my first post in the power automate (PA) community. I am really new to PA and have my first challenge.

I have created a flow that adds rows from Excel (OneDrive) and adds the information to a row in a SharePoint list.

This works fine until I tried this on a Dates Column in my spreadsheet. I understand that I need to add an expression to change the date. I have found the function show below which I want to add the date from the dynamic content list.

addDays('1899-12-30',int(ADD DYNAMIC CONTENT HERE),'yyyy-MM-dd')

However the excel date column that I wish to add is not showing in the dynamic contact list show below.

Could you please tell me what I am doing wrong. Apologies if I have not explained this very well.

Richard

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Richard_C,

Where are you adding this expression? Is this in an action within an apply to each loop?

Below is an example how you could approach this.

Was this reply helpful? Yes No
Richard_C 6 on at

Like (0)

Report

Hi

thanks for the quick reply. I am trying to add the expression here
Richard

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @Richard_C,

Yes, it should be possible to add a similar kind of expression over there. Change the column name to the name of your column from Excel.
addDays('1899-12-30', int(items('Apply_to_each')?['YourColumnNameFromExcel']),'yyyy-MM-dd')

Was this reply helpful? Yes No
Richard_C 6 on at

Like (1)

Report

Thank you I will try again later today or in the morning

Was this reply helpful? Yes No
Flowriano 3 on at

Like (0)

Report

It helped me too bro, thanks a lot!

Was this reply helpful? Yes No