Unanswered

List rows present in a table date format issue

(1) Share

Report

Posted on by sjb2020

Hi,

I have a SharePoint online list with some fields being date format - i am trying to add data from an excel file into my list using the list rows present in table action then create item action - however the flow keeps failing due to date format from excel not being in correct format I get below error:

error power app.png

I have tried formatting the date in excel to yyyy-MM-dd as other posts have commented but I still continue to get this error. Any ideas how I can get the excel data into the format power app will accept.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report

Hi @sjb2020 ,

Format your date in Excel as Text and send Text(YourDate,"dd/mm/yyyy") or whatever your date format is.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

@sjb2020

It looks like you're receiving this error from the Flow, rather than Power Apps. In this case, you can call the formatDateTime function against the input Excel date value in your create_item action.

https://support.microsoft.com/en-us/topic/how-to-customize-format-date-and-time-values-in-a-flow-34a91243-2961-d98c-c010-e385858b19cd

Was this reply helpful? Yes No