Power Virtual Agents Flow (Get User Information o365)

[deno81]

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

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.

Here is the flow working till the end

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?

[Expiscornovus]

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?

[Jcook]

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:

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!

[ArchitectMadhan]

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.