Unanswered

How Power Automate Desktop can identify which row user clicked in Excel (in browser)?

(0) Share

Report

Posted on by SarahXY4

I wish to know if the following scenario is possible or not. I have an Excel table on SharePoint and a flow that enters data into the table. For now, I implemented it so the data from the Excel table is written into the second application in the order in which it came.

However, I am interested in whether the user can choose which row will be written into the application.

For example, there are ten rows in the table, the user wants to process the data from row 7 first, and a user clicks on the desired row after that the power automate desktop flow should receive information about which row it is.

I only have the launch new Chrome action, which opens the corresponding table in the browser. However, I can't figure out how to record which row the user clicked and then pass it to the flow in PAD. Note the data is dynamic and changes every day.
Is the Excel spreadsheet approach wrong or maybe there is a better way to do what I'm looking for?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@SarahXY4

After open the excel sheet, use "Read from Excel worksheet" action and get start/end rows and columns in variables from user using input dialogue box then you can process it.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
SarahXY4 9 on at

Like (0)

Report
Copy link

Link copied!

Sorry,this is not helpful. I don't want to open local excel file. This action doesn't support cloud excel files, saved in browser instance in PAD.
On this link is my excel table and there user will click on desired row. So, I need to register which row is clicked in browser tab.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@SarahXY4
Based on my comprehension, it's challenging to determine which rows have been selected when a user manually clicks on Excel spreadsheets opened in a browser.

However, if you opt to open Excel spreadsheets in SharePoint in the browser, you could utilize the Excel online package and perform some adjustments or modifications more effectively(But it would require premium license).

Or you can sync your sharepoint folder with your local system and do the above suggested approach to get row and column details from user.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
SarahXY4 9 on at

Like (0)

Report
Copy link

Link copied!

Okay,thank you.
Based on your knowledge,can you suggest me maybe a better solution for my problem? To save data somewhere else, not in excel table, where is simpler to determine which row user clicked?

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

Like (0)

Report
Copy link

Link copied!

Can you perhaps have a Display input dialog action and let the user provide the row number in there, as a means to tell the flow which row(s) to process? That could work, if the "user" is the same user running the flow and using the same machine as the one where the flow is deployed.

Was this reply helpful? Yes No