Forum Discussion
Sharepoint document list
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?
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?
1 Reply
v-ljerr-msftMicrosoft Employee
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. :smileyhappy:
Regards