Hello,
So I've been running this flow for a while, but lately this particular step to click on a web page link is taking 30 seconds. This is in a loop, so it might need to click on the link 60-100 times, so this can add upwards of 50 minutes for this single step. I googled and saw someone recommended to add the "Focus Window" beforehand, I did that and no changes. I've tried it with both Send physical click on and off, and in both cases it is the same. Any thoughts on how I can fix this? Again this is a loop so the page is staying open, it's not like the page is reloading over and over again.
Solved! Go to Solution.
use for each to loop through row in DataTable which is extracted let's say each row is defined by row variable. then
set a variable let's day id1 with value %row[0]%
Now use the id1 in the selector like below
a:contains("%id1%")
Hope this helps 🙂
Hi there @Nived_Nambiar ,
I'm not completely sure what you're looking for so I shall send you many things.
Try this way, in advanced settings of click webpage link action, toggle off send physical click option and try again.
Also let's try to make selector short, by checking html of webpage for that right click on uielement in webpage, and select inspect element option, share the screenshot of that.
Hello again @Nived_Nambiar ,
I've tried it with the click on and off, but I'll try it with off this time, sure. Is this what you want?
Hello @Nived_Nambiar
Yes sir. Here is a picture of it. It selects the first link to open a new page, gets some info, closes the page, and then moves down the list to the 2nd, 3rd, etc.
Then i would recommend to try this selector instead of one you are trying long one u are using
a:contains("%text%")
where %text% is variable in PAD which stores the link text which is to be clicked. for example: RA-170973 , RA-174493 etc.
Let me know whether it worked for you
Hi @Nived_Nambiar ,
I'm not sure I understand. So delete the entire selector I have now and only put "a:contains("%text%")" ?
Also how will it know to click on the 1st link on the 1st loop, and then the 2nd link on the 2nd loop, etc. You see in my current selector I have the "tr:eq(%LoopIndex%)" so it hits the right link, I need to incorporate that yes? Otherwise I'm not sure how that works, talk to me like I'm dumb cause I kinda am 🙂
Or how am I getting it to store the text? And also do the loop? I'm a bit confused here.
Try any of appraoches which i am suggesting below 🙂
1st way: using data scrapping option to scrape the text and its associated link (of the ID column )
Use data scrapping to to take the details of ID column, its text and corresponding URL and then loop through the datatable obtained from it and use go to webpage to go to the specific url of that specific ID and then perform operations regarding the ID and then use go to webpage again to go back.
2nd Way
For the selector case which we have discussed , selector should be placed like this
here text variable should be the variable from PAD which holds the value of ID name like RA-170973 like that.
If you have list of all ID names, you can loop through it and then assign it to text variable and make the bot to click on it 🙂
here List1 is initialized for temp purposes, but in your scenarionyou can use extract data from webpage action to extract the ID names.
Hope this helps
Mark it as solution if it resolves your query
Hi @Nived_Nambiar ,
I guess I should have mentioned I already have it extracting the data and in a loop. It is not just extracting that column but 4 columns total, so I'm not sure how to take what I currently have and do what you want, without it messing up. here is kind of what it looks like :
Looks like a big difference is I use Loop and not For Each. Basically it extracts the data, and then for each "RA" It has to open a page, and then click on a link to open another page, then save that page, then close those 2 pages, then go to the next RA. Here is what the data extraction looks like :
Do you recommend I use the For Each rather than Loop? I guess then I don't need the %LoopIndex% in the Selector, which is maybe where I was getting mostly confused. Still confused though. 😄
use for each to loop through row in DataTable which is extracted let's say each row is defined by row variable. then
set a variable let's day id1 with value %row[0]%
Now use the id1 in the selector like below
a:contains("%id1%")
Hope this helps 🙂
Hi @Nived_Nambiar ,
First thanks for all the help and I am sorry I do not seem to get it. Where do I put the row[0] step, or how do I increment it? Right now it's just going to do the 1st RA over and over and my brain does not seem to be working. Here is what I did (incorrectly), youll see I added a step to retrieve that column of RAs from the data and put it into a list, but not sure how to get the rows to increment
see the sample flow design [ignore url and all ]
So here what i am trying to acheieve is , selecting the link by text present in it. In the first row, text is RA-174081
So my bot should click the link which contains text RA-174081. simmilarly for next iteration it should consider the next row and so on 🙂
For checking whether the selector works or not, you can use the test selector which helps to test selector based on different values of %id1% variable
just check with different ID values in the variable to test selector to verify whether it is highlighing correct element or not.
Hope it helps
I think I can't get that to work because I am unsure how you are typing the row[0] in, mine does not look the same.
Nevermind I fixed that, I am dumb 🙂 It it going through the rows now. Is it going faster? It's hard to tell until I do an official run from the scheduled cloud flow, but I want to fix one more thing before I do that 😕
Yes I just did a test run. That 30 second step is now taking 1 second as it should. Though overall the flow is still running long, it should have been a better reduction on time, but I possibly need to fix other steps. Thanks for this one though your time is much appreciated.
Dear Community Members, We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd. During this period, members will not be able to Kudo, Comment, or Reply to any posts. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!
We are excited to announce the Summer of Solutions Challenge! This challenge is kicking off on Monday, June 17th and will run for (4) weeks. The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities. Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”) - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024 Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods. You must enter into each weekly Entry Period separately. How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different. Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers. At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing. Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner. A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random. Individuals will be contacted before the announcement with the opportunity to claim or deny the prize. Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners. Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event. ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE** Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24 17 @Anil_g 7 @ManishSolanki 13 @eetuRobo 5 @David_MA 10 @VishnuReddy1997 5 @SpongYe 9JhonatanOB19932 (tie) @Nived_Nambiar 8 @maltie 2 (tie) @PA-Noob 2 (tie) @LukeMcG 2 (tie) @tgut03 2 (tie) Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate @Deenuji 12@ManishSolanki 19 @Anil_g 10 @NathanAlvares24 17 @VishnuReddy1997 6 @Expiscornovus 10 @Tjan 5 @Nived_Nambiar 10 @eetuRobo 3 @SudeepGhatakNZ 8 Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22 Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2 Anil_g2 SharonS2
On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners. The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights. Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.
We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for. We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer. Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together. Here's to new beginnings and endless possibilities! If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport. To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages