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]));
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
)
)
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!
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473