Answered

Show some records in gallery

(0) Share

Report

Posted on by infinitepp

189

Hi, In this picture below is the collection that has column: license_number, and I do not want to show the record has "-" in the gallery.

This is the code that I've tried.

I am looking forward to hearing your feedback and advice

Thank you

ForAll(
 tbl_hist_insurance,
 If(
 license_number = "-",
 Hidden
 );
 Collect(
 col_insuranceData,
 {
 SaleCode: SaleCode,
 license_number: license_number,
 sale_TName: LookUp(
 tbl_mas_saleagents,
 Title = tbl_hist_insurance[@SaleCode]
 ).sale_TName,
 sale_FName: LookUp(
 tbl_mas_saleagents,
 Title = tbl_hist_insurance[@SaleCode]
 ).sale_FName,
 sale_LName: LookUp(
 tbl_mas_saleagents,
 Title = tbl_hist_insurance[@SaleCode]
 ).sale_LName,
 license_name: LookUp(
 tbl_mas_license,
 licenseCode = tbl_hist_insurance[@licenseCode]
 ).license_name
 }
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

proxyprochy 92 on at

Like (1)

Report
Copy link

Link copied!

The easiest way is:

If(license_name = "-", "")

= if licence name = "-", then it's replaced by empty string.

Hope it works!

Was this reply helpful? Yes No
proxyprochy 92 on at

Like (1)

Report
Copy link

Link copied!

Or if you want to hide the record completely from the gallery,

just specify in the LookUp function that you don't want records that contains "-" in the column license_number..

I'm not sure what your source looks like, but i guess you got the point:

LookUp(
tbl_mas_license,
licenseCode = tbl_hist_insurance[@licenseCode] && tbl_hist_insurance[@licenseCode] != "-")

Was this reply helpful? Yes No
infinitepp 189 on at

Like (0)

Report
Copy link

Link copied!

Yes I'd like to hide the record completely and This is error: Expectation Operator, I'm not sure what's my mistake.

Was this reply helpful? Yes No
proxyprochy 92 on at

Like (0)

Report
Copy link

Link copied!

you have to define what it doesn't equal to,

for example:
LookUp(MyColl, Column1.Value = stringA && Column1.Value != stringB)

Was this reply helpful? Yes No
Verified answer

praeclarus 34 on at

Like (1)

Report
Copy link

Link copied!
if you mean you want to hide the record has "-" in column license_number.
Maybe you can try this before ForAll function.
Remove( tbl_hist_insurance, First( Filter( tbl_hist_insurance, license_number = "-" ) ) );

Was this reply helpful? Yes No
infinitepp 189 on at

Like (0)

Report
Copy link

Link copied!

Thanks very much for your help! You are a magician.😘

Was this reply helpful? Yes No