Answered

Gallery Search based on another table

(0) Share

Report

Posted on by coyote_ptm

Is it possible to use search to limit a gallery's rows based on data in a different table? Sharepoint lists: project and project_environments. The gallery will display project_environments. I'd like a search box to allow searching for fields in the project table and only display project_environments rows based on the returned rows project_uids.

The example search for the main project table looks like this:

Search(project, Lower( 'Search Text Input Main Screen'.Text ), "search_text_field" )

But - can I in some way use an "IN" to filter rows in another list based on the above search.

Thanks.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (3)

Answers (1)

eka24 20,921 on at

Like (0)

Report

Re: Gallery Search based on another table

Create a collection Onvisible of the screen:
ClearCollect (MyTable, Filter (project_environments, project_uids in Project.project_uids))

Then put the collection:
MyTable on the Gallery items

If you want to search again because it already filtered with project uids, insert a combobox and on its items put:
MyTable.project_uids

Then replace the Gallery items with:
Filter(MyTable,project_uids=combobox1.Selected.project_uids)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Re: Gallery Search based on another table

Hi @coyote_ptm ,

Could you please share a bit more about the data structure of your two SP Lists?

Is there a column in your project_environments to store the Project UID?

I assume that there is a column (called "Project_UID") in your project_environments to store the Project UID, based on the needs that you mentioned, I think the Filter function could achieve your needs.

Please consider try the following workaround:

Gallery Items property:

Filter( project_environments, Project_UID in Search(project, Lower( 'Search Text Input Main Screen'.Text ), "search_text_field" ).project_uid )

Note: The project_uid represents the column in our project list, which matches the Project_UID column in your project_environments List. Please replace them with actual column name from your two SP Lists.

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

Best regards,

Was this reply helpful? Yes No
coyote_ptm 56 on at

Like (0)

Report
Re: Gallery Search based on another table

Thanks for the fast help.

The 2 tables do include a project_uid column. In projects it is the unique identifier. In project_environments there is a combo key of project_uid and environment_id.

I think I was close here and it was the
.project_uid
on the end of the search that did the trick - returning only the project_uid for all the records, not the entire record.

Was this reply helpful? Yes No