Web Scraping - Capture URL | Power Automate Gallery

Web Scraping - Capture URL

WebAutomation.LaunchChrome Url: 'https://blackknight.wd1.myworkdayjobs.com/BKC' BrowserInstance=> Browser
WAIT 5
MouseAndKeyboard.SendKeys TextToSend: $'''{End:5}''' DelayBetweenKeystrokes: 2000 SendTextAsHardwareKeys: False
WebAutomation.ExecuteJavascript BrowserInstance: Browser Javascript: $'''function ExecuteScript() {
 let nameList = [];
 let response = \'\';

document.querySelectorAll(\'.gwt-Label.WJCP.WCBP\').forEach((element, i) => {
  nameList.push(element.innerHTML);

let event = new MouseEvent(\'contextmenu\', {
   bubbles: true,
   cancelable: false,
   view: window,
   button: 2,
   buttons: 0,
   clientX: element.getBoundingClientRect().x,
   clientY: element.getBoundingClientRect().y
  });
  element.dispatchEvent(event);
 });

document.querySelectorAll(\'div[data-automation-id=\"copyUrl\"]\').forEach((element, i) => {
  response += nameList[i] + \'\\\\t\' + element.getAttribute(\'data-clipboard-text\') + \'\\\\n\';
 });

return response;
}''' Result=> Result
Text.SplitWithDelimiter Text: Result CustomDelimiter: $'''\\n''' IsRegEx: False Result=> TextList
Excel.Launch Visible: True LoadAddInsAndMacros: False Instance=> ExcelInstance
LOOP LoopIndex FROM 0 TO TextList.Count - 2 STEP 1
    Text.SplitWithDelimiter Text: TextList[LoopIndex] CustomDelimiter: $'''\\t''' IsRegEx: False Result=> TextList2
    Excel.WriteCell Instance: ExcelInstance Value: TextList2[0] Column: 1 Row: LoopIndex + 1
    Excel.WriteCell Instance: ExcelInstance Value: TextList2[1] Column: 2 Row: LoopIndex + 1
END

References

[1]https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Web-Scraping-Capture-URL/m-p/1295419#M7306

Author

PAG Admin

Also See These Flows

Flow Action

Read Google Sheets API With Power Automate for Desktop

This example uses Invoke Web Service flow action to send a request to Google Sheets API, the response contains spreadsheet values.

PAG Admin

1,504

Flow Action

Using Bootstrap 5 Components With JavaScript

Code snippets to help building web page automation with JavaScript.

PAG Admin

354

Flow Action

Create Animated Doughnut in Notepad

This example shows how to read JSON data, loop items and print output to screen (Notepad in this case).

PAG Admin

338

Flow Action

Write to Google Sheets API Using OAuth 2.0 Power Automate for Desktop

Write cell values to spreadsheets. Includes basic logic for handling refresh tokens for repetitive tasks.

PAG Admin

2,739

Flow Action

Send file attachments to JIRA issues using cURL

This example shows how to send file attachments to issues in JIRA cloud.

PAG Admin

530