Skip to main content
Community site session details

Community site session details

Session Id : TGCvRox2JTAJDERXbGk8aM
Power Apps - Building Power Apps
Unanswered

How to make formula work with multiple inner joins

Like (0) ShareShare
ReportReport
Posted on 1 Feb 2023 21:28:16 by 10

Hello!

 

Trying to create a formula based on the following query with multiple inner joins and have no idea on how to proceed on something like this. Any help?

 

SELECT Trans_Poles.Trans_Pole_Stencil, Trans_Drawings.Trans_Dwg_Name, Trans_Drawings.Dwg_Title, Trans_Drawings.Dwg_Rev_No, Trans_Drawings.Dwg_Rev_Date
FROM Trans_Drawings INNER JOIN (Pole_to_Dwg_Junction INNER JOIN Trans_Poles ON Pole_to_Dwg_Junction.Trans_Pole_ID = Trans_Poles.Trans_Pole_ID) ON Trans_Drawings.Trans_Dwg_ID = Pole_to_Dwg_Junction.Trans_Drawing_ID
WHERE (((Trans_Poles.Trans_Pole_Stencil) Like [TextSearchBox1]));

  • jhblalock Profile Picture
    10 on 01 Feb 2023 at 23:09:27
    Re: How to make formula work with multiple inner joins

    How do I incorporate this AddColumn into what I currently have? Again I apologize..I am totally new to this:

     

    SortByColumns(
    Search(
    [@'[dbo].[Trans_Drawings]'],
    TextSearchBox1.Text,
    "Dwg_Title",
    "Trans_Dwg_Name"
    ),
    "Dwg_Title",
    If(
    SortDescending1,
    Descending,
    Ascending
    )
    )

  • PowerThomas Profile Picture
    277 on 01 Feb 2023 at 22:14:12
    Re: How to make formula work with multiple inner joins

     

    Search(
     AddColumns(
     'Poles to Drawings',
     "Stencil",
     LookUp(
     Poles,
     Pole = 'Poles to Drawings'[@Pole].Pole,
     Name
     )
     ),
     TextInput1.Text,
     "Stencil"
    )

     

    In your Gallery you can reference all the fields like this:

    ThisItem.Drawing.Name

    ThisItem.Drawing.Title

    ThisItem.Drawing.Rev_No

    ThisItem.Drawing.Rev_Date

    ThisItem.Stencil

     

    ━━━━━━━━━━━━━━━━━━━━━━━━━
    If I have answered your question, please mark your post as Solved✔️
    Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.
    If you liked my response, please consider giving it a Thumbs Up👍 Thank you!

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete