Skip to main content

Notifications

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

Get a Row action Not Found

(0) ShareShare
ReportReport
Posted on by 271

Hi all,

 

Within my topic I have an option to find an existing item within an excel table with the user entering a number to locate this using a flow within my topic. If the user enters a valid number it works perfectly, but if the user enters number that doesnt exist within the table then the bot fails with the details below:

 

Gwill1983_0-1645616685095.png

How do I add an option after this failure for the user to re-enter the number or to leave the chat?

 

 

Categories:
  • Verified answer
    Gwill1983 Profile Picture
    Gwill1983 271 on at
    Re: Get a Row action Not Found

    @amydeng I have solved the issue that I was having....

     

    After the initial search entry I have added another flow to check if the entry is in the list. Then running a condition within the Bot to send different messages based on the output.

     

    The new flow is as below:

    Gwill1983_0-1646414735055.pngGwill1983_1-1646414757916.png

     

    Formula within Set Variable is 

    length(body('List_rows_present_in_a_table')?['value'])
     
    This then gives you a number of rows based on the original entry in the bot that you can run a condition against within your bot flow. 
     
    Let me know if this helps, or if you need anymore info

     

     

     

  • Gwill1983 Profile Picture
    Gwill1983 271 on at
    Re: Get a Row action Not Found

    Can anybody help with this?

     

     

  • Gwill1983 Profile Picture
    Gwill1983 271 on at
    Re: Get a Row action Not Found

    Hi.

     

    So, my current flow looks as below:

     

    Gwill1983_0-1645788118110.png

    Gwill1983_1-1645788166173.png

     

    When a user enters a serial number that isnt within the excel file, it fails as below on the Get a row step of the flow:

     

    Gwill1983_2-1645788245920.png

    Obviously, I dont want this to just return a failure to the bot. I want it to alert the user that the serial number they have entered doesnt exist. 

     

    Do you have any idea how to do this? I have tried all sorts and just cannot find a solution! 

     

    If you could explain your theory a little clearer then I will be able to test it

  • amydeng Profile Picture
    amydeng 2 on at
    Re: Get a Row action Not Found

    @rampprakash I have the same issue, can you help to explain more? as we don't know how to operate to resolve it, can you help to share screen capture if possible. thanks.

  • Gwill1983 Profile Picture
    Gwill1983 271 on at
    Re: Get a Row action Not Found

    Hi, thanks for the message. What do you mean when you say "check the count"?

  • Ram Prakash Profile Picture
    Ram Prakash 5,154 on at
    Re: Get a Row action Not Found

    Hello @Gwill1983 

     

    From Flow Check the Count and Run a Boolean value as true(if available), false(if not available).

     

    Then in the BOT check the Condition if it is True then send proper message else send some Custom Message.

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics