Unanswered

DataTable how to hide rows based on column value

(0) Share

Report

Posted on by Alex_WT

Hi,

I am creating a powerapp that stores data using a DataTable with values "Resolved," and "Assigned." But I need to find a way that when it becomes resolved it then becomes hidden. Any help would be great!

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-mengmli-msft on at

Like (1)

Report
Hi @Alex_WT ,

I recommend you use Filter action on Items of DataTable.

Filter(DataSource,ColumnName="Assigned")

Then DataTable will only show rows with "Assigned".

Best regards,

Rimmon

Was this reply helpful? Yes No
Alex_WT 10 on at

Like (0)

Report

Thank you for your reply. Could you help me further I am currently using this to format the table and when trying to add that Filter it does not work. The blanked out is a datasource.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Hi @Alex_WT ,

Thanks for the reply.

What is the result of your current formula? Also, what is the type of Name column?

Filter(DataSource,Name.Email=User().Email)

What can I do for you? Could you please show more details?

If you don't sure how to add condition in Filter formula, you can refer to this.

Filter(DataSource,ColumnName="Assigned"&&Name.Email=User().Email)

Best regards,

Rimmon

Was this reply helpful? Yes No