Hello. I am trying to get data from a .xls excel file with no table. I notice that power automate doesn't have something built in for this.
Is there a way to do this in power automate?
Thank you.
You will likely need to use custom MS Graph API calls to do this. Either create a table with the data range or get the data range.
https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
There is a Groups HTTP request action you may be able to make the call with or if that doesn’t work, there is the premium HTTP connector.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
9 | |
7 | |
7 | |
7 |
User | Count |
---|---|
19 | |
18 | |
17 | |
10 | |
7 |