Announcements
I need to connect the gallery to show data collected from a certain area instead of showing all data collected. Currently, my function is Search('Production Stoppage - DRAFT 1','Search Box_1'.Text, "OrderNo_x002e_") which allows me to search for a particular order, however I need the gallery to only show for area (list column) "Vertical".
Hi @Evan_S1,Please use below formula - Search(Filter('Production Stoppage - DRAFT 1', Area.Value="Vertical"), 'Search Box_1'.Text, "OrderNo_x002e_")
Assuming Area column to be of type Choice. If Area is of type single line of text, remove .Value attribute
This works, 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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 316 Most Valuable Professional
11manish 242
Valantis 198
