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...
Hi JFM_12 ,
Using Flow you can fulfill your requirement
Here i used trigger option as When item created but if you don't want to use this option then there is Recurrence (Timer) option which you can set to trigger min/sec/hr option to trigger comparison.
for Formatting date (Compose step)
formatDateTime(triggerOutputs()?['body/TestDate'],'dd-mmm-yyyy')
I hope this helps for you.
- Hello Suvi-15
Thank you very much.
I am getting an Excel-List that is read from flow
But the column is stored as string.
Need to convert it to date and compare it with a date.
Is this possible?
Regards
JFM_12 suvi-15 your formatDateTime is incorrect as in Power Automate months are formatted with capital Ms. Lowercase ms are for minutes.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserHi RobElliot
Thank you.
I know changed it to MM but still does not work.
Thank you
Regards
JFM_12- 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
