dropdown with displayname writes email

[Robinhood]

I have a SharePoint Online list with 4 lookup columns. One is lookup list is PMA and it has 3 columns in it: Title, email, and name, where title is a single line of text populated with first last names, email is their company email address, and name is a person/group field with DisplayName listed.

SharePoint won't let me use the name column as the lookup field (or this would just work!) So if I populate the lookup using the Title column the form dropdown shows me a list of users to choose from as a list of Firstname Lastname choices. The chosen value is populated in the list just fine. When I run the flow (power automate) with a send an email (V2) and choose the dynamic PMA (value),  the workflow fails because firstname lastname is not recognized. 

So if I change the lookup to use the email column, the list I get of email addresses is possible to use, though sub optimal for users to choose from, and results in an email address stored in PMA (value), which does not fail in the flow.

My question is, how to show a list of names in drop down that then writes the email to the value?

Regards,

/Robin

[Robinhood]

so the direction I'm heading in today is take the value of the PMA lookup (Firstname Lastname) and write it into a hidden people group data card that I will subsequently exploit in the Automate flow to follow. Looking at Patch function to do this...

[alrez]

Hi,

I would have to see your PowerApp and Flow set up. It looks like you set something up across both platforms and I'm not certain exactly where the issue is occurring to know what the best area would be to fix would be. This might be a better question to bring to the Microsoft Support team. I'll include a link on how to reach out to them below.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Robinhood · Accepted solution]

I ended up creating 3 text fields in the SharePoint list, that I make not visable in the form, then put a lookup in the data default that looks like this: LookUp('PMAlist',Title = DataCardValue17.Selected.Value,Email) that essentially pulls the value set in the combo box dropdown. Since it pulls from the list column that contains the email address I need to put into the Power Automate, all is good.