PowerAPP sharepoint list filter empty column's

(0) Share

Report

Posted on by VTandon

Thanks

I need a help

Let have column (FirstName, LastName, Address, DOB, ContactNo)

I want the list to filter only if the column FirstName & ContactNo, both are IsBlank

Categories:

Building Power Apps

All responses (16)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If I understand you, you want to filter or see only blank columns for Firstname and contact? If so;
Filter (Datasource, Firstname="" && ContactNo = "")
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Loose Chippings 185 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @VTandon

The && in a statement means 'This AND That '. So you would use Filter(Source, IsBlank(FirstName) && IsBlank(ContactNo)).

The ||, [Shift \], means OR, so 'This OR That' and a filtered row would not show if FirstName OR ContactNo was blank.
VTandon on at

Like
a
(0)

Report
Copy link

Link copied!

did not worked
Loose Chippings 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you help by telling us what happened? Could you paste the code you have used? Did you get an error?
VTandon on at

Like
a
(0)

Report
Copy link

Link copied!

SortByColumns(Filter([@'CCStatement'], IsBlank(PONumber) && IsBlank(MerchantState), StartsWith(MerchantName, TextSearchBox1.Text) ), "MerchantName", If(SortDescending1, Descending, Ascending))

-----------------------------

Not filtering only if both column empty.
ONLY work with one column ...
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

can you show a sample of your table
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Loose Chippings 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Your code should work if both PONumber is blank AND MechantState is both. Or you could say "this is only TRUE when both PONumber is empty AND MerchantState is empty".

Try the code with just IsBlank(PONumber):
SortByColumns(Filter([@'CCStatement'], IsBlank(PONumber), StartsWith(MerchantName, TextSearchBox1.Text) ), "MerchantName", If(SortDescending1, Descending, Ascending))

and then try just IsBlank(MerchantState):

SortByColumns(Filter([@'CCStatement'], IsBlank(MerchantState), StartsWith(MerchantName, TextSearchBox1.Text) ), "MerchantName", If(SortDescending1, Descending, Ascending))

and make sure each one filters as you expect.
VTandon on at

Like
a
(0)

Report
Copy link

Link copied!

its a sharepoint list
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I asked if you could put a sample of your table
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

VTandon on at

Like (0)

Report

Copy link

Link copied!

MerchantNameMerchant CityMerchantStateOriginalAmountPONumberInvoice AttachmentItem TypeAttachments

ZORO UK	LONDON	GBR	£ 35.90		Item
VICTORY LIGHTING U	ST. ALBANS		£ 239.40	aaa	Item
INTEK ADHESIVES	BLYTH		£ 471.44		Item
SP * WSB MANUFACTURING	PERTH	LND	£ 78.00		Item
WWW.FIRST4MAGNETS.COM	08455194701		£ 798.54		Item
WAKERING ENGINEERING C	EVESHAM	GBR	£ 231.00		Item
GRAPHTEC GB LIMITED	WREXHAM	GBR	£ 35.06		Item
HITCHIN PLUMBING SUPPL	BEDFORDSHIRE	GBR	£ 500.29		Item
HITCHIN PLUMBING SUPPL	BEDFORDSHIRE	GBR	£ 692.39		Item