Answered

Search, Filter, Lookup.... Nothing is really working

(0) Share

Report

Posted on by Sadiejane

I have tried several times with Search, Filter and then Lookup. The table is called "Trackings", my text box is called txt_Search_Assigned and the field is "Assigned to:" and is a lookup field using the AAD. When I add Search or Filter to the code below, I either get a incompatible search type or just an error with no other hints except something is wrong. I am in Teams trying to build a Canvas app. Thank you for any help in figuring this out.

This code works great.

Sort(

Search(

Filter(

Trackings,

IsBlank(dd_Search_Status.Selected.Value) || IsEmpty(dd_Search_Status.Selected.Value) ||'Status (crc44_status)' = dd_Search_Status.Selected.Value),

txt_search_Subject.Value,"crc44_subject"),

'CPAR Number',

SortOrder.Descending

)

*********************************

This code does not work.

Sort(

Search(

Filter(

Trackings,

IsBlank(dd_Search_Status.Selected.Value) || IsEmpty(dd_Search_Status.Selected.Value) ||'Status (crc44_status)' = dd_Search_Status.Selected.Value),

txt_search_Subject.Value,"crc44_subject"),

txt_search_Assigned, "crc44_Assignedto:"),

'CPAR Number',

SortOrder.Descending

)

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

vikas1606 206 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sadiejane - Can you confirm txt_search_Assigned should not have .Value like txt_search_Subject.Value we have in the above line?

Was this reply helpful? Yes No
Sadiejane 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, yes I had .Value in there, I just missed it when I added it to the sample.

Sort(
Search(
Search(
Filter(
Trackings,
IsBlank(dd_Search_Status.Selected.Value) || IsEmpty(dd_Search_Status.Selected.Value) ||'Status (crc44_status)' = dd_Search_Status.Selected.Value),
txt_search_Subject.Value,"crc44_subject"),
txt_search_Assigned.Value,"crc44_Assignedto"),
'CPAR Number',
SortOrder.Descending
)

Was this reply helpful? Yes No
vikas1606 206 on at

Like
a
(0)

Report
Copy link

Link copied!

I have just formated your code. Could you please use the below code and let me know if you still have any errors?
Sort(
Search(
Search(
Filter(
Trackings,
IsBlank(dd_Search_Status.Selected.Value) || IsEmpty(dd_Search_Status.Selected.Value) || 'Status (crc44_status)' = dd_Search_Status.Selected.Value
),
txt_search_Subject.Value,
"crc44_subject"
),
txt_search_Assigned.Value,
"crc44_Assignedto:"
),
'CPAR Number',
SortOrder.Descending
)

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sadiejane,

I noticed 3 things: (1) As @vikas1606 mentioned, the second txtInput does not has a .Value as the first one does, (2) I would expect the TextInput to be .Text and not .Value (3) is Assigned To: a LookUp to a User, because you can only search text fields.

In the options below, I will replace .Value with .Text because that worked in my case. Should it be different for you, feel free to replace it again.

(1) crc44_Assignedto: is a text field

Sort( Search( Search( Filter( Trackings, IsBlank(dd_Search_Status.Selected.Value) || IsEmpty(dd_Search_Status.Selected.Value) ||'Status (crc44_status)' = dd_Search_Status.Selected.Value ), txt_search_Subject.Text, "crc44_subject" ), txt_search_Assigned.Text, "crc44_Assignedto:" ), 'CPAR Number', SortOrder.Descending )

(2) crc44_Assignedto: is a LookUp to for example the User table:

Sort( Search( AddColumns( Search( Filter( Trackings, IsBlank(dd_Search_Status.Selected.Value) || IsEmpty(dd_Search_Status.Selected.Value) ||'Status (crc44_status)' = dd_Search_Status.Selected.Value ), txt_search_Subject.Text, "crc44_subject" ), "AssignedToFullName", 'Assigned to:'.'Full Name' ), txt_search_Assigned.Text, "AssignedToFullName" ), 'CPAR Number', SortOrder.Descending )

Double check whether the Assigned to column name was correctly written.

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
Sadiejane 76 on at

Like
a
(0)

Report
Copy link

Link copied!

I still have errors when I run this code. Thank you for your help on this-I hope we can figure it out.

Was this reply helpful? Yes No
Sadiejane 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Also, when I type the . after txt_search_Assigned, the prompt is for Value. But when I roll over the red squiggly line it says "Expect Text Type", but when I try .text that gives me errors too.

Was this reply helpful? Yes No
vikas1606 206 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sadiejane
Can you wrap txt_search_Assigned.Value with Text function and try it?
Text(txt_search_Assigned.Value)

Was this reply helpful? Yes No
Sadiejane 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Still errors and says wrong column type. Expects type text.

Was this reply helpful? Yes No
Sadiejane 76 on at

Like
a
(0)

Report
Copy link

Link copied!

I have now just tried to search or filter all by itself and continue to get errors-so maybe it's something else.

Was this reply helpful? Yes No
Sadiejane 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Laurens-Thank you for trying. This did not work. Could it be that the "Assigned to:" is using a lookup in the AAD table? The AAD table is the active directory table. I tried to just do a search or filter statement and I can't get anything to work. I am just not sure what else to try.

Was this reply helpful? Yes No