Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Gallery to show multiple tables

(0) ShareShare
ReportReport
Posted on by 227

Is it possible to have your main gallery show multiple linked fields from 3 tables

 

EG - show field 1 from another tabled based on unique key?

 

J

Categories:
  • Måns Profile Picture
    Måns 18 on at
    Re: Gallery to show multiple tables

    Thanks for info, this helped me, but I´m working with a bridgeTable also. 

    like this:

     

    Table1cardenalityTable2cardenalityTable3
    User 1---*UserPermissons*---1Permissons
    UserID UserID PermissonID
    UserName PermissonID PermissonName

     

    I´m trying to display UserName and PermissonNames associated with that user in a Gallery. How would you go about modifying you formula to achieve that?

     

    Best regards Måns

  • Verified answer
    h-nagao Profile Picture
    h-nagao 392 on at
    Re: Gallery to show multiple tables
    You seems to have multiple topics, so lets discuss about form on appropriate topic 🙂
  • jesenavaranjan Profile Picture
    jesenavaranjan 227 on at
    Re: Gallery to show multiple tables

    Okay so now to take it further...

     

    How do I now relate a form to the items

     

    So... I need the Item property to be the related fields..

     

    Jese

  • h-nagao Profile Picture
    h-nagao 392 on at
    Re: Gallery to show multiple tables
    It’s glad for me as well.
    Thank you.
  • jesenavaranjan Profile Picture
    jesenavaranjan 227 on at
    Re: Gallery to show multiple tables

    Okay!

    It's worked now.

    I had multiple gallery's within my page (becoming visible/invisible) based in some filters

    So I had made a mistake

    THANK YOU SO MUCH

  • Verified answer
    h-nagao Profile Picture
    h-nagao 392 on at
    Re: Gallery to show multiple tables
    It’s not directly answer for your question, because I have to check “where xxx is latest” is correctly work, but if you want to select latest record, it is better to use SortByColumns function;
    LookUp(SortByColumns(datasource, “sysdate”, Descending), MilestoneID=....)
  • jesenavaranjan Profile Picture
    jesenavaranjan 227 on at
    Re: Gallery to show multiple tables

    And here are my tables for clarification

  • jesenavaranjan Profile Picture
    jesenavaranjan 227 on at
    Re: Gallery to show multiple tables

    Like this? for multiple criteria

  • jesenavaranjan Profile Picture
    jesenavaranjan 227 on at
    Re: Gallery to show multiple tables

    I am doing the same thing as your screen shot

     

    Can I use multiple criteria? Is it because the database thinks there could be more than 1 row

     

     

  • h-nagao Profile Picture
    h-nagao 392 on at
    Re: Gallery to show multiple tables
    Attached is screenshot of my sample app and data. Data source is not sql but SharePoint List.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard