Answered

Need to search on 'Created By' from Sharepoint list

(0) Share

Report

Posted on by gmurnock

Anyone know how to add column "Created By" into a Search function? Created By column is default in a SharePoint list, and is populated in this case, however is not available to use in a search function for a Gallery.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @gmurnock

Search Function supports only string searches.
Have you used Filter / Lookup functions? They will work with Person fields
https://www.youtube.com/watch?v=tPxE_-DcWkg

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @gmurnock ,

Do you want to search your Gallery items based on the 'Created By' column in the Search function?

Currently, within PowerApps, when using Search function to filter table records, we could only specify Text type column as search column. We could not specify complex type column (e.g. Choice, Person, LookUp type column, ...) as Search column within it.

Note: The 'Created By' column is actually a Person type column.

As an alternative solution, I think the AddColumns function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery to following:

Search( AddColumns('YourSPList', "CreateByUser", 'Created By'.DisplayName), TextSearchBox1.Text, "CreatedByUser", "OtherTextColumn1", "OtherTextColumn2", ... )

Note: Please also set the "Data row limits for Non-delegable" queries option to maximum value -- 2000 within Advanced settings of App settings of your app.

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Filter worked great for me. Thanks for the delegation videos, @RezaDorrani .

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

We can also now search on columns like Created By with this workaround: https://powerusers.microsoft.com/t5/Community-App-Samples/Large-SP-List-Delegation-Workaround-App/td-p/2330721

Was this reply helpful? Yes No
abhijithshastry 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the response. We had a similar scenario where we had to filter the records where current login user is in multiple Person fields in SharePoint, and your logic worked absolutely well with all delegation warnings removed !!

This is a sample code:
SortByColumns(
Search(
AddColumns('List Name',
"AuthorEmail", Lower('Created By'.Email),
"ManagerL1Email", Lower('Manager Name L1'.Email),
"ManagerL2Email", Lower('Manager Name L2'.Email),
"SecondaryL1Email", Lower('Secondary Approver L1'.Email),
"SecondaryL2Email", Lower('Secondary Approver L2'.Email)
),
varCurrentUserEmailLower,
"AuthorEmail", "ManagerL1Email", "ManagerL2Email", "SecondaryL1Email", "SecondaryL2Email"
),
"ID",
SortOrder.Descending
)

Cheers,
Abhijith

Was this reply helpful? Yes No