Unanswered

Unable to export date field in excel sheet from sharepoint list using PowerAutomate

(0) Share

Report

Posted on by Nandita_m

I have a Sharepoint list that has a date field in "MM/dd/yyyy" format that needs to be exported into an excel sheet. I am using add a row into a table function and am able to see the date field value in the input section of the function but not in the output section. There is no error in the flow, just that the date field is being completely ignored.

Example:

The input section of the add a row into a table function

"Type": xxxxxxxx

"end date": "06/02/2022",

"Time Type": xxxxxxxx

The output section however, ignores the date row altogether.

"Type": xxxxxxxx

"Time Type": xxxxxxxx

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@Nandita_m ,

A screenshot of the input and output might help.
Don't know if that matters, but you could try to use formatDateTime(YourDate,'MM/dd/yyyy') and see if that helps

Was this reply helpful? Yes No
Nandita_m 18 on at

Like (0)

Report

The thing is, I can see the value of the row("If fixed provide end date") in the right format in the input section of "Add a row into the table" function but not in it's output. It's like the field - "If fixed provide end date" just vanishes. All other rows of the excel file are flowing correctly.
Screenshot attached
I tried making that particular column in the template excel file as type "Date", but even that did not help. I also tried using different options of the "Datetime format" field within the Add row into table function, even that did not help.

It's somehow not recognizing the "If fixed provide end date" field and writing into the excel. I am not able to figure out where it's going missing between the input and output

Was this reply helpful? Yes No
Verified answer

Nandita_m 18 on at

Like (0)

Report

Okay! Found the issue - there was a column name mismatch from the input source (Select filter) and in the create table function I was using. Basically, there was an extra space between the words of the column name in the Select filter and not in the Create table function, and the input value in the last step was not able to map to the column because of that. Just one space caused so much of an issue.

Was this reply helpful? Yes No