I have a question about the created column of a SharePoint list. I want to search this column in the searchbox of my gallery. When i build my search, i can use almost every (text) column but i can't search the "created by" column.
SortByColumns( Search( Filter( xxxx, !Toggle1.Value = true || 'xxxx' = false ), TextSearchBox1.Text, "Title","Content","Subject", ), "Created", If( SortDescending1, Ascending, Descending ) )
I see only the created column instead of the created by column? My list is in Dutch so i see 'Gemaakt door'
Solved! Go to Solution.
Really awesome! i forget the AddColumn. Didn't know that i also can use AddColumn for the search part. I will dive in to the documentation about this topic.
Thanks in advance 🙂
@PowerAddict Yesterday the solutions work perfect but this morning, all my apps give an invalid datasource.
After soms trouble shooting, i remove the :
AddColumns( Incidenten, "CreatedByFullName", 'CreatedBy'.DisplayName
After this, the apps works fine. Very very strange because the apps works fine yesterday. Can you find why the datasource is suddenly invalid?
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!