COMPOSE

[Rzelaya]

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

[v-yetonggu-msft]

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

[Rzelaya]

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'))))"

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

[Chriddle]

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

[Rzelaya]

There is no way i can make it work?

[David_MA]

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]

Hi david, how can i use the expression builder?

[David_MA]

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

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.