This could easily be items from a data source like a csv file or somewhere else but to keep it simple, we’re using a list. We’re creating a list in step 1 and we’re adding to that list in steps 2 – 4. In this example, we have a set list of stocks that we want to collect price history for: SPY, MSFT, and NUAN. We used RPA to solve this issue and while I can’t show that solution here, I’m going to walk you through a similar solution where we will extract stock information for several stock ticker symbols. We needed to gather the permissions for each eRoom but we had no way of exporting all of the info that we needed so we would’ve had to manually enter that information into spreadsheets for over 400 eRooms. I’m currently working on a large eRooms migration and my team and I found several use cases where RPA saved us a ton of time. In fact, one of my examples is of that very thing where we accept data from a web form and watch the solution automatically fill out fields in a legacy. Was also trying to use this tutorial (hence originally having in the above).I’ve had several speaking engagements over the last few months where I walk the audience through how to get started with Robotic Process Automation (RPA) using Power Automate Desktop to automate manual tasks and often the first thought that people have is to use RPA for data entry. team2.Īs I say, just need to find a means of pulling back the ID string held within the "data-event-id" attribute, but I can't quite get there. I can't say I know too much about coding, but I feel like I am close! Essentially, I would like "Column1" to return the numeric value of the "data-event-id" attribute - so the first row should be 2710602.Īt the moment my code says it returns an error that it cannot even define.Īm deliberately using the new Power BI desktop feature which can handle non-HTML tables and convert them. I know the rest of the script works: in other columns, I can already pull back text strings like 12.00PM, Jahn Regensburg and Darmstadt 98 in the above code with the respective CSS selectors. I am hoping one of you kind forum folk can help me.
0 kommentar(er)
