To manage my gallery I use formuka like this:
Search(SortByColumns(AddColumns(ActionTrackerDPL;"User";'Created By'.DisplayName;"User2";'ActionDriver'.DisplayName;"User3";'AreaManager'.DisplayName;"Obsar";Department.Value);"Prio_x0020_to_x0020_number";SortOrder.Descending);TextInput1.Text;"User";"User2";"User3";"Obsar")
The AddColumns gave my posibility to use text box to search column with person.
Then in diffrent screen i present more data connected to item using EditForm and gallery.selected. Without AddColumn formula everythink works good, but with is error.
I know that AddColumns chcange DataSource but do u have any idea who to fix it? Or maybe use diffrent formula to use search with person column
Thanks verymuch 🙂 To be honest I tried with lookup but U put somethink like that :
LookUp(
ActionTrackerDPL;
Gallery1.Selected=ID
)
Hi @Nacked ,
Change the Items of your Form to
LookUp(
ActionTrackerDPL;
ID = GalleryName.Selected.ID
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 2