Hi All,
I'm trying to work out how to correctly reference a look relationship in power automate.
I would like to change the status of child records to match the status of the parent record.
here is what I am using at the moment
Can anyone provide guidance on this.
Hi partner,
You can refer my following example flow:
For example, I have a custom entity named test and it has N:1 relationship with account entity.
1.add a Trigger ‘when a record is updated’: parent record(Account) status change.
2.add ‘List records’ action to list child records(test) that associated the account.
For the filter query :
new_accountid is logic name of the lookup field in test form, and correct format is ‘_new_accountid_value’.
3.add ‘Update a record’ to update status field of these child records with parents records’ value.
'Apply to each' action can be added automatically after adding 'update a record' action.
4.Test.
when i change parent record status to 'inactive', all child records of it will be inactive automatically.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Thank you. the only thing I had to do was add space after the account (see my arrow)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
MVP-Daniyal Khaleel 60
Tom_Gioielli 24 Super User 2025 Season 2
CU29080825-0 16