List rows present in a table doesn't work if an item has a letter in it

(0) Share

Report

Posted on by kgreen8790

189

My chatbot calls a flow for "list rows present in a table" to do an inventory search which works well as long as the part number doesn't contain any letters, but when the part number starts with a letter it throws an error (see images attached to this post for specific error). I made sure that the chatbot is passing in a "string" variable and verified that it is identifying it as a string in the flow also so why is it throwing the error if a letter is present? I thought a string variable would accept any characters regardless of type. Any help with this would be greatly appreciated.

Categories:

Flow Integration

Power Automate Flows

All responses (2)

Answers (1)

kgreen8790 189 on at

Like (1)

Report

Re: List rows present in a table doesn't work if an item has a letter in it

I did try double quotes but that failed also. However, after your suggestion I gave it another try with single quotes and this worked just fine. Thank you.
Verified answer

Todd2 on at

Like (0)

Report

Re: List rows present in a table doesn't work if an item has a letter in it

Have you tried putting quotation marks around the "G25661"? Since it is a string, this might help.