Flow for one to many relation with powerapps

[LoopinG2023]

Hey helpers,

*I am reaching out to request  assistance with creating a flow for a one-to-many relation using the relate() function in PowerApps.

I have been trying to create this flow on my own, but I have been facing some challenges and I believe that your expertise would be of great help to me. Specifically, I am struggling to set up the relate() function to establish the one-to-many relationship between two tables.

If possible, I would greatly appreciate it if one of you could provide me with some guidance on how to set up this function correctly.

i have used the 'Get row id - list row -Apply to each(Relate)' but keep getting this error in the list row:

Syntax error at position 13 in 'cr86e_name eg 'DILLARDS/LAKE HAVASU''.

 Thanks in advance.

[Sundeep_Malik]

Hey @LoopinG2023 

You are getting the error because instead of eq you have used eg. 

Syntax error at position 13 in 'cr86e_name eg 'DILLARDS/LAKE HAVASU''.

So, write expression like this:

cr86e_name eq 'DILLARDS/LAKE HAVASU'

I hope this helps 🙂

[LoopinG2023]

Am getting the same error also a mesage on powerapp saying it he respondse DATA should a  valide JSON object.

Here is the itme giving me trouble, so a need to filter the one i need, to then do a apply for each to a relate(), Listrow_Filter am sending the name of each items the most be added to the relation.

[Sundeep_Malik]

@LoopinG2023 

In the above screenshot quotes are missing. So write it as:

cr86e_name eq 'VariablecomingfromPowerApps'

[LoopinG2023]

Thank you very much, getting here thanks new error but different items, its in the Relate().

The value is the 'list of items' from list row

Row id: the newly created row waiting for relation.

Relate with: elements for the relation.

the error:

[Sundeep_Malik]

@LoopinG2023 

I have never used relate action in power automate. So I dont have any idea what it does. 

But I searched for it, and found, that in the relate with text box you have to add the url and item id both. Not just item id.

Giving you some links below. Check them out:

https://www.youtube.com/watch?v=ep_BojsZpQs

https://learn.microsoft.com/en-us/power-automate/dataverse/relate-unrelate-rows

[LoopinG2023]

I want to take a moment to express my sincere gratitude for your assistance