Read SharePoint List and Converst String to Date

[JFM_12]

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 actual date

Do you have an example or a hint how to do that.

Every line of the sharepoint list should be read and the column compared with the actual date.

Thank you 

JFM_12

[#2]

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.

[#3]

@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 User

[#4]

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

[#5]

Hi RobElliot
Thank you.
I know changed it to MM but still does not work.
Thank you
Regards
JFM_12

[#6]

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

[#7]

@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

[#8]

Hi @JFM_12 ,

as you proceed this much i think you must be already using action for Excel(file may be present in Sharepoint Documents or actual loaction).

addDays('30-12-1899',int(items('Auf_alle_anwenden')?['Start Date']),'dd-MM-yyyy') in this what exactly you were trying to do because if i understood correctly [Start Date] must be date format and you are trying to convert it to int which results error.(The template language function 'int' was invoked with a parameter that is not valid)

at place of items('Auf_alle_anwenden')?['Start Date'] use integer value.

[#9]

Hello Everbody
Thank you for your replies. Sorry for the confusion.
At the beginning and excel is sind to a sharepoint library (Date is string)
The Excel is stored in the format of a table.
This Excel is the filled in a sharepoint list
Now the column on that list is a string. I would like to fill the column as date format (dd.MM.yyyy).
I omitted this, sorry.
Regards
JFM_12

[#10]

Hello Everybody
Thank you for your answers.
I was able to resolve it.
Have great days.
JFM_12