Update SharePoint List based on Keyword from Excel

(0) Share

Report

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:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

I try that flow:

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

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No