Pass Excel table data from Power Automate web to PAD

[26mixes]

I have an Excel table on SharePoint that gets populated by various people at various times.

At the end of the week, I want to run a flow that takes this table of data and passes it to Power Automate Desktop.

What is the best way to achieve this?

Many thanks in advance.

[Kaif_Siddique]

Hi @26mixes , 

One possible solution is that run the weekly flow and get Excel data from SharePoint and save it to Excel online(One Drive). Now, run Power Automate Desktop from cloud and use the One Drive data as per requirements.

 Also, you can try to explore SharePoint connector in Power Automate Desktop. But its available in public preview. Refer below link for more details:

https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/power-automate/use-sharepoin...

Hope this will help you. 

Regards

Kaif

[26mixes]

Wasn't aware of this connector, will give it a try - thank you Kaif.