Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

COMPOSE

(0) ShareShare
ReportReport
Posted on by 8

Hi guys, i got a problem evaluating formulas when a i get the text of the formula from a get item into a compose, i have this list where i have formulas depending o wht trigger do i have, but when i get the coincidence of the formula is not working in the compose, but when i put the same exact text but direct into the compose it works, maybe am missing something on the prefix for power automate to be capable of evaluating it. I appreciate your help

  • David_MA Profile Picture
    David_MA 8,952 on at
    Re: COMPOSE

    I think a screen shot is the best explanation. This is using the classic designer:

    David_MA_0-1713889246213.png

    When you put the cursor in the Compose action, the menu on the right should open. You just need to choose the Expression tab and paste your expression in without the @. Of course, this assumes your expression is valid. I cannot tell since I don't have a list with the same dynamic content and actions you have.

  • Rzelaya Profile Picture
    Rzelaya 8 on at
    Re: COMPOSE

    Hi david, how can i use the expression builder?

  • David_MA Profile Picture
    David_MA 8,952 on at
    Re: COMPOSE

    Based on your screen shot and the text you posted of your expression, did you just paste your expression with the @ symbol into the Compose action? If so, that may be your problem. You need to do two things:

    1. Remove the @ symbol from the start of your expression. That is only used in trigger conditions.
    2. Then use the expression builder to populate the expression into your compose action. If your above expression is valid, you can just remove the @ and then go to the expression builder and past it there, then insert it into the Compose action.
  • Rzelaya Profile Picture
    Rzelaya 8 on at
    Re: COMPOSE

    There is no way i can make it work?

  • Chriddle Profile Picture
    Chriddle 7,315 on at
    Re: COMPOSE

    If I understood correctly, you're trying to evaluate a string as an expression at runtime.
    This is not possible with Power Automate.

  • Rzelaya Profile Picture
    Rzelaya 8 on at
    Re: COMPOSE

    Hello, no problem

     

    I have this formula that attends an azur doc intelligence model, i have this master that indicates the model depending on the trigger, whats the problem is when i tried getting this formula from the get items and put it into a compose the formula arrives as a text instead of recognizing it and evaluating to extract the value from the model. but when i put the sam exact formula directly into the Compose it evaluate the formula and extract the value without any problem: this is the formula when i get it from the list

    "@if(contains(outputs('Analyze_Document_for_Prebuilt_or_Custom_models_(v3.x_API)')['body']['analyzeResult']['documents'][0]['fields']?['Inv_vendor']?['valueString'], 'Maersk'), outputs('Analyze_Document_for_Prebuilt_or_Custom_models_(v3.x_API)')['body']['analyzeResult']['documents'][0]['fields']?['Inv_date']?['content'], if(contains(outputs('Analyze_Document_for_Prebuilt_or_Custom_models_(v3.x_API)')['body']['analyzeResult']['documents'][0]['fields']?['Inv_vendor']?['valueString'], 'RANSA'), outputs('Analyze_Document_for_Prebuilt_or_Custom_models_(v3.x_API)')['body']['analyzeResult']['documents'][0]['fields']?['Inv_date']?['valueDate'], if(empty(outputs('Analyze_Document_for_Prebuilt_or_Custom_models_(v3.x_API)')['body']['analyzeResult']['documents'][0]['fields']?['Inv_date']?['content']), '01/01/1900',replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(outputs('Analyze_Document_for_Prebuilt_or_Custom_models_(v3.x_API)')['body']['analyzeResult']['documents'][0]['fields']?['Inv_date']?['content'], 'ENE', '01'), 'FEB', '02'), 'Nº', '03'), 'ABR', '04'), 'MAY', '05'), 'JUN', '06'), 'JUL', '07'), 'AGO', '08'), 'SEP', '09'), 'OCT', '10'), 'NOV', '11'), 'DIC', '12'))))"

    Rzelaya_1-1713280968964.png

     

    Rzelaya_0-1713280436612.png

    when i put it directly i get the actual value of the date.

     

    I tried to explain myself the best i can, if something is missing let me know

     

  • Re: COMPOSE

    Hi @Rzelaya ,

    Please go to the edit page and post a screenshot of the complete configuration parameter of your flow.

    The more information you provide, the more likely I will be able to help you solve the problem.

     

    Best Regards,

    Sunshine Gu

     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics