I have a page in my app that has a search bar to search in a gallery on the same page. I want to be able to search on a specific field used in the sharepoint thats used on the gallery. The field that i want to search on is called
Leerlingschildernaam. This field in sharepoint is a lookup field that selects a name from a different sharepoint list. This means that the usual
(Search(Beoordelingen;zoeken.Text; Leerlingschildernaam) doesnt work (neither does .text or .value behind Leerlingschildernaam). How can i make this colom searchable?
I never use a List for a Gallery. Always a collection, mainly for sorting. (Especially when a Lookup or Person/Group column is in the list.)
ClearCollect(colDataFromList, 'List Name', {criteria as needed});
ClearCollect(colDataFromListWithSortFields,
colDataFromList,
AddColumns(
PersonNameSort: Person.DisplayName, //Extract Displayname from the Person Record
SiteSort: Site.Value, //Extract Site text value
CategorySort: Category.Value //Extract Category text value
"CanEdit": "No", //Make flags in the row for things like dynamic rendering of controls
"IsEdited": "No" // or knowing if the record was changed.
)
);
I'm sure there's some way to do this in a single step, but this way makes it easier to debug.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
