Share
Report
3Hi 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:
- User types partial name of the account, not matching exactly with data in Excel, and then an error due for this. Example: User inform to bot "Exxon" and in excel data is "Exxon Mobil". How should I add a condition where in the flow where I return a column when a certain cell "contains" part of the text informed in chatbot?
- Error if user types a company/account name not listed in table. How should I create a rule if value is not find in table, return a text like "this is not a managed account"?
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
All responses (
Answers (
