Answered

Error when using Get Items to query a list

(0) Share

Report

Posted on by DemoMan

Hello Guys, Hope You can help with this one.

I have a flow that needs to check if an item already exist on a Master list, if the item exist then update it, if it doesn't exist then create the item.

The issue I have is when I use a "Get Items" to query the "Master List" it goes through every single item in the "Master List" checking if the values match, if they don't match then it creates the item, BUT then it moves to the next item and it tries to create it again, and again for each item it checks. it seems that is not checking the entire list and choosing to create the item or update it after it checks the list. It does this 100 times and then it fails because some of the values are unique.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

PieterVeenstra 31 on at

Like (0)

Report
Copy link

Link copied!

I've created a post on this. earlier this week. https://veenstra.me.uk/2018/12/03/microsoft-flow-import-list-data-from-an-excel-spreadsheet-into-sharepoint-lists/ To do this include a query in your get items. Then check for the number of items found then have a condition that either creates or updates the lists items.

Was this reply helpful? Yes No
DemoMan 55 on at

Like (0)

Report
Copy link

Link copied!

Hi Pieter, Thanks so much for your reply. I see that you are using the: @equals(length(body(‘Get_items_2’)?[‘value’]), 0) I'm using a similar string on my flow: @equals(length(body('Get_items')?['value']), 1) But I'm not sure this works for me, my flow checks the first item on the list for the value I'm looking for and when it sees that is not the same value I'm looking for it creates my item, it then moves to the next item and it sees that the item doesn't have the value I'm looking so it tries to create the item again, only that this time it fails because the item was already created on the flow's first run. Does your flow check all items until it finds the one that matches your value and then stops?

Was this reply helpful? Yes No
Verified answer

PieterVeenstra 31 on at

Like (1)

Report
Copy link

Link copied!

The selection of the item in Get_Items ( using the filter field in the advanced settings) sorts out that I will only get 1 item or no items back. Checking for 0 might not work as a list of no items might mean that the length function will fail. What will length (null) return? In general I add a few compose actions to my logic so that I can debug the solutions. Can you add 2 compose actions just before your condition. set the first compose to the following expression: body(‘Get_items_2’)?[‘value’] and the second one to: length(body(‘Get_items_2’)?[‘value’]) Now you will know what the values are that are failing.

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @DemoMan,

I have made a test on my side, please refer to screenshot below to create the flow:

Best regards,

Alice

Was this reply helpful? Yes No