Unanswered

Export Double Filter Not Working with Text Search

(0) Share

Report

Posted on by MarkIsConfused

I've been trying to get a double filter when running a task to work but it only uses the first filter still, trying to sort by a drop down and then search for any text in the Title field.

ExportTaskEquipment.Run(

"startswith(EquipmentType,'" & drpEquipmentChoice.SelectedText.Value & "') and '" & txtEquipmentFilter.Text in Title & "'",

User().Email

);

The startswith runs just fine by the second part doesn't work but I have no errors, any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MarkIsConfused
Try
ExportTaskEquipment.Run( "startswith(EquipmentType,'" & drpEquipmentChoice.SelectedText.Value & "') and '" & txtEquipmentFilter.Text & "' in Title", User().Email );

Was this reply helpful? Yes No
MarkIsConfused 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks DJ but no luck. No errors show up in power apps but it does fails when running the flow.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Forgot this is an ODTA filter query!
Correct way to check if a value is in a column, is: contains(Column, 'value')
So could you give this a whirl and then let me know what Power automate receives? It should be:
(startswith(EquipmentType, 'your value')) and (contains(Title, 'your value'))
Throw it into a Context Var for now and check what's inside it.
UpdateContext({varTemp: ExportTaskEquipment.Run( "("(startswith(EquipmentType, '" & drpEquipmentChoice.SelectedText.Value & "')) and (contains(Title, '" & txtEquipmentFilter.Text & "'))",User().Email)})

Was this reply helpful? Yes No
MarkIsConfused 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I got back varTemp (Boolean: true)

Was this reply helpful? Yes No