Power Platform Community Forum Thread Details

hey guys i need assistance with multi form and dataverse relationship

i have these two table , Applicant and Supervisor table , these two table have 1- many relationship , many applicant can be assigned to one supervisor , i want to link these table , the applicant can select a supervisor on their application screen , supervisor details ,the supervisor name is retrived from User table on dataverse , now i want to link these two form to be related , i tried using Set(super,'applicant form'.LastSubmit.Supervisor) on select property on submt button of applicant , and i used the variable on supervisor form on supervisor name property - Defaultseleteditems - super but it doesnt show once i nevigate to that screen the name of the supervisor that was selected by a user

Categories:

Microsoft Dataverse with Power Apps

@swelihle

You would need to show your screens and the code in them (the button for instance), order or actions is important so you have to share the actual code and forms, not just say it.

Also, any control that has defaultselecteditems is going to be something that expect multiple things. That would not be the proper control for assigning a user field too (not really).

Also in each table, you then have a LookUp to the User Table?

So for instance what you should do is this.

Gallery 1 (Applicants on Screen 1)

-They select something

Gallery 2 (SuperVisor on Screen 2)

Item property = Gallery1.Selected.SupervisorLookUpColumn which will then set this gallery to load all the data from the Supervisor table.

in the Gallery you can add a Text box for instance and assuming you have a lookup to the User table IN the supervisor table you would do this

Text Property = ThisItem.UserLookUpColumn.Name or Display Name or whatever you want from user table

So it really needs more information to truly help you. But this is the basis to do it based on what you said and some educated guess work.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey