cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PadminiDeshudu3
Level: Powered On

Display Two List Data in a Gallery control of PowerApps form

I have a SharePoint List of  below items.

Pic1.png

In the PowerApps form I have a Gallery control with a display form. I have added one button control in that screen. In the Display form I have displaying the Gallery selected item.  In my button control I wrote the below rule so that particular Item Id will save to a Different SharePoint List named as "AboutCountry" title column(Default column).

Picnew2.png

Below one is "AboutCountry" list where we can see the ID value in the Title(Capital) column.

PicNew3.png

I have added two more column in the "AboutCountry" field as "LargestCity" and "OfficialLanguage".

PicNew4.png

Now My requirment is I want to display this 2 list(Country and About Country) data in a Different Gallery control. I want when user will click on the next icon of Gallery control, then respective item details should come in the Details form. I donot know how I can manage two list item in a Gallery control. Please Share with me if any body have solution.

In the Gallery control single list data we can show easily but two list data how to do?? I want based on the ID It should filter. For Example In the Gallery we will show the Country Name. When user will click on the Country name on the Gallery control next icon  he should able two see all details like "Population", "PerCapitaIncom", "LargeCity" and "officialLanguage" of respective item. Suppose user click on "India" he can able to see all details in the Details Form like population in india, PerCapita income in India, Large City in India and Official language in India..I donot know it is possible or not??

Regards,

Padmini

3 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Display Two List Data in a Gallery control of PowerApps form

@PadminiDeshudu3

My question is do your datasources Countries and About Countries have a one-to-one relationship? Meaning, for every entry in Countries is there a single matching entry in About Countries?  If the answer is yes, here's what you can do:

Add a blank label to the Country gallery and use the following LookUp formula in the Text property.  This solution assumes the ID for India is the same in both the Countries and About Countries tables.

 

LookUp(AboutCountry,ID=ThisItem.ID,LargestCity)

 

Let me know if this works

---

Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly.  If your thought the post was helpful please give it a "Thumbs Up."

 

 

View solution in original post

Community Support Team
Community Support Team

Re: Display Two List Data in a Gallery control of PowerApps form

Hi @PadminiDeshudu3 ,

Do you mean that ID(country list) and Title(about country list) have the same value?

Could you tell me whether you want to display two lists information in one gallery or in one display form?

I assume that you want to display country list in gallery and display two lists information in details in the right part.

Try this:

1)set gallery's Items: country

2)insert two display forms in the right part.

form1's data source:  country

form1's Item: gallery1.selected

form2's data source: about country

form2's Item: LookUp(about country,Title=gallery1.selected.ID)

 

Please note that one form could only have one data source.

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PadminiDeshudu3
Level: Powered On

Re: Display Two List Data in a Gallery control of PowerApps form

Thank You Soo much you solved my problem. It is working fine for two display form control.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Display Two List Data in a Gallery control of PowerApps form

@PadminiDeshudu3

My question is do your datasources Countries and About Countries have a one-to-one relationship? Meaning, for every entry in Countries is there a single matching entry in About Countries?  If the answer is yes, here's what you can do:

Add a blank label to the Country gallery and use the following LookUp formula in the Text property.  This solution assumes the ID for India is the same in both the Countries and About Countries tables.

 

LookUp(AboutCountry,ID=ThisItem.ID,LargestCity)

 

Let me know if this works

---

Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly.  If your thought the post was helpful please give it a "Thumbs Up."

 

 

View solution in original post

Community Support Team
Community Support Team

Re: Display Two List Data in a Gallery control of PowerApps form

Hi @PadminiDeshudu3 ,

Do you mean that ID(country list) and Title(about country list) have the same value?

Could you tell me whether you want to display two lists information in one gallery or in one display form?

I assume that you want to display country list in gallery and display two lists information in details in the right part.

Try this:

1)set gallery's Items: country

2)insert two display forms in the right part.

form1's data source:  country

form1's Item: gallery1.selected

form2's data source: about country

form2's Item: LookUp(about country,Title=gallery1.selected.ID)

 

Please note that one form could only have one data source.

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PadminiDeshudu3
Level: Powered On

Re: Display Two List Data in a Gallery control of PowerApps form

Thank You Soo much you solved my problem. It is working fine for two display form control.

View solution in original post

PadminiDeshudu3
Level: Powered On

Re: Display Two List Data in a Gallery control of PowerApps form

Your Solution helpful for me to display new column data in the Gallery control. Thank you very very much. Smiley Happy

PadminiDeshudu3
Level: Powered On

Re: Display Two List Data in a Gallery control of PowerApps form

I have used the lookup column and able two see largecity data. Now I want to add the search functionality based on largest city. Somehow we displayed the column value using the lookup function but how to achieve the search functionality. I have added a Text box control. Then what to do? gallery control is connected to Countries data source. But I want to filter based on about country largestcity column. How to achieve???

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (6,204)