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?
Class of 2020- Season 2
Featuring samples like Return to the Workplace and Emergency Response Applications
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Features releasing from October 2020 through March 2021