Unanswered

Trouble pasting into SharePoint list

(0) Share

Report

Posted on by ahhollan

576

I am building a flow that erases data from a SharePoint list, then copies a table in Power BI, then pastes the table as new rows into the cleared SharePoint list. I have it all figured out except pasting the table as new rows. I hit 'Edit in grid view' and then can manually use Control+V to bulk paste the rows. However, when I use send keys to send {Control}({V}) in my flow it does nothing. Any ideas on how to fix this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Could you check if it has copied the data , i think ctrl+v returns blank means data is not copied from source

Thanks & Regards,
Nived N

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

It is definitely copying the data. I can manually do the ctrl v keystrokes and it pastes the rows in.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

I am not saying with respect to manual way of doing, whether robot is able to do that, have you checked that ?

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

Yes. I can run the copy step for the robot and then manually paste the results. Is there another way that you suggest I check that it is copying? I'm just learning PAD so this is new to me.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ahhollan

Simply using ctrl+c command does not copy the specific data which u need, you need to select the data first. For example, you are trying to copy data from notepad, so to copy from notepad, you need to use ctrl+a to select all data in notepad and then use ctrl+c

To validate whether you have the data copied correctly, you can use Get Clipboard text action

Thanks & Regards,
Nived N

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

I am using the copy table command in Power BI to copy a table, then trying to paste to SP. I'm using your suggested step of 'Get Clipboard Text' to see if it is copying.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Let me know if you got any lead after trying 🙂

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like (1)

Report

Also make sure you make the bot send a click to where you want to post the data before having the bot press CTRL+V as the bot usually has no focus on where its doing it, you can also tell it to send it to a UI Element if necessary.

Was this reply helpful? Yes No