Power Platform Community Forum Thread Details

I have a flow set up to send a reminder to managers a day before their employee's birthday, and it works correctly when I create a list through Sharepoint and individually add each row, but when I try to connect my flow to a list that has been uploaded from excel (with the same column titles and same order), the formatDateTime formula doesn't work.

formatDateTime(items('Apply_to_each')?['Birthday'],'MM-dd')

I updated the Birthday column on the new list from excel to have the same settings as the original Birthday column. What's the difference between creating a list in Sharepoint and uploading a list from Excel into Sharepoint?

Categories:

Building flows

@FinanceHR I'm a bit unclear on the issue you are having. Are you unable to get your Excel date into SharePoint? If this is the case, you'll need to ensure you've set the DateTime Format in the List Rows Present in a Table action to ISO8601.

Otherwise it'll output a serial date number.

I have a YT short that talks about why the formatDateTime() function will not work on a serial date number.

However in this short — I use an expression to return a date format. This expression isn't necessary if you select ISO8601 as the DateTime Format, the date will output as a timestamp—which is what the formatDateTime() function requires.