Unanswered

How to properly search in "Created by"

(0) Share

Report

Posted on by CU29100747-0

HI,

can someone help me figure out how to properly search in "created by" (data source = SharePoint list) column of data table?

Currently I'm using "AddColumns" and it works great, I can search according to user name .... but just because of that I have problems with my next screens (e.g. Detail screen - showing "Data source" error).

Simply, datatable.selected doesn't show any records details. Everything's back to normal when I remove "AddColumns".

I assume it's because I added new column with "Addcolumns" function which doesn't exist in my origin data source.

My Home Screen data table "Items" formula:

SortByColumns(
Search(
AddColumns(MySharePointlist, "CreatedByUser", 'Created By'.DisplayName),
SearchInput.Text,
"CreatedByUser",
"Title",

...other text columns to search...
), "Created", Descending)

Data source error on my detail screen:

So...

1, is there any other way how to search in "Created by" column, without using AddColumns

2, how to adapt my next screens (e.g. detail screen) data source while using AddColumns in my home screen?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Lubeno78
You can use a ComboBox control with this code in the Items property to look for the user.

Choices(your_datasource_name.'Created by')

Then use this code in the Items property of your data table

Filter(your_datasource_name, 'Created by' = ComboBox1.Selected)

Watch this video if you require a full set of instructions:

https://www.youtube.com/watch?v=tPxE_-DcWkg

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
CU29100747-0 48 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney thank you for reply.

Combo box with "Choices(MySharePpointList.'Created By') shows only some strange ID's, see below.
.DisplayName is not possible to use.
How to show user's name?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Lubeno78

You'll want to change both the DisplayFields and SearchFields property of the Combobox to this code

["DisplayName"]

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
CU29100747-0 48 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney sorry, but that doesn't work.
...["DisplayName"]
showing me "member of..." text, I don't know why.
I tried all other options (JobTitle, Email, Dept...), same strange results. Do you know why?

Was this reply helpful? Yes No