cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vjnvinod
Frequent Visitor

Sorting creates blank

Hi,

 

I am using the below code to sort my gallery

 

If(IsBlankOrError(LookUp(Opportunities,'OP Email Id'=Label7_1.Text,'OP Email Id')),

SortByColumns(Opportunities, "field_6",Ascending,"field_8",Descending),

Sort(Filter(Opportunities,'OP Email Id'=Label7_1.Text),'Total Value ',Descending))

 

which is giving me the output of what i need

 

but it's showing the first 2 lists as blank, how do I remove it or filter it out with the above code?

vjnvinod_0-1641908308455.png

 

3 REPLIES 3
alaabitar
Solution Specialist
Solution Specialist

Hello,

In your filter you can do something like

Filter(Opportunities,'OP Email Id'=Label7_1.Text && !IsBlank('OP Email Id'))

 

Best regards,

Alaa

@alaabitar 

 

it shows some delegation errors & doesn't work 

vjnvinod_1-1641960029091.png

 

 

alaabitar
Solution Specialist
Solution Specialist

Can you just add a " ! " before isblank please.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (3,737)