In a flow, I am querying a REST API data source that returns an array. I am using nested Loops to determine whether I consider the particular record relevant to the search (i.e. The search is looking for a Name within a State and trying to match to a known email or phone number). I am also interested in understanding the Reported Date of the record to determine if it is more recent than what has already been recorded. My issue is that the OR Condition erases after each Save of the flow and doesn't persist. The loop continues as if Step 2 doesn't exist (see below).
Here is the workflow:
- Query Return
- Condition (Dataverse Reported Date is Null OR Reported Date is greater than Dataverse Reported Date)
- Condition (Reported Email equal to Dataverse known email)
- Condition (Reported Phone equal to Dataverse known phone)
If either 3 or 4 are true, the record is updated in the Dataverse record. This should only happen if the date is more recent (but it just runs through all of them).
Please help me identify where I am going wrong or if this is an issue with Power Automate.
Thanks,
