How to search 2 columns in a gallery?

(0) Share

Report

Posted on by Da9

117

I have a gallery and an input component. I want to search the gallery with the input component for records by their ID

AND who created them.

Currently I have it working with just searching on the record ID, but I don't know how to add a second column to search for who created them in the formula. Anyone knows?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Hi @Da9 ,
May I ask what data source you have used?
Let us assume it is the SharePoint List.

Please try this:

Search( Search( Filter(AddColumns('DataSource',"CreatedName",'Created By'.DisplayName), YourConditions) Control1Name.Text,"CreatedName"), Control2Name.Text,"Title" )

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Da9 117 on at

Like (0)

Report

Hi, I'm using Dataverse as the data source. This function is only for searching the gallery, not for adding anything.
See this screenshot of how I imagined it working. Red is what I have now, orange is what I wanted to add, but its not working.

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

Like (0)

Report
Hi @Da9 ,
In fact, "Created By" is the LookUp Column in the Dataverse, but the Search function is only used to search for text. The Addcolumn() function helps you create a temporary table without making any changes to the data source.
Search:

Search( AddColumns('0711AS',"CreatedName",'Created By'.'Full Name'), Control1Name.Text, "ColumnName", "CreatedName")

if you do not want to use AddColumn Function, we suggest you try Filter:

Filter('0711AS',Control1Name.Text in 'Created By'.'Full Name' || Control1Name.Text in 'ColumnName')

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Da9 117 on at

Like (0)

Report

How can I add the AddColumn function in my current formula? I already use the Filter function to sort the gallery by creation date.

Is this a variable or is it connected to something?
'0711AS',Control1Name.Text

My current formula:

SortByColumns(
Search(
Filter(
'Challenging Wells',
'Created By'.'Primary Email' = User().Email || 'Sector Level Responsible'.'Primary Email' = User().Email || 'BU Level Responsible'.'Primary Email' = User().Email || 'BC Level Responsible'.'Primary Email' = User().Email
),
'Search Input'.Text,
"dwcw_wellid"
),
"createdon",
SortOrder.Descending
)

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

Like (0)

Report
Hi @Da9 ,

'0711AS' is my Data Source form dataverse.

SortByColumns( Search( Filter( AddColumn('Challenging Wells',"CreatedName",'Created By'.'Full Name'), 'Created By'.'Primary Email' = User().Email || 'Sector Level Responsible'.'Primary Email' = User().Email || 'BU Level Responsible'.'Primary Email' = User().Email || 'BC Level Responsible'.'Primary Email' = User().Email ), 'Search Input'.Text, "dwcw_wellid", "CreatedName" ), "createdon", SortOrder.Descending )

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Da9 117 on at

Like (0)

Report

Sadly its still giving me an error with the above formula. It looks like it should work, but doesn't.

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Hi @Da9 ,

Sorry it is my bad.
Please try this:
AddColumn->AddColumns
SortByColumns( Search( Filter( AddColumns('Challenging Wells',"CreatedName",'Created By'.'Full Name'), 'Created By'.'Primary Email' = User().Email || 'Sector Level Responsible'.'Primary Email' = User().Email || 'BU Level Responsible'.'Primary Email' = User().Email || 'BC Level Responsible'.'Primary Email' = User().Email ), 'Search Input'.Text, "dwcw_wellid", "CreatedName" ), "createdon", SortOrder.Descending )

Best Regards,
Tina

Was this reply helpful? Yes No
Da9 117 on at

Like (1)

Report

Thank you! Works now 🙂

Was this reply helpful? Yes No