Power Platform Community Forum Thread Details

I'm working on a flow to populate a deltek vision timesheet based on data in a spreadsheet (project number, hours per day, comments, etc.). The number of rows in the spreadsheet will change depending on the week and can't be predicted. The timesheet starts with one blank row, and each time a project number is input, a new row will show up. I have successfully been able to transfer the first project number from the spreadsheet into the first spot on the timesheet, but I would like the new row's project number spot to be detected and used as the next UI element in the flow. Currently, I'm attempting to use "Crop Text", "Click UI element in window" and "Populate text field in window" in a for each loop and would like the next action to be selecting the UI element directly below the previous one.

Categories:

Power Automate Desktop

You will need to modify the selectors used for the UI elements you're clicking and populating. I cannot really be more specific here with the information provided, but you will likely need to use a loop index or something like that in a variable and pass that variable to the UI element selector.

See here for reference on how to do that: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors

Also this video tutorial: https://www.youtube.com/watch?v=2PcyBa22Jj8&ab_channel=Thomas%22Shaky%22Petersen

If, after reviewing these and trying to do it yourself, you still struggle with the task, please provide some screenshots of the target system with the elements selected and inspected via the browser's developer tools (right click on it and click "Inspect").