Delete Gallery Rows

(0) Share

Report

Posted on by MSDigitalUser

138

Hi All,

I want to delete some rows in a gallery with condition that column " Quantity " is blank. As am sending the gallery over mail and I want to avoid send rows with blanks in Quantity column.

Thanks,

Categories:

Building Power Apps

All responses (20)

Answers (1)

Sort by

Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Where does the gallery data come from?
MSDigitalUser 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello static excel
Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Would this work?

Gallery.Items

Filter(DataSource,!IsBlank(Quantity))
MSDigitalUser 138 on at

Like
a
(0)

Report
Copy link

Link copied!

not working
MSDigitalUser 138 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to have a button to remove the rows
Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are you trying to remove rows in your datasource (Excel)?
MSDigitalUser 138 on at

Like
a
(0)

Report
Copy link

Link copied!

I am just sending this gallery in a email, so I want to avoid sending rows that have no quantities.
Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for asking so many questions.

What method are you using to send the gallery as email?
MSDigitalUser 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Office365Outlook.SendEmailV2(

and am creating a table html to be in the email body- it is working fine, but I need to remove rows where the quantities are blank.
Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Put your table in a collection with ClearCollect and then use this function

Button
Remove(yourcollection,Filter(yourcollection,IsBlank(Quantity)))
and then turn collection into html