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?
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications