Hey everyone,
I am currently in a situation where we have a chatbot in PVA and would like a user to be able to write a zipcode and get information back about what department they should contact. So as a user I should be able to write my zipcode, then get back the department name and contact-information. I am trying to build a flow that accomplishes roughly this:
User inputs a zipcode
Zipcode is passed to the flow
Flow connects to Sheets
Based on the zipcode find the row
Extract three variables from that row for contact information, webpage and department name
Return these two to PVA for the user.
I have this currently:
I get access to the sheet just fine, but I am not sure how to only get the row that I want, and then to split it up. Any help is appreciated.
Thanks again, everyone.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
76 | |
20 | |
17 | |
14 | |
13 |
User | Count |
---|---|
128 | |
35 | |
29 | |
28 | |
25 |