Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Reading data from table then updating to SharePoint list

Posted on by

Hi

I have created an office 365 SharePoint list containing eight columns. Two of the columns are auto populated from an MS Form. This works fine.

I now want to populate some of the other columns pulling the data from an excel file that is stored within the SharePoint site. The Excel file has more columns than those required for this list.

The common field is an e-mail address, the excel file has circa two thousand rows and i only want to pull back the data for the number of records that are in the SharePoint list around twenty where data has not been updated previously i.e. if column "Employee Name" is blank bring back the data.

Any help would be greatly appreciated

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Reading data from table then updating to SharePoint list

    Hi @Anonymous,

     

    I assume that you have two flows. Flow1 is used to submit responses from Forms to SharePoint list. Flow2 is used to get columns from the Excel tables then update the list.

    From your description, there is a common field between the list and the Excel table, and there are two thousand rows in the Excel table.

    I have made the following test for your reference. In my scenario, the common field is the name of the user.

    It is triggered by When an item is created.

    As you mentioned that the Excel file is stored within the SharePoint site, we are going to use the connector Excel Online. Add the action List rows present in a table. And enter the following code into the Filter Query field to get the specific row:

    Name eq ‘Dynamic content Title’

    Add the action Update item, then fill in each column with corresponding fields from the Excel table. At here, once you select dynamic contents from the previous, an Apply to each will be added automatically.

    1.PNG

    Hope it could be your reference.

     

    Best regards,

    Mabel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard

Featured topics