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

All responses (5)

Answers (1)

Flowriano 3 on at

Like (0)

Report

Re: Date formating

It helped me too bro, thanks a lot!
Richard_C 6 on at

Like (1)

Report

Re: Date formating

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

Expiscornovus 31,635 Most Valuable Professional on at

Like (1)

Report
Re: Date formating

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')
Richard_C 6 on at

Like (0)

Report

Re: Date formating

Hi

thanks for the quick reply. I am trying to add the expression here
Richard
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

Re: Date formating

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.