cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deno81
Regular Visitor

Power Virtual Agents Flow (Get User Information o365)

Hello all,

 

i am trying to use a Question "Who are you looking for" is the question to get a input from the person using the bot.

 

What i am wanting to do is not to display the users information that is interacting with the bot bust for it to search the o365 users to display the requested information

deno81_0-1647770884627.png

deno81_1-1647770915760.png

 

Im getting the following error i cant resolve

 

Here is the flow. i dont want to resort to exporting the o365 users to excel then searching off that as staff change all the time.

 

deno81_2-1647771048531.pngdeno81_3-1647771082113.pngdeno81_4-1647771106012.png

 

Here is the flow working till the end

deno81_5-1647771382920.pngdeno81_6-1647771458223.png

deno81_7-1647771501788.png

deno81_8-1647771555740.png

 

 

Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0': 'The template language expression 'outputs('Get_user_profile_(V2)')?['body/displayName']' cannot be evaluated because property 'body/displayName' cannot be selected. Array elements can only be selected using an integer index.

 

Can you please help?

 

3 REPLIES 3
Expiscornovus
Super User
Super User

Hi @deno81,

 

A quick question to double check. Do you want to return a single person as a result or a set of people which match the search?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Jcook
MVP

Hello @deno81 ,

 

You want to avoid the apply to each loop. PVA will not accept array values.

So you can use the expression first() to get the first UPN of the result from Search Users action.

Keep in mind this will have a limitation if the organization has duplicate display names, etc.

Example:

Jcook_0-1648187872389.png

first(outputs('Search_for_users_(V2)')?['body/value'])?['UserPrincipalName']

Now you can use the dynamic content of Get User Profile (V2), without being inside a loop.

 

Bypass Apply to each Loop – Flow Alt Delete – Josh Cook [Microsoft MVP]

Getting User Details To Use In Power Virtual Agents (Teams) – Flow Alt Delete – Josh Cook [Microsoft...

 

Thanks!

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





ArchitectMadhan
Super User
Super User

Hi @deno81 ,

For your scenario, even you get the user details using the Get User from the Apply to Each statement, you have to assign the user information to variables, only then you will be able to assign those values to the response parameters.

ArchitectMadhan_0-1648216011701.png

 

 

- Architect Madhan

Please click the "Accept as Solution" button and give thumbs up, if it is helpful to you.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,745)