Forum Discussion
JFM_12
Sep 03, 2021Iron Contributor
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...
suvi-15
Sep 06, 2021Brass Contributor
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.
JFM_12
Sep 06, 2021Iron Contributor
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
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