Forum Discussion

JFM_12's avatar
JFM_12
Iron Contributor
Sep 03, 2021

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...
Microsoft Flow
sharepoint
suvi-15's avatar
suvi-15
Brass Contributor
Sep 06, 2021

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.
RobElliott's avatar
RobElliott
Silver Contributor
Sep 06, 2021

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

  • JFM_12's avatar
    JFM_12
    Iron Contributor
    Sep 06, 2021

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

    • JFM_12's avatar
      JFM_12
      Iron Contributor
      Sep 06, 2021
      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
      • suvi-15's avatar
        suvi-15
        Brass Contributor
        Sep 07, 2021

        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.

Resources