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 it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand