Sharepoint document list

[stella]

Hi,
I want to combine some excel files from the sharepoint document list.The users of the sharepoint upload an excel file, complete a request with the inputs of country, category etc and submit. An ID is created for each file the time of the submission and an approval flow starts. I want to download and merge these files including the information the users mentioned (country,...)
Using the Get data-Sharepoint folder in Power BI I get the excels, Date created and Date Modified of the file. When I am using Get data-Sharepoint List I get the ID, approval status, country and some other inputs the users included when they uploaded the file. I need to combine the two queries but my problem is that I dont have a key. Is it possible to include the ID in the first query?

[v-ljerr-msft]

Hi @stella,

I need to combine the two queries but my problem is that I dont have a key. Is it possible to include the ID in the first query?

---

How do you want to combine the two queries, Merge or Append?

Could you post the structures of the two queries with some sample/mock data, and the expected result? So that we can better assist on this issue. 

Regards