Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Answered

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

(0) ShareShare
ReportReport
Posted on by 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.debug1.PNGdebug2.PNG

  • kgreen8790 Profile Picture
    kgreen8790 189 on at
    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 Profile Picture
    Todd2 on at
    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics