Check if Item in SharePoint List already Exists without duplicating it.

[luizhr]

I built this flow to daily get data from a Power BI and send it to a SharePoint list.

The flow is working fine, but probably it's not reading correctly the condition because it's creating again the same item.

Does anyone know to solve this issue? I've been struggling some days with this issue.

P.S. The ID# in the list is defined as a "number" as well the Id in Parse JSON 

THE FLOW:

Condition box function: empty(body('Filter_array'))

P.S.2 I tried to use this formula below (using lenght), but it keeps giving the error:  Unable to process template language expressions for action 'Condition' at line '0' and column '0' .

length(outputs('Get_Items')?['body/value'])

P.S.3: I won't need to update the item in the future, only if in my Power Bi has a new item. (that's why "If no" is blank)

@takolota, @Pstork1 

[BCBuizer · Accepted solution]

HI @luizhr ,

Try moving the condition inside the Apply to each 3 loop.

[luizhr]

It magically worked 😁 thanks. I'll keep on track if something gets wrong in the future.

[luizhr]

Hi @BCBuizer . it's me again 🙂 . I have been seeing that every time that a new item is included in my list (by power Bi), the flow adds the new rows (in SharePoint list) but includes again the ones exiting in my list.

Any clue for me to solve this issue?

@takolota, @Pstork1  any idea/ suggestion to solve that? 

[BCBuizer]

Hi @luizhr ,

Try moving the filter in front of the apply to each loop and use this blog to set it up so that it will only return those Items from the PBI data set that don't have an ID in SharePoint (Except section) : https://www.damobird365.com/efficien-union-except-and-intersect-great-method/

The use the output of the filter to create new items. The condition inside the loop can be removed since no duplicates should be passed.

[luizhr · Accepted solution]

That was one of the most difficult flows I ever made. I will post here the screenshots for future help. I used the except condition using the link above. My List B is from Power Bi query and my List A is from SharePoint List. Lesson learned: You always need to compare items, like string with string. I was trying to compare "number" and it wasn't working (of course).

Thanks @BCBuizer for all inputs.