Power Platform Community Forum Thread Details

I'm building a flow to get data from a BI report > parse to JSON and only upload records that are unique.

The Unique value in the SP list and the BI report is the CIR Number.

I'm trying to apply a condition after the Parse JSON step to see if the Parse JSON value [CIR ID] is equal to the CIR value in the SP list (from the get items step)

in the condition im using:

items('Apply-to-each-2')?['Submitted CIR[CIR ID]']

is equal to items('Apply_to_each_3')?['CIR']

the flow works fine with out the condition. but the result is that i get duplicate items in my sharepoint list.

when the condition is added. there is no error, but nothing gets loaded to the sharepoint site and the results show that the condition is a blue circle (like its processing)

thanks for your assistance :)

trevor