You’re offline. This is a read only version of the page.
Hi,
My Power Automate flow returns a filtered list of all the records in Table A and for each record, create a new record in the Contacts table. I am currently passing in a Power Automate variable from a previous step and that filtering works perfectly. I am having trouble with writing the OData or FetchXML query to check whether the email address of the current record being iterated on in Table A exists in a Contacts record.
I'm trying to decide whether I should be using OData or FetchXML Query (or can I combine both?). I have some worry with using FetchXML filter query because I need to pass in variables that were initialized in Power Automate.
In the List Records you could use ne (instead of eq). I appreciate that it would impact.
The other option is you could try doing this in a Dataflow instead of using Power Automate.
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist
This would add a new Contact record where an email address matches the email in Table A. My requirement is to only create a Contact record if no such record where the email address matches.
This pattern also introduces a while loop within a while loop and may be a performance hit. I was hoping to accomplish this in a single OData filter query or a FetchXML filter query but the latter seems not possible because I require the query to be filtered using a Power Automated-created variable.
I would add a few actions in Apply to each before you add the record.
- List records in Contacts with a filter whether email address eq email address from Table A.
- Then add another Apply to each on the List Contact table.
- In that Apply to each add the Create new record.
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (
