Skip to main content

Notifications

Calling Actions from Copilot Studio
Answered

How to get multiple rows from Power Automate to PVA?

Posted on by 55

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:
  • Thaodoan Profile Picture
    Thaodoan 6 on at
    Re: How to get multiple rows from Power Automate to PVA?

    Hi,

     

    I would like to deploy the chatbot with the idea that:

    Background: I have many applications, and we have some common questions related to application and I would like to build the chat bot to help users answer those common question. I think Chat Bot can search information in Sharepoint/Document Library because we have specific document/main site for each application and then returning answer for user.

    Is it possible to create Chatbot above? and How I can do with that?

    I am looking forward to hearing from you

     

    Thank you,

    Thao Doan

  • Re: How to get multiple rows from Power Automate to PVA?

    @TomDDD  I'm trying to achieve the same thing you're doing but seem to be stuck on the stage where I'm not getting any output... I'm aware of the case sensitive nature, and I've only tested it with the same case (Which use to work in my old flow with Get Rows instead of list rows, but it would only list 1 item) I'm going to implement the case sensitive fix, but I wanted to get the output first... 

     

    @Expiscornovus  you've put a great solution together! Do you know if things have changed in power virtual agent or why this could possibly not be working with me? I'm essentially trying to do the same exact flow, except I my bot would ask the user for an Acronym, then tell them what it stands for. My file is also on Sharepoint. 

    Attached is my power automate and excel screenshots: 

     

    Really appreciate any help on this!

     

  • Expiscornovus Profile Picture
    Expiscornovus 29,332 on at
    Re: How to get multiple rows from Power Automate to PVA?

    Hi @TomDDD,

     

    Ja, ik ben Nederlands 😁

     

    Great to hear it works.

  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: How to get multiple rows from Power Automate to PVA?

    @Expiscornovus **bleep**, such a boss! It works 🙂
    Are you Dutch? Since you used a few Dutch words in your reply 😄
    Big thanks!

  • Expiscornovus Profile Picture
    Expiscornovus 29,332 on at
    Re: How to get multiple rows from Power Automate to PVA?

    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.

     

    toupper_city.png

  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: How to get multiple rows from Power Automate to PVA?

    @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?

  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: How to get multiple rows from Power Automate to PVA?

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

    TomDDD_0-1649675331561.png

     

    And here is the excel sheet, heavily censored:

    TomDDD_2-1649675579171.png

     

     



  • Expiscornovus Profile Picture
    Expiscornovus 29,332 on at
    Re: How to get multiple rows from Power Automate to PVA?

    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 🙂

  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: How to get multiple rows from Power Automate to PVA?

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

    TomDDD_1-1649674787863.png

     

     

  • Expiscornovus Profile Picture
    Expiscornovus 29,332 on at
    Re: How to get multiple rows from Power Automate to PVA?

    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.

     

    itemsitename.png

     

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics