Update and Create items from Excel table to Sharepoint list

(0) Share

Report

Posted on by fgonzalez515

296

Hello Community,

I have an Excel table that I want to update and create new items in my Sharepoint list, when new data is registered in the Excel table.

My problem with the flow is not when I update but when I want to create new items to the Sharepoint list, I think I made a mistake with the flow, which I cannot identify, since multiple items are created and even repeated.

My Table Excel

My List Sharepoint

My flow Update ( I don´t have problem )

My flow Create items ( I have problem )

Please your help, thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-LilyW-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @fgonzalez515
I did a test on my side, and can create a new item to the Sharepoint list if the list hasn't the row.
You can take a try to change your create new items part to the steps shown in the figure below:
This is my test excel
This is my test list
After flow runs, the D\E\F will be created in the list.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-LilyW-msft,

A question, in "List rows present in a table" and "Get items" you applied a Filter Query?

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @fgonzalez515
Sorry,forgot to show you the content of the Filter query in Get items action.
List rows present in a table hasn't applied a Filter Query.
Get items applied a Filter Query as below
Best Regards.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-LilyW-msft

Was this reply helpful? Yes No