Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

@formatDateTime in "Update File properties" Help needed

(1) ShareShare
ReportReport
Posted on by

I have a "ModelYear" column in SPList formatted as Date field.

In PowerApps I am passing Text(drpMfgYear.Selected.Value) to a Run call to flow:Run(Text(drpMfgYear.Selected.Value)) along with some other fields required by flow.

In the flow, I have formatDateTime(triggerBody()?['Updatefileproperties_ModelYear'],'yyyy').

Flow fails with error message:

Unable to process template language expressions in action 'Update_file_properties' inputs at line '1' and column '1935': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Integer'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

 

What am I doing wrong? Please help.

 

FlowError8Aug2018.PNG

  • Re: @formatDateTime in "Update File properties" Help needed

    @v-yamao-msft wrote:

    Hi @Anonymous,

     

     

    I am trying to pass date value from PowerApps to the column via flow.

     

    Best regards,

    Mabel Mao


    Hello SIr Mao,

    Thankd for your replay and suggestion. Your test condition differs from mine. I am getting an error that I am passing Integer Value instead of time date value to the flow . I tried to create a time date value and then pass it to the flow but I still get the error.

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: @formatDateTime in "Update File properties" Help needed

    Hi @Anonymous,

     

    According to your description, I have created a flow likes below, it doesn’t return any error message as you mentioned.

     

    There is Date column in the SharePoint library. I am trying to pass date value from PowerApps to the column via flow.

     

    The flow is triggered by PowerApps button, in the Due date column, using the following code to format date time.

    formatDateTime(triggerBody()['Updatefileproperties_DueDate'],'yyyy-MM-dd')

    1.PNG

     

    On the app, I get the date from a DatePicker control.

     

    When I click the PowerApps button, the flow is triggered then the DueDate is updated properly.

     

    Please take it for a reference.

     

     

    Best regards,

    Mabel Mao

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics