News and Announcements icon

Power Platform CommunityForums Calling Actions from Copilot Studio List rows present in a...

Calling Actions from Copilot Studio

Answered

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

(0) Share

Report

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 Img

All responses (2)

Answers Img

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.

Helpful resources

News and Announcements

Important Update on New Community Platform

Quick Links

Leaderboard

#1

WarrenBelz 138,287

#2

RandyHayes 76,308

#3

Pstork1 63,172

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans