Can I have flow enter related entity data?

[Medoomi]

I have a Common Data Service entity "Member Agency Contact List" which is an intermediate entity forming a N:N relationship between "Member Agencies" and "Member Contacts."

I would like to have a flow enter the relevant "State" (a lookup field in "Member Contacts") into "Member Agency Contact List" any time "Member Agency Contact List" is updated.

Is this something flow can do (i.e. retrieve and enter data from related CDS entities)?

[ManishJain]

Hi @Medoomi ,

Based of Member Agency Contact List you want to update Member contacts  or Member agency field ? Please explain

Thanks

[DeepakS · Accepted solution]

Hi @Medoomi 

Logical answer to your question is Yes you can update , but as you are trying to set your trigger condition on "Member Agency Contact List" update and then you are trying to update "Member Agency Contact List" so this will go in to infinite loop.

What i would suggest you to update "Member Agency Contact List" when "Member Contact" list updated , you can use List record or get Record from "Member Agency Contact List" based on the "Member Contact" list.

Regards,

[Medoomi]

Thank you so much @DeepakS  & @ManishJain  for replies.

OK, yes, to avoid an infinite loop, I will set the trigger to an update of "Member Contacts"

What kind of "steps" could I use to take the lookup field "State" within "Member Contacts," and insert this in the field "Contact State" within the related record in "Member Agency Contact List"?