Answered

AddColumns inflict to data gallery.selected

(0) Share

Report

Posted on by ML-18090909-0

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

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
ML-18090909-0 31 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks verymuch 🙂 To be honest I tried with lookup but U put somethink like that :
LookUp(
ActionTrackerDPL;
Gallery1.Selected=ID
)