cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Djanan
Level: Powered On

Show everything except...

I have a app that shows work items. I have several pages that is named after different tracks (see in left corner). the gallery for each track is adjused so it shows only workitems from the specifik track. 

I have also a page called Cross functional and I want that page to show everything except content from the other pages. My datasource is a Excel sheet published in OneDrive. 

fiirst page.jpgexcept.jpg 

I can also mention that Trackname is a column in my Excel sheet

excel trackname.jpg

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Show everything except...

First I think you want OR not And for those because with And it will look for all of those at the same time (which will not happen). 

 

Also, you may have to refer them each time and not just list them out. Try something more like this:

 

If(
!IsEmpty(InitialCollection),
InitialCollection,
Filter(Tickets, Status = Dropdown1_12.Selected.Result &&

(

!("Make" in Trackname || "Deliver" in Trackname || "Finance" in Trackname || "MDM" in Trackname || "Plan" in Trackname || "Warehouse" in Trackname || "Source" in Trackname))
)

 

The || is for Or. 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Show everything except...

@Djanan 

No question was asked in your post...  What would you like to know?

Djanan
Level: Powered On

Re: Show everything except...

Dear @mdevaney 

 

My question is how I can show everything except content with the tagg: Make, Deliver, Finance, MDM, Plan, Warehouse, Source in my gallery. My code below is not working. 

 

If(
!IsEmpty(InitialCollection),
InitialCollection,
Filter(Tickets, Status = Dropdown1_12.Selected.Result && !("Make" & "Deliver" & "Finance" & "MDM" & "Plan" & "Warehouse" & "Source") in Trackname)
)

Super User
Super User

Re: Show everything except...

First I think you want OR not And for those because with And it will look for all of those at the same time (which will not happen). 

 

Also, you may have to refer them each time and not just list them out. Try something more like this:

 

If(
!IsEmpty(InitialCollection),
InitialCollection,
Filter(Tickets, Status = Dropdown1_12.Selected.Result &&

(

!("Make" in Trackname || "Deliver" in Trackname || "Finance" in Trackname || "MDM" in Trackname || "Plan" in Trackname || "Warehouse" in Trackname || "Source" in Trackname))
)

 

The || is for Or. 

View solution in original post

Djanan
Level: Powered On

Re: Show everything except...

@rebeccas thank you very much it worked

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,996)