Create a lookup app

(0) Share

Report

Posted on by CU04090430-1

end user selects or searches a name of a package.

the look up returns all the components of that package

Data schema looks like this

Package name	Package component	Desctiption	part number
Package A	Comp A
Package A	Comp B
Package A	Comp C
Package A	Comp D
Package B	Comp A
Package B	Comp C
Package B	Comp E
Package C	Comp B
Package C	Comp Z

app similar to below mock up

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 6,661 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU04090430-1,

Left Side :

Gallery Items Property :

With({SearchTerm:SearchInput2.Text},Search('5000 Sales Records',SearchTerm, Country))

SearchInput2.Text - Control above (Text box)

Country- Column Name in the backend list.

You need to use the gallery for the right side but i have used the form control.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
MS.Ragavendar 6,661 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU04090430-1,

The solution which i shared is skeleton, however it can be enhanced based on the requirements.

Optimization can also be considered in terms of delegation as well.

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

https://www.matthewdevaney.com/sharepoint-delegation-cheat-sheet-for-power-apps/

Kindly have a look.

1 people found this reply helpful.

Was this reply helpful? Yes No
MS.Ragavendar 6,661 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU04090430-1,

A quick follow-up to see, does the suggestion worked for you or still you were looking for any other approaches or assistance.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No