Conditionally add record to table?

(0) Share

Report

Posted on by Cooper01

664

I am using a Table for the Items property of a gallery:

Table(
 {
 Date: Today(),
 Status: "Pending"
 },
 {
 Date: Today(),
 Status: "Pending"
 }
)

This works as expected, but I am trying to conditionally show/hide items to be displayed in the gallery. I noticed that if I add a condition around one of items in the table, it still adds the item but it's blank.

Is there any way to completely ignore adding the item to the table? I want there to truly only be one record shown in the gallery that displays this table. This example below will show two items, one with fields shown (first) and one without.

Table(
 {
 Date: Today(),
 Status: "Pending"
 },
 If(
 true = false,
 {
 Date: Today(),
 Status: "Pending"
 }
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Cooper01

Filter!

Please consider changing your Formula to the following:

Filter( Table( { Date: Today(), Status: "Pending" }, { Date: Today(), Status: "Active" } ), Status <> "Active" )

I am not sure of what you are really trying to do as your example has two records that are identical. But, the basic concept is to filter your table to get what you want.

I hope this is helpful for you.

Was this reply helpful? Yes No