web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to make formula wo...

Power Apps

Unanswered

How to make formula work with multiple inner joins

(0) Share

Report

Report

Posted on by jhblalock

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]));

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

PowerThomas 288 on at

Like
a
(0)

Report
Copy link

Link copied!
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!
jhblalock 10 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation