Answered

need help with code to select email addresses in a drop down box to then assign in power automate

(0) Share

Report

Posted on by mccowatts

I have the variable; Set(
varESWRequestServiceManager,
drpServiceManager.Selected.Value
);

with the drop box where staff can select an email address. I'm using this variable in Power Automate Approvals with the variable in the assign to section. It's giving me the error that it can't recognise the email address. If I put in one of the addresses in the assign to box it does not fail so isn't an issue with the email but instead the variable not being able to find the address in the drop down box.

I'm very new to power automate and power apps and any help would be hugely appreciated

Thanks

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mccowatts ,

What's the formula you used in dropdown?
Does it contains only emails or records where email ID is present?

To check in simple way, add a label on your screen as use the following code:
Do check if you only get email as text
drpServiceManager.Selected.Value //OR drpServiceManager.Selected.Email

Once you get email in label then the syntax is correct and pass that in your variable as
Set( varESWRequestServiceManager, Text(drpServiceManager.Selected.Email) );

Let me know if this works
mccowatts 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help. There's only email addresses in the drop box items. It won't let me add 'Email' at the end of the code. Say's it's not recognised
Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mccowatts ,
Could you provide screenshot of the error and where you are facing it?
mccowatts 20 on at

Like
a
(0)

Report
Copy link

Link copied!
Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mccowatts ,

I just tried passing the email in flow and it successfully triggered using email ID.

I found a related post with same error: Check the post if this helps
Also, make sure the email is in proper format else the flow will fail.

Hope this helps
mccowatts 20 on at

Like
a
(0)

Report
Copy link

Link copied!

How do I change to an email ID? Sorry very much a newbie!
Verified answer

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mccowatts ,
I used a argument for my flow.

Similarly, how are you passing the data to your Flow?
What's the trigger that you are using?

Suggesting to use Instant Flow,
Step 1: You can use PowerApps (purple) connector from Instant Flows.
Step 2: In the Flow, where you have 'AssignedTo' add dynamic value as 'Ask from PowerApps'
Step 3: Connect the Flow in your App
Step 4: As you will run the flow, code brackets will tell you the this flow has certain parameters required.
Step 5: Pass your variable and trigger the flow

Hope this gives you an idea.
mccowatts 20 on at

Like
a
(0)

Report
Copy link

Link copied!

this is how I'm doing it with an initialise variable;
and start and wait for an approval;
Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Okay @mccowatts ,

I hope you are passing the variable in your Flow,
Syntax would be like,
FlowName.Run(varESWRequestServiceManager) //Considering that your 1st argument in Flow is Email parameter then pass variable to the Flow in the 1st argument itself
Note: Handle Null values too else your flow will fail

So is the flow running by setting proper data from the App in your Flow? (Check data passed in each step from Run History of Flow)

As you mentioned that email is proper,
So if a proper value passed and set then your Flow will Approval action will trigger correctly.