lookup and copy data from excel to sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hi Expert

i am trying to create a flow that will copy the data from excel to sharepoint list.

1. i have "master actual data" in excel format which consist more than 50k rows which include enterprise wide projectID

2. I have my own project id and actual sharepoint list

3. now i want to copy the actual data from excel which is downloaded from different server every month in excel but only the data related to items available on my project id sharepoint list.

for eg:

in example below: if i want the record to copy from the excel than it should only copy the data if those project id is in to project id list.

thank you again

i did created a flow that copy the record but i couldnt create a filter

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous do you have multiple excel files or just one excel file? One thing you could do is first get the Project IDs from SharePoint list, then use List Rows present in table to use the project ID from SharePoint in the filter query so that you only get those records from excel which are matching with project ID from SharePoint list.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Anna\,
i have one excel file.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous in that case i suggest, first add the Get Items action to get items from the ProjectID list, then add Apply to each action to loop through all ProjectIDs, inside Apply to each action, get the excel file and list rows from excel file, in the list rows, add filter query to match the ProjectID, so that List rows only returns rows that are matching with that Project ID.

Was this reply helpful? Yes No