How to get Planner assignee ID from PowerApp

[NosajNap]

Hi all,

I am currently creating a PowerApp where I would like the user to select name(s) from a list, "Assignee(s), then when the user "Submits" the form, it will trigger a flow where it takes the User(s) chosen such as Jason Pan, and assigns them to a task?

Currently it says I need to either have the User ID or email so is there a way for me to map Jason Pan -> jasonpan@email.com type of thing or Jason Pan ->3h32nj32n3ju2n32jnj32 

Any suggestions on how I could go by doing this? Thanks! 

[Mr-Dang-MSFT]

@NosajNap, 

It sounds like you want to take a the name of a user who will be assigned to a task, and map it to either their email or Id.

You can do this with the Office365Users connector. Add it as a connection and use the SearchUser function with the name of that user as the search term (or a control where their name is stored). Then make it return one result. The results should have Id, Mail, and UserPrincipalName which you could reference for this purpose.

+ @BrianKnight who has a video on using the Office365Users connector:

https://www.youtube.com/watch?v=ytiGr0sH0co

[v-xida-msft · Accepted solution]

Hi @NosajNap ,

Could you please share a bit more about your data source? Which data source do you use to store your form data? A SP list?

Could you please share a screenshot about your flow's configuration?

I assume that your data source is a SP list and the Assignee(s) column is a Person type column in your SP list, and your flow use the "When an item is created" trigger of SP list connector as the Trigger.

I have made a test on my side, please take a try with the following workaround:

Note: The AssignedTo column is a Person type column in my SP list, on your side, you should type your Assignee(s) Email dynamic content here.

If your data source is not a SP list, and you use "PowerApps" trigger button as the Trigger of your flow, you could consider pass the corresponding Assignee(s) person email to your flow:

Within your app, you need to create a flow connection to above flow. Then add the following formula within the "Submit" button:

'YourFlowName'.Run(AssigneesComboBox.Selected.Email)

Note: The AssigneesComboBox represents the ComboBox control within your Assignee(s) Data card.

More details about trigger a flow from an app, please check the following article or video:

Start a flow from an app

https://www.youtube.com/watch?v=1wl9AtxWdkg

In addition, if you have obtained the Assignee User name within your flow already, in order to get the email address of this person, I think the Office 365 Users connector could achieve your needs. I have made a test on my side, please take a try with the following flow workaround:

Within the "Create a task" action, Assigned User Ids field set to following formula:

first(body('Filter_array'))?['DisplayName']

Please take a try with above solutions, then check if the issue is solved.

Best regards,

[NosajNap]

Hey @v-xida-msft ,

I am currently trying out this solution. I am wondering how I could make the O365 connector work for a set of users? (multiple selection from combo box).

From what I have gathered from other sources, it seems that I would need to make a logic similar to Excel's VLOOKUP() OR IFS() function in the PowerApp. Then use that as an input to the flow, rather than trying to do it through a flow which is what I think is complicating the process. What do you think? 

An elaboration on the "VLOOKUP()/IFS()" function:

=VLOOKUP([NAME_Input],A1:B10,2,False)
NAME_input: Jason Pan
Output: jasonpan@email.com

OR 

=IFS(A2="Jason Pan","jasonpan@email.com",A2="Nosaj Nap","nosajnap@email.com") 

^ how could I achieve something like this in through PowerApps? (Preferably more similar to the VLOOKUP as this list would consist of 20-30 people)

Thanks! 

[NosajNap]

Hey @Mr-Dang-MSFT,

I can't seem to open the video. I have tried multiple browsers and vpn connections. I will try again at another time, thanks for the resource though!