Answered

【Help me!】I want to put the question extracted by BingAI into Excel from the CSS selector, but it does not work 【PowerAutomateDesktop】

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

nice to meet you.
I have a question for those who are familiar with HTML and CSS.
please help me
@Anonymous Automate Desktop

------------------------------------------

【What you want to achieve with PowerAutomate】

① From the URL, set to answer to BingAI's "more creative"

↓

(2) Enter the question from me written in Excel into BingAI and ask
・Example: Please extract “(1) company website URL”, “(2) business description”, “(3) address” and “(4) representative” of XXXX Inc.
・In Excel, the company name is in column A, and the question content is in column B. It is written

↓

(3) When an answer comes from BingAI, extract it

↓

④ When the answer comes, let Excel fill in the answer content
・Column 😧 (1) Company website URL
・Column E: ② Business details
・Column F: ③ Address
・Column G: ④Representative

↓

⑤ Since there are about 300 company names, repeat ① to ④

------------------------------------------

【problem】
There are three problems. Please let me know how to resolve these.

【 Problem (1): An error occurs in (2)】
・The content of the error is "Cannot write to text box (cannot get window)".
・In (2), the input item of BingAI was selected and added to the element in the event "input in the text field in the window".
・No matter what element you change, it will not change. I tried "Edit 'Ask Bing'" and "Group 'main-container body'".
・If you delete the ① flow ("Move the mouse to the image") and set the ① flow again, questions may be posted in the input items, but this is not regular.

【Problem (2): Data cannot be extracted in ③】
・Trying to extract with CSS selector
・If you copy the part you want to extract from BingAI's answer, it will be as follows.
cib-shared > div > div > div.ac-textBlock > ul > li:nth-child(1) > ul
cib-shared > div > div > div.ac-textBlock > ul > li:nth-child(2) > ul
cib-shared > div > div > div.ac-textBlock > ul > li:nth-child(3) > ul
cib-shared > div > div > div.ac-textBlock > ul > li:nth-child(4) > ul

・Put the above string in the CSS selector and set the attribute to "Own Text".
・However, information is not extracted.

Problem (3): I can't fill in ④
・Since problem (2) has not been resolved, ④ cannot be implemented.
・I would like to know how to do this.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Problem 1
Use Browser automation actions instead of UI automation. This is a web page that you are trying to automate. UI automation is used to automate local applications and not web pages. Instead of Populate text field in window, use Populate text field in web page (I suggest changing your PAD language to English to find the actions easier. See this video on how to do that: https://www.youtube.com/watch?v=l2zpRkUBk0o&ab_channel=AndersJensen )

Problem 2
Have you tried to simply use the PAD functionality to capture the data you want, instead of typing in the selectors manually? When you have the web helper with the data preview, you can right-click an element that you want to extract and select Own text to extract it.

Problem 3
This seems to be fine on your flow. It simply won't fill anything in, because the data returned is empty (or maybe even fails) due to a bad selector. Fix the other two problems and this problem will disappear on its own.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Agnius
Thank you for your reply. I hope your answer helps.
Let me ask you a question, do you mean "browser actions"?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, "Browser automation" actions are to be used when automating any web pages. "UI automation" is used when automating local applications that are installed on your machine.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

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

Like
a
(0)

Report
Copy link

Link copied!

@Agnius

I got it. I will answer your request once it is resolved.
For "Problem 1" I'll try that.
For "problem 2", have you ever used BingAI with PowerAutomateDesctop?
Web helper does not work on BingAI.
See captcha.
Only all screens are recognized in the form of "Cib-serp".
That's why I suspect that I need to use CSS selectors.
What is the best way to extract answers from BingAI?
Maybe they don't need any CSS or HTML configuration.
thank you.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I haven't tried it myself. I guess I would use the OpenAI API if I needed to automate a process like this.

Try inspecting the elements in the web page and see if you can manually build a CSS selector.

Alternatively, you can try to send some keystrokes or mouse clicks to use the Bing UI and copy the response to the clipboard. You can then use the Get clipboard text action to retrieve that into a variable.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

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

Like
a
(0)

Report
Copy link

Link copied!

@Agnius

Problem 1 has been resolved.
However, issue 2 is not resolved.
please help me.
Please tell me how to do CSS selectors.
Is this image correct?
Below is the part I want to extract.
I don't know how to set "CSS selector" and "element".
cib-shared > div > div > div.ac-textBlock > ul > li:nth-child(1)
Thank you very much.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I would suggest trying to extract the entire contents of the parent <div> element via the Get details of element on web page action or the Extract data from web page action. Unless you actually need the separate values in a list, this will work fine.
If that doesn't work, you should just do cib-shared > div > div > div > ul > li:eq(1)
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No