Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Update SharePoint List...
Power Automate - Building Flows
Answered

Update SharePoint List based on Keyword from Excel

(0) ShareShare
ReportReport
Posted on by firda59 372

Hello, everyone!

 

I have sharepoint list and excel. I want something like this:

 

When I created item in column 'Number ID' in my sharepoint, I want the other column (name of column same like in excel file) can fill automatically from excel data based on 'Number ID' that I wrote before. How the best flow to make it happen? I'm trying to use filter array/initialize variable in Power Automate, but still doesnt get where I should write the trigger, I mean 'Number ID' as a keyword to connecting sharepoint to excel.

 

 

Thank you

Categories:
Flow Mobile App
Business Process Flows
  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Update SharePoint List based on Keyword from Excel

    Hi @firda59 ,

     

    Please check below blog:

    Excel Filtering on Columns With a Space – Flow Alt Delete – Josh Cook [Microsoft MVP]

     

    A simple solution is to remove the space from column names of the Excel table.

     

    Best regards,

  • firda59 Profile Picture
    firda59 372 on at
    Re: Update SharePoint List based on Keyword from Excel

    Hi @v-jefferni 

     

    I try that flow:

    firda59_0-1689584137770.png

     

    and I got this message:
    Invalid filter clause: cannot find the 'SSB_x0020_ID' column.
    clientRequestId: ac05d7ab-9081-404d-b2fe-f458a406510b
    serviceRequestId: eed6497f-ac8f-4d96-87e9-0dc0d8875439;a72d922d-cf6f-4cbe-b92a-718340a70f65;cb072ef3-c3e5-4c23-b90b-ba16af4deab6;cf196d2c-a4ac-4041-ad35-7a82af03dbac

     

    My column name in excel is 'SSB ID '.

     

    Do you know what is wrong with my flow? Thankyou

  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: Update SharePoint List based on Keyword from Excel

    Hi @firda59 ,

     

    You can use a When an item is created SharePoint trigger to achieve your need.

     

    So, the logic is:

    1. Trigger the flow on new item created in the list.

    2. List rows present in a table of Excel, filter query set to Number ID eq Number ID Dynamic contents from the trigger, top count = 1.

    3. Apply to each value of List rows action

    4. Update item using dynamic contents from list rows action.

     

     

    Best regards,

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

News and Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans