Answered

How to get multiple rows from Power Automate to PVA?

(0) Share

Report

Posted on by TomDDD

HI all,

I have been succesful in getting a row based on a user input. User input will see if present in column A and then give out the value on the same row in column B.
But this only works for one line.

Now I want to create a flow with column A (person name) and column B (city). PVA will ask what city you are looking for and I want power automate to spit out all the person names that live in that specific city.

How can I best do this?
Any help is greatly appreciated, i'm not very knowledgable on power automate.

Thanks!

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (14)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @TomDDD,

Are you using SharePoint for the data?

If so, you could use a Get Items action with a Filter Query for this. After that you could use a Select action to only select the display name of the person. With a join you could turn it into a comma separated string value.

Below is an example of that approach.

This example assumes that the person name column is of type person or group in the SharePoint list.

1. This is an example list

2. This would be the Power Automate flow. The Filter Query filters for the correct City.

The result variable uses this expression:

join(body('Select'), ', ')

3. This could be your topic.

Hope this helps a bit?

Was this reply helpful? Yes No
TomDDD 55 on at

Like (0)

Report

@Expiscornovus , thank you this is very helpful. But what if my list is not on Sharepoint but uploaded as Excel into a Teams group?
At the moment I use get row from a Teams group/channel.

Will the above work also with an excel list uploaded to Sharepoint?

Many thanks!

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @TomDDD,

Yes, that could work as well. In that case you could use a list rows present in table with a filter array action.

Below is an example of that approach.

In my setup it uses an Excel stored on OneDrive, but you could also use one from SharePoint.

The flow setup.

Was this reply helpful? Yes No
TomDDD 55 on at

Like (0)

Report

@Expiscornovus this is amazing, i can feel that its close but its not working yet.
The chatbot output is empty:

I feel that it may go wrong at the Select action because I am not able to select the right column in the drop down:

It should give me the option to select the column name (which in this case is Site Naam)

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @TomDDD,

When you cannot find it in the Dynamic content you can also add it as an expression. Select the Expression tab instead and just type it over there.

Was this reply helpful? Yes No
TomDDD 55 on at

Like (0)

Report

@Expiscornovus I did that, but unfortunately it is not outputting any data 😞

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @TomDDD,

Can you share a screenshot of your Power Virtual Agent topic setup? Can you also share a screenshot of your Excel table? Just want to double check a couple of things 🙂

Was this reply helpful? Yes No
TomDDD 55 on at

Like (0)

Report

@Expiscornovus
Sure! Thanks for your help 🙂
Here is the last part of the flow, everything at the top works as expected

And here is the excel sheet, heavily censored:

Was this reply helpful? Yes No
TomDDD 55 on at

Like (1)

Report

@Expiscornovus oh it works, the cityname is case sensitive! I had to type it in capitals.
Is there anyway i can not make it case sensitive?

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @TomDDD,

It tries to match a string, that is unfortunately case sensitive. A workaround could be that you convert whatever the user types in your bot to upper case as well with a toUpper function. This way it will match the same case format.

However, this also means that the Stadskanaal column values (alle plaatsnamen) should be in upper case as well in the source (in your Excel sheet). I see that Bolsward, Hedel & Beverwijk currently are not in upper case format. For those three instances this workaround would not work.

You could apply this workaround in the Filter Array action.

Was this reply helpful? Yes No