You’re offline. This is a read only version of the page.
Announcements
112
Hi All,
I'm wanting our chatbot to ask for two values, work out a resulting value, then provide the answer. Simply eh!!!
So far I have managed to create a flow which takes these values and adds them into an Excel worksheet. The worksheet then does the calculation. All good so far.
What I am struggling with is getting that answer from Excel back to the chatbot. Any ideas?
As an example, the values in cells A4 and B4 come from the chatbot entries. I now want the chatbot to give value D4 as the answer.
Any assistance would be greatly appreciated.
Thanks
Lee
Hi @lascough20,
You could use a list rows present in table action with a filter on the Load and Angle fields and use the chatbot entries as input. After that you can return the Slip field value of that matching row.
Have a look at this Read from Excel PVA example:
https://powerusers.microsoft.com/t5/Building-PVA-chatbots-in/Read-from-Excel-file/m-p/1645271
Share
Report
All responses (
Answers (
