Unanswered

Connecting two forms (based on two different tables) to one gallery

(0) Share

Report

Posted on by jkra

Hi,

I have two tables (Locality and Registrations) that are connected by one entity "Locality.name". I have a screen for "registration overview" where I´ve linked a form to a gallery (these are both connected to the "Registration"-table, and together through Items = Gallery.Selected)

I want to insert another form in this same page that displays the Locality based on which registration is chosen in the gallery. Is there a way to connect a form to an entity so that all the information pops up? This last form would have to be connected to Locality.

Extra info:

There is only one set of info for Locality.Name, so even though there are several registrations in one Locality, the information (for ex. Technology and Company) will remain the same. I have 6 different Localities, and endless registrations.

Any tips?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

vivekravi 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you trying to filter out the form based on locality? If so can you just use a dropdown instead of using form?

Was this reply helpful? Yes No
jkra 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, no - i want the form to display the locality spesifications (all the columns i’ve added in the localitytable). However I want it to recognize that if you choose a registration from the gallery that one form shows the registration specifics, and the other form shows the locality specifics based on where the registration took place..

i don’t know if that made sense..

Was this reply helpful? Yes No
vivekravi 241 on at

Like
a
(0)

Report
Copy link

Link copied!

ok got it. I still have hard time to comprehend this. is it possible to share some screen shots of both the list with some data (if possible), for me to recreate this?

Was this reply helpful? Yes No
jkra 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I will link the screen in my next reply

Was this reply helpful? Yes No
jkra 21 on at

Like
a
(0)

Report
Copy link

Link copied!

So the gallery and the first form are both connected together and to the Registrations table. however i would like the table below to show the spesifics of the location in which the registration was made if that makes sense

Was this reply helpful? Yes No
vivekravi 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you try using the following in the items property of the location form.

Filter(Lokaliteter,Lokaliteter.Lokalitet=Gallery.selected.Localitet)

Was this reply helpful? Yes No
jkra 21 on at

Like
a
(0)

Report
Copy link

Link copied!

It doesn't work. I should add that the locality name has two different names in registrations and location...

Was this reply helpful? Yes No
vivekravi 241 on at

Like
a
(0)

Report
Copy link

Link copied!

So you should basically mention the filter condition,

Filter (YourLocationList, Gallery.Selected.LocationName=LocationList.LocationName).

Was this reply helpful? Yes No
jkra 21 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, thank you so much. Do you know when to use the different names? Like when to use the schema name and when to use the name i've given the column?

Was this reply helpful? Yes No
vivekravi 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I did not get you. and did it work?

Was this reply helpful? Yes No