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!
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
@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 **bleep**, such a boss! It works 🙂
Are you Dutch? Since you used a few Dutch words in your reply 😄
Big thanks!
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.
@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?
@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:
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 🙂
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.