Forum Discussion
Read SharePoint List and Converst String to Date
Hello I would like to do following task: 1. Read a SharePoint List with a date-column (formatted as string) 2. Convert the data within this column into date (dd.MM.yyyy) 3. Compare it with the ac...
Hello
I tried to use this as formula:
addDays('30-12-1899',int(items('Auf_alle_anwenden')?['Start Date']),'dd-MM-yyyy')
But got following error:
" InvalidTemplate. Unable to process template language expressions in action 'Start Date' inputs at line '1' and column '2795': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. "
I know there are many of this posts.
Read them but....
JFM_12
I tried to use this as formula:
addDays('30-12-1899',int(items('Auf_alle_anwenden')?['Start Date']),'dd-MM-yyyy')
But got following error:
" InvalidTemplate. Unable to process template language expressions in action 'Start Date' inputs at line '1' and column '2795': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. "
I know there are many of this posts.
Read them but....
JFM_12
JFM_12 your first post said you were using a SharePoint list but now you are talking about getting the dates from Excel. Which is it as it affects the answer?
Rob
Los Gallardos
Microsoft Power Automate Community Super User