You’re offline. This is a read only version of the page.
Announcements
18
Hi There.
I have a Flow that Updates a Sharepoint List from an Excel file with a Condition in. (If the item already exists, update item, if not, create item).
I have tried to add dates in and my date columns in Excel are 'Start Date' and 'End Date' but I keep getting the same error, and I have read and watched numerous resources.
Error message:
InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Expressions I'm using:
Here is my Flow:
Appreciate your help.
Hi @MelB10
Set the date format to ISO8601 in the List row present in a table so that you don't have to use the addDays function.
After setting the format, just use the formatDateTime function to convert it to the 'yyyy-MM-dd' format.
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn
Best Regards,
Levi
Share
Report
All responses (
Answers (
