Microsoft Dynamics 365 | Integration, Dataverse...

Filter in Power Apps

(0) Share

Report

Posted on by De Yves

Hello, I am unable to apply the filter function in a canvas Power apps based on dataverse.
The table name is EssaiNew, in this table there is a column named Status. This column is of multiple choice type, it has these values (In progress, Approved, Renewed).
I would like to display data from the EssayNew table based on the values in the Status column.

Here is the function I wrote in the Items property of a Gallery, none works:
1 - Filter(EssaiNews; Status="In progress")
2 - Filter(EssaiNews; 'Status (EssaiNews)'= "In progress")
3- Filter(EssaiNews; 'Status (EssaiNews)'.'In progress'="In progress")

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Abhi 120 on at

Like (0)

Report

HI De Yves,

I have an idea if you interest try this one.

Create a one text field(TextInput) and button. Select the Button control (Find) and apply this below formula on its OnSelect property as:

OnSelect = ClearCollect(

EssaiNews,

Filter(

'Listname',

status = Value(TextInput.Text)

)

);

OR

try this only in your field

Filter(

'Listname',

status = Value(TextInput.Text)

);

Thanks,

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Use below function in the items property of your gallery.

Filter(EssaiNews , Status=Dropdown1.Selected.Value)

Dropdown1.Selected.Value is the value selected in dropdown, this dropdown is filling distinct values from EssaiNews table Status field

You can use below function on items of dropdown
Distinct(EssaiNews ,Status)

Was this reply helpful? Yes No