You’re offline. This is a read only version of the page.
Announcements
3
Hi dear colleagues,
I need you help regarding a flow in Power Automate.
I have created a flow to return values from an excel table to PVA. Basically, in PVA user write a name of an account/company managed by my team, this company name is the imput used to look up this value in the table and return the column with the account manager name of this corresponding line. The point is I am not having success in two situations:
I am adding here some screenshots to illustate:
Excel Table:
Flow:
Success test: Bot ask user to type account name: "basf" and flow returns the name of its manager "Andrea":
Error as point 1 mentioned above - User type "BTG" while data in table is "BTG Pactual", with this an error is faced:
Error 2 as mentioned above: User types an account which is not listed in the table "panasonic"
Many thanks in advance for all help and support.
Best wishes,
Allyson
You can do a Filter Array in the flow after retrieving all the rows from the table. Set the array filter to use the operator Starts With or Contains depending on whether you want to force the user to get the first part right or just any partial word in the name.
Then use a condition on the output of the filter array and check the length of the output. If no match was found it will be 0. If a match was found it will be 1. Set variables in the yes or no side based on what you want to send back to the bot.
Share
Report
All responses (
Answers (
