Answered

Display Two List Data in a Gallery control of PowerApps form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SharePoint List of below items.

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).

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

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

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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@Anonymous
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."

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

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,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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???

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yutliu-msft ,
@mdevaney
Thank You Soo much you solved my problem. It is working fine for two display form control.

Was this reply helpful? Yes No