Hi all,
Please bare with me, I am totally clueless. I have no experience with coding or calling functions but i'm trying to get by with the vast amount of knowledge that is available.
Unfortunately I have run into an issue and I can't solve it.
I'm building a chatbot that finds (gets) a row from an excel sheet.
Triggerphrase = Contact details store
Question = Are you looking for the contact details of a store? Please type in the name of the store.
Identifier = User's entire response
Then is followed a power automate call action that finds the string in an excel sheet and outputs the store name, phone number and email address.
Now it all works fine, until the user inputs a store name that is not in the excel sheet. So lets say in my excel there are store names like "Big Shop Town, Lower part side Shop, Shopalicious'. But when I enter a store name thats not there i get a 2003 error and i get a few other error messages.
My problem is: I can't for the life of me figure out how to add a function that recognizes the entry was faulty and the chatbot will ask a question like 'I cant find this store, do you want to search again?'. Because now the bot just kind of crashes and stops.
Here is my PVA flow & PowerAutomate Flow:PVA flowHere is mHHere
I tried it now again, but with the following run after settings and it works also, thanks!
You can't have two return variable actions. The two parallel runs should come together at the point of the return action.
If you look at the error message it is saying it failed because the other set variable was skipped. That's why the run after setting for the return action needs to be set to allow that set variable to be skipped.
@Pstork1 sorry for the confusion, but i had to create a new login because my old one didnt work anymore.
I tried it again and now a correct input will give the site details.
An incorrect input will give the error. Set Variable 2 won't communicate with the return value:
Remove The skipped check from the Variable 2 action. That should only run if the Get Rows fails. Otherwise it looks correct. Can you provide a screenshot of what a run looks like? The green check marks should help with troubleshooting.
@Pstork1 sorry i got confused, it will output when the SiteName is wrong, but give an error when the SiteName is correct. It can't seem to bring the values over to the variable...?
@Pstork1 alright, now it gets interesting. I added the run after setting as per your screenshot. But now, when I enter the correct site name it will output 'Site Not Found' and when I enter a wrong site name it will give an error..
Based on the screenshot you haven't set the Run After setting on the return. It should look like this. If it was set there would be a little i in a circle like there is for the variable 2.
@Pstork1 yes, im a bit lost now. After I set the Run after setting on variable 2 it stopped working also on the Site Not Found variable.
This is the setup now, by logic i think it should work.
I will try to rebuild it and see what happens.
FOr now all run after settings have been set: