cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gwill1983
Helper IV
Helper IV

Get a Row action Not Found

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@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

 

 

 

View solution in original post

6 REPLIES 6
rampprakash
Super User
Super User

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

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

amydeng
New Member

@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.

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

Gwill1983
Helper IV
Helper IV

Can anybody help with this?

 

 

@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

 

 

 

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,654)