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.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!
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 🙂

Was this reply helpful? Yes No
LoopinG2023 59 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@LoopinG2023

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

cr86e_name eq 'VariablecomingfromPowerApps'

Was this reply helpful? Yes No
LoopinG2023 59 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
LoopinG2023 59 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No