cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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)
)

Highlighted
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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,686)