Unanswered

Flow for one to many relation with powerapps

(0) Share

Report

Posted on by 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.

All responses (6)

Answers (0)

LoopinG2023 59 on at

Like (1)

Report

Re: Flow for one to many relation with powerapps

I want to take a moment to express my sincere gratitude for your assistance
Sundeep_Malik 6,480 on at

Like (1)

Report

Re: Flow for one to many relation with powerapps

@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 59 on at

Like (0)

Report

Re: Flow for one to many relation with powerapps

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 6,480 on at

Like (0)

Report

Re: Flow for one to many relation with powerapps

@LoopinG2023

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

cr86e_name eq 'VariablecomingfromPowerApps'
LoopinG2023 59 on at

Like (0)

Report

Re: Flow for one to many relation with powerapps

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 6,480 on at

Like (0)

Report
Re: Flow for one to many relation with powerapps

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 🙂