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

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (5,456)