Hello,
I am experiencing an issue with the flow I am building, and I would appreciate the community's help in resolving it. Here are some statements about the flow and its functions:
- The flow retrieves data from an Excel table.
- The data is then sent to a SharePoint list using an HTTP request.
- The SharePoint list contains different data types, including classic, date format (yyyy-MM-dd), number, and single line of text.
The issue occurs at a particular step, which is shown in the attached picture. I have tried using various formulas, but none of them have resolved the issue.
if(empty(items('Apply_to_each_3')?['StartDate']), null, formatDateTime(addDays('1899-12-30', int(items('Apply_to_each_3')?['StartDate'])), 'yyyy-MM-dd'))
if(empty(items('Apply_to_each_3')?['StartDate']), '', formatDateTime(addDays('1899-12-30', int(items('Apply_to_each_3')?['StartDate'])), 'yyyy-MM-dd'))
if(empty(items('Apply_to_each_3')?['StartDate']), '1900-01-01', formatDateTime(addDays('1899-12-30', int(items('Apply_to_each_3')?['StartDate'])), 'yyyy-MM-dd'))
Every time I am getting this error:
Cannot convert a primitive value to the expected type 'Edm.DateTime'. See the inner exception for more details.
clientRequestId: 1f1d6fb3-8075-400a-b372-111b2755f481
serviceRequestId: f912ada0-b074-6000-7f2a-27f4091d0660
I am new to this forum and I am hoping to receive assistance from the experts here.
Thank you in advance for your support and guidance.
