Announcements
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.
Hi @Anonymous ,
When the user is using the CTRL C and CTRL V, maybe it is pasting some different characters.
So I recommend you to test using the published bot and track the pasted value within the flow, you can see the history. Within your flow, you can understand what is the special characters.
In that case, you can manipulate within your flow, removing things. (e.g HTML to plain text)
That's another issue I am facing now. I am not able to see the past runs in flow. If I try to open a past run, it just shows a loading screen. I am using this inside the Teams app. But, I did check this inside the test bot and it's working flawlessly. Only in published I am facing this issue.
@Anonymous ,
You can see that blog post, find your flow, try the see the history again: Where Are My Flows When Building Power Virtual Age... - Power Platform Community (microsoft.com)
If it is only loading the page, try to go back and try again.
Thanks for that information. I did find my flow, but the situation is still the same. It won't show me the past run details. I cant get past the loading screen. 😕
YEs, I got it.
So, which input type are you expecting in your flow?
If it is a Number, Boolean, or something like that, change to string. Because maybe when you are pasting, is not passing the number but string with characters.
I am expecting a string (alphanumeric value). The values in the excel file are also in text format. I did try using the compose action to change the input to string. But that didn't solve the issue. Is there another way of doing it? I am quite new to this.
You need to have a question that is expecting a free response of the user (text) within your PVA and an input within your flow that is a string.
If you changed the type of your input within the flow, you need to remove your action connected to the flow and add it again.
The bug must be solved using the same logic here: BUG! Sending copy/pasted text to PVA chatbot in Te... - Power Platform Community (microsoft.com)
If it was not solved, I recommend you to raise a ticket within the PVA support page, Microsoft will help you: http://powervirtualagents.microsoft.com/en-us/support
Wow. Thank you so much. That worked. I used HTML to text conversion action and it converted the value properly to text.
https://powerusers.microsoft.com/t5/Building-PVA-chatbots-in/BUG-Sending-copy-pasted-text-to-PVA-chatbot-in-Teams-causes/m-p/814228#M234
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 110 Super User 2026 Season 2
11manish 106 Super User 2026 Season 2
sannavajjala87 76 Super User 2026 Season 2
