Answered

How to Copy and Paste from Excel Spreadsheet

(0) Share

Report

Posted on by QuestC

Hello,

I have a list of product numbers that are all in a column, and I need to know if it is possible to go through each product number, copy it, paste it into Amazon.com search bar, then "Enter" to search each for it. Completed one-by-one.

Thanks for the help!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Sort by

tkuehara 667 on at

Like (0)

Report
Copy link

Link copied!

Hi @QuestC

Yes, it is possible.

Was this reply helpful? Yes No
QuestC 26 on at

Like (0)

Report
Copy link

Link copied!

Would you know how its done? I cant figure out how to copy things over from a cell and paste. I have gotten the "CurrentItem" for each cell but do not know how to search on Amazon

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @QuestC
Tested this flow and ran as desired:
1. 'Launch Excel' and open the workbook containing your product numbers
2. 'Get first free column/row from Excel worksheet' to obtain number of records (%FirstFreeRow%)
3. 'Read from Excel worksheet': Retrieve = Values from a Range of Cells and inform parameters of Start Column/Row, Last Column. Last Row must be %FirstFreeRow - 1% (action gives 'ExcelData' as variable)
4. 'Launch new Edge' (or your preferred browser), with Initial URL = www.amazon.com
5. 'For each CurrentItem in ExcelData':
6. 'Convert text to number': convert %CurrentItem% to %CurrentItemasNumber% (renamed variable)
7. 'Populate text field on web page'. Capture search field as UI element (here it's named '<input:text> 'twotabsearchtextbox') with %CurrentItemasNumber%
8. 'Press button on web page' Capture the search button as UI element (here it's named ´'<input:submit. 'nav-search-submit-button')
[Here you have to complete with your desired actions on results' page...]
9. End

Was this reply helpful? Yes No
Riyaz_riz11 4,171 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @QuestC

It is possible
just in read excel u can special the column A or C watevr the product no column
ten for each datatable
inside populate pass %currentitem%
for each end

this wil work

Regards
Ahammad Riyaz

Was this reply helpful? Yes No
QuestC 26 on at

Like (0)

Report
Copy link

Link copied!

Some of the model numbers have letters in them so it errored out. When I removed this step it gave me another error saying it must be encrypted. How can I get around this?
BTW Thanks for all the help so far!

Was this reply helpful? Yes No
QuestC 26 on at

Like (0)

Report
Copy link

Link copied!

I am getting the 'Text' must be 'Encrypted Value' error. How can I get around this?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @QuestC
As suggested by @fraenK in this thread (Solved: Parameter 'Text': Argument 'Text' must be 'Encrypt... - Power Platform Community (microsoft.com), use this action as step 6:
6) 'Trim text', with Text to trim = %CurrentItem% and What to trim = any option. This will give you %TrimmedText%.
Then use this variable in step 7 to populate web page.

Was this reply helpful? Yes No
sobhy0101 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, My column data has numbers and letters. How can I use your method in my case?

Was this reply helpful? Yes No