Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Issue with recurrence trigger and any date compose

(0) ShareShare
ReportReport
Posted on by

Hello, I cannot use a date formula in a Data Operations - Compose action. I tried to use the formula convertTimeZone(triggerBody()?['ReservedUntil'],'UTC','Romance Standard Time','yyyy-MM-dd') but when I try the flow I am getting an error message like InvalidTemplate. Unable to process template language expressions in action.

I tried with a different trigger type (Sharepoint for example) and the same formula in a Data Operations - Compose works fine.

recurrence.PNG

ReservedUntil is a field in a SharePoint list. I need the formula above because without the timezone conversion, I cannot make the date field equal to today's date. 

Is anyone have any idea to circumvent this problem please? If you need more information to understand my problem, please tell me.

  • AlanPs1 Profile Picture
    AlanPs1 2,471 on at
    Re: Issue with recurrence trigger and any date compose

    Hi @SalemB .

    Unfortunately I am unable to translate the error.

    Where I would start is expanding the successful run on:Capture-365.png

    If you post the JSON Output it may be the case the format of the date and time relating to "triggerBody()?['ReservedUntil']"

     

    It may be that this needs formating before it can be converted.

    Some useful links for you in the mean time:

    https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

    https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#converttimezone

    I will get another look once you reply with the output and date format of ['ReservedUntil'].

     

    Thanks, Alan

  • SalemB Profile Picture
    SalemB on at
    Re: Issue with recurrence trigger and any date compose

    Hello Alan, thank you for your answer. I tried your proposal but it gives me the same kind of error messageconv1.PNGconv.PNG

     

     

  • AlanPs1 Profile Picture
    AlanPs1 2,471 on at
    Re: Issue with recurrence trigger and any date compose

    Hi @SalemB , thank you for your post.

    I tested your expression using utcNow() and it's working for me.

    What may be helpful is to use the "Convert time zone" action.

    Please see below:Capture-360.png

    If you have found my post helpful, please mark thumbs up.

    Any other questions, just ask.

    Thanks, Alan

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,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard