Answered

Compose and variables

(0) Share

Report

Posted on by tguihur

Hi everyone,

I have a ms Forms which trigger my flow. In the Form I have an formNumber that start with a number following by letters. What I want to do is read that number and set a variable with an email. I have 50 emails.

For exemple.

If my formNumber start by 001 then variable is "asdadf@gmail.com

If my formNumber start by 002 then variable is asdfd2@hotmail.com

if my formNumber start with 003 then variable is asdfaei.casj@gmail.ca

I dont want to use the conditional in PowerAutomate because is going to be so long. So I wonder if I can use COMPOSE instead.

Anyone can help me with this please.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

ScottShearer 25,294 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@tguihur

If I understand you correctly, you have 50 separate email address that you may want to assign to the variable. If that is the case, then I suggest storing the numbers from the form along with the related email addresses in a SharePoint list or Excel table. Then, just lookup the email address. You can then store that information in either a compose action or variable. Then reference the variable or compose action as needed.

As a general rule, you should use a compose action unless you'll need to update the value. Compose actions are much more efficient than variables.

Let me know if you need additional help implementing the lookup or extracting the form number.

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ScottShearer, could you please explain why you said "Compose actions are much more efficient than variables"?
What' the difference in terms of efficiency?

Was this reply helpful? Yes No
ScottShearer 25,294 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@VictorIvanidze

My understanding is that variables need to be evaluated every time you reference them and Compose actions do not. Therefore Compose actions run more quickly and theoretically will consume fewer API calls, etc..

Here is a link to a great video by @MattWeston365 that explains when and why to use each.

Was this reply helpful? Yes No
tguihur 46 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @ScottShearer for your answers and explanations.

Was this reply helpful? Yes No