Hi Guys,
Good day!
I have created a PVA bot that uses a Power Automate action which accepts an input from the user and searches it in an excel file stored in SP and retrieves another value based on the search criteria and certain conditions. All is working fine except when the BOT is published, if the user copy-paste the input, it throws an error. If the user types in the value, it works fine, but if the user pastes the value, it won't run. I understand it's related to the format type of the input, but I am not able to find a fix for this. I did try adding a compose action and convert the value to string but, that didn't help either. Any suggestion or fix will be much appreciated.