Announcements
Hi All ,
When I utilize a flow to import excel table to a list , an error occurs as below message.
The format of the column in excel as below:
the format or sharepoint list column as below:
Thanks a lot
Hi @GUOGUO ,
Please refer to this post
formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Date']),-2)),'yyyy-MM-dd')
Thanks
--------------------------------------------------------------------------If I have answered your question, please mark my post as a solutionIf you have found my response helpful, please give it a thumbs up
Hi Eric
Thanks a lot.
Though, how should I use the expression to convert the column that I get from Excel table.
1. Clear out the field
2. Click on the field
3. Click on the 'expression' tab in the flyout
4. Paste the below in and replace xxxx with the column name in Excel. If you renamed your Apply to each loop, you will need to change that too.
formatDateTime(addDays('1899-12-30', int(items('Apply_to_each')?['xxxx'])),'MM/dd/yyyy')
Hi Eric .
Thanks for your solution. Though , it doesn't work. Could you please help to check ?
Can you please take a screenshot of the loop from your get items and confirm the column from your excel is LIB Global Item Status? If possible, please add an output of this field and share the value.
Yes,the Column in Excel named as
I am not sure why you have the 'Apply To Each 3' loop. You should be able to move the 'Create Item' action out and into 'Apply To Each 2'. Then update your expression to:
Apply_to_each_2
You can try updating the expression first and see if it works too but looks to be alot of actions which are required.
Thanks a lot ,i will try
I build a similar flow so you can copy it.
1) Excel with datetime column
2) Get Tables and then List Rows Present In Table
3) For each row, Parse JSON value and then use the below formula
4) Finished result
Thanks a lot ,Eric
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 293
David_MA 262 Super User 2026 Season 1
Expiscornovus 223 Most Valuable Professional