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.
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.
Hi @v-LilyW-msft,
A question, in "List rows present in a table" and "Get items" you applied a Filter Query?
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.