cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Cant search to the created by column?

Goodmorning all,

 

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. 

 

Search created column.png

 

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'

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Cant search to the created by column?

Try something like this:

SortByColumns(
Search(
Filter(
AddColumns(xxxx, "CreatedByFullName", 'Created By'.'Full Name'),
!Toggle1.Value = true || 'xxxx' = false
),
TextSearchBox1.Text,
"Title","Content","Subject", "CreatedByFullName"
),
"Created",
If(
SortDescending1,
Ascending,
Descending
)
)

Just keep in mind that AddColumns is limited by the delegation limit. So if you have more than 500 records (or at max 2000), we will have to use an alternate solution.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

View solution in original post

11 REPLIES 11
Highlighted
Super User
Super User

Re: Cant search to the created by column?

Do you want to search or sort by that column?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
Highlighted
Advocate II
Advocate II

Re: Cant search to the created by column?

Hello,

 

I want to search for the users.

Highlighted
Super User
Super User

Re: Cant search to the created by column?

Try something like this:

SortByColumns(
Search(
Filter(
AddColumns(xxxx, "CreatedByFullName", 'Created By'.'Full Name'),
!Toggle1.Value = true || 'xxxx' = false
),
TextSearchBox1.Text,
"Title","Content","Subject", "CreatedByFullName"
),
"Created",
If(
SortDescending1,
Ascending,
Descending
)
)

Just keep in mind that AddColumns is limited by the delegation limit. So if you have more than 500 records (or at max 2000), we will have to use an alternate solution.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Cant search to the created by column?

I got an error: the specified column createdbyfullname doens't exist.

 

I see the warning for the delegation. 

Highlighted
Super User
Super User

Re: Cant search to the created by column?

Did you add the AddColumns function as includes in my example?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
Highlighted
Advocate II
Advocate II

Re: Cant search to the created by column?

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 🙂

Highlighted
Super User
Super User

Re: Cant search to the created by column?

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
Highlighted
Advocate II
Advocate II

Re: Cant search to the created by column?

@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? 

Highlighted
Super User
Super User

Re: Cant search to the created by column?

Hi @WackdeMack

Apologies for the delay. Are you still facing this issue?

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,238)