Power Platform Community Forum Thread Details

Hello Automate Experts!
I am new to power automate and hope to ask for your help on building the following flow.
I have an excel file which has 2 columns as follow.]

Column Link / Column Keyword
Link 1 / Keyword 1
Link 2 / Keyword 2
Link 3 / Keyword 3

I want to Step(1) open each link and (2) fill in the corresponding Keyword of the same row in the website.
So when open Link1, keyword1 will be filled out to the input field. And Link 2 will be keyword 2 and so on.

I have searched online and found a flow that can achieve Step(1) but I have no idea how I can work with step(2).

I think I have to set variables for Keywords but now sure how. Can anyone give me some advice? Thanks a lot in advance!

Categories:

Power Automate Desktop

You do not need the Retrieve data table column into list action. Instead to the For each loop on the entire table and your %CurrentItem% will then be a data row with two columns. You can then access the value of each column for the current row as %CurrentItem['ColumnName']%.

Here's what a sample could look like based on your example above:

Note that I used "Keyword" as the name for the second column. If it is actually called something else in the Excel file, you will need to edit that.

You can copy the following snippet and paste it directly into the PAD flow designer to have all those actions created for you:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\haozhong\\Documents\\YouTube\\Power Automate\\Product List\\Product Listing.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstance
SET MainURL TO $'''www.powerautomator.com'''
WebAutomation.LaunchEdge.LaunchEdge Url: MainURL WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False WaitForPageToLoadTimeout: 60 Timeout: 60 BrowserInstance=> Browser
LOOP FOREACH CurrentItem IN ExcelData
 SET ProductWebsite TO $'''%MainURL%/%CurrentItem['Product']%'''
 SET Keyword TO CurrentItem['Keyword']
 WebAutomation.CreateNewTab.CreateNewTab BrowserInstance: Browser Url: ProductWebsite WaitForPageToLoadTimeout: 60 NewBrowserInstance=> NewBrowser
END

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.