PowerApps: Unable to Filter/Search DataTable on a choice SharePoint column

0
votes

I have SharePoint list I'm viewing in a PowerApps screen using the DataTable control. I need to filter down the rows based on if one of the fields (happens to be a choice of string values) has a certain value.

enter image description here

I have a drop-down control (Dropdown1) that has all the choices for that field. Its items property is "Choices('SD Fast'.Progress)".

enter image description here

Here is the expression that is used as the source (Items property) for the DataTable control:

Search('SD Fast', Text(Dropdown1.SelectedText.Value), "Progress")

I'm getting an error message on this expression: "The function search has some invalid arguments".

enter image description here

If I change the search to look at a plain text column, it works fine.

Please advise. Thanks, guys!

1
powerappspowerapps-formulapowerapps-canvas

1 Answers

0
votes

This is the expression that solved the problem:

Filter('SD Fast', Dropdown1.SelectedText.Value in Progress.Value)

I needed to use the "in" operator and also reference the Value property of that field.