Copy-Paste-Block error on Power Automate

Question

Hi,

I created a flow on Automate, wherein when a new message is posted on teams channel, respective row must be updated in excel. This flow works well when a message is typed and posted, however when the user is copy and pasting the same message or string the flow throws up below error.

How can I overcome this error so that irrespective of the way the message is posted the row must be updated without any errors.

Error

<div>
<div itemprop="copy-paste-block"><span><span>4539922</span></span></div>
</div>

Flow Screenshot

Answer 1

Hi @
Shrikant bomma

In order to avoid this error, I suggest you add an Html to text action in the flow. The problem might be due to the messages in Teams coming back to Flow as Html instead of plain text.

I made a test for your reference:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---