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:

Connecting to Data

All responses (4)

Answers (0)

CU29100747-0 48 on at

Like (0)

Report

Re: How to properly search in "Created by"

@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?
mdevaney 29,987 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to properly search in "Created by"

@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."
CU29100747-0 48 on at

Like (0)

Report

Re: How to properly search in "Created by"

@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?
mdevaney 29,987 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to properly search in "Created by"

@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."