Using power automate to pull in excel file and get a sharepoint list item and update

Like (0) Share

Report

Posted on 29 Jun 2022 19:33:50 by dmclaughlin

347

I am doing a trigger power automate. I then do a step get present rows of table. That seems fine because the next step I do get items to go to the sharepoint list. I can see the fields in excel and in the filter query I can see the excel field and I select then type eq and then I type the name of the field in the list. When I run it it errors and says the field I typed in the list doesn't exist. but it does. what am i doing wrong?

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on 04 Jul 2022 at 01:20:31

Like (0)

Report

Re: Using power automate to pull in excel file and get a sharepoint list item and update

Hi @dmclaughlin ,

Please add ' beside the keywords you want to search. For example:

SearchField eq 'KeyWord'

Best Regards,

Bof
MarconettiMarco 3,812 Super User 2024 Season 1 on 01 Jul 2022 at 06:52:00

Like (0)

Report

Re: Using power automate to pull in excel file and get a sharepoint list item and update

Hello @dmclaughlin ,
please share the flow steps in edit mode so that we could help you. Also please share your SP list and Excel file.

BR,
Marco