You’re offline. This is a read only version of the page.
158
Hi, I am stuck in here for a day now thinking about this. Hope someone can help.
I have a basic flow that will read an (Excel File) and get every Column Data and add it to Sharepoint List.
While it reads every other Data inside the Excel. Unfortunately, it doesn't return any data when it comes to the Date/Time Column
Flow:
Excel File:
Sharepoint List:
Create Item:
Thank You @sanbss . That works just fine.
It causes that special character available on the excel column name(Date/Time). Include the below expression to resolve it.
items('Apply_to_each')?['Date/Time']
Let me know if this works for you.
Ensure that the DateTime format adheres to ISO 8601 to obtain the proper format on SharePoint.
Regards,
Santhosh Balakrishnan
Apps4.Pro(http://www.apps4.pro) - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.
Product Specialist
When I tested it.
these are the Outcome on Create Item:
#1
WarrenBelz
146,552
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
