Power Platform Community Forum Thread Details

Hi all,

I am a new power app builder, so still searching and googling around. I hope someone can help me, because I am stuck on this part for a while now.

Background information:

I have 4 tables in dataverse:

- Employees (main column = name)

- Locations (main column = location)

- Specialties (main colum = specialty)

- Functions (main column = function)

The table Employees has a many to many connection with all the other 3 tables.

So far so good.

But now to relate and view that part....

I have a blank canvas with on the left side the list of employees (in a Gallery).

Next to that i have a Gallery with all the locations, a Gallery with all the specialties and a Gallery with all the functions. All these 3 with a toggle in front of it. I want to use the toggle to relate the employee. So as example let's start with the location.

On the location toggle I now have at the "OnCheck": Relate(GalerieEmployees.Selected.Employees; ThisItem)

It does not work, and the error showing: the first has to link to a "to many" relationship. But making it "GalerieEmployees.Selected.Name" also doesn't work. I have no idea how...

(The OnUncheck offcourse has the Unrelate part)

And when I select an Employee I want to set the default toggle to true if it is related.

If there is a button needed to relate and/or unrelate, that's also no issue, but I couldn't get that working either and removed it. (preferably 1 button for all 3 table relates if possible)

Looking forward to your help! 🤗

Categories:

Microsoft Dataverse with Power Apps