Announcements
Hi Everyone,
i'm able to get my bot working when i only have 2 to 3 row of data. however, when i start importing more data (800+ row of error message and solution) the bot slow to retrive the first few rows and totally not responsive for data on row 100+
i'm using error message varible in my Odata filter query, but still not working. anyone know how to fix this ???
Thanks
Are you using a Power Automate flow called from the BOT to retrieve the message? If you are can you share a screenshot of the flow actions and we'll see if we can help optimize the flow.
The first thing I see that would lead to a slow flow as the size of the list increases is that your filter query won't work. A filter query should be an OData query which is something like the following for a list column called "ErrorMessage". You are probably retrieving all the records from the list at this point.
ErrorMessage eq '<<Error Message passed from BOT>>'
thanks, i was suspecting it was the problem with the filter as well. as i'm still not really familiar with how OData work.
do i just staight away put in this code into the filter box or i need to modify the word ?
I assume you are filtering on error code and trying to retrieve the error message. If so, what is the name and type of the error code column in the list? And how are you passing the error code from the Bot to the flow?
yes, each row have a specific error code and the solution associated to the error code
Then the start of the flow should look like this with the appropriate Site and List/Library name filled in.
Assuming there will only be one match you can then get the return value using First().
I'm getting error code 2003
Can you show me a screenshot of the error and the flow definition?
sorry, i not too sure what is flow defination
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 639
Vish WR 293
Haque 216
