cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iwonder
Post Prodigy
Post Prodigy

SharePoint Yes/No Field not working the same for all screens

Thank you for taking the time to read my question.

 

I have 4 SharePoint lists. Each list has the last column as "RecComplete". RecComplete is a Yes/No field in all for Lists.

 

iwonder_0-1633553493550.png

 

I have 4 screens in my app, each with a Gallery. The Gallery should only show records from the related SharePoint list where RecComplete is No.

 

This is an example of one of the screens Gallery Items formula:

Filter(BaggingRecord,Title = SelectedFacility.Text,RecComplete=0)

 

In this case, when I add the ",RecComplete=0" part, nothing is returned. On 2 of the screens this is the case, but on the other two, the above formula works as expected. The RecComplete field in each SharePoint list is created exactly the same.

 

I would really like to get all 4 working correctly. Any help would be greatly appreciated.

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @iwonder ,

Try

Filter(
   BaggingRecord,
   Title = SelectedFacility.Text && 
   !RecComplete
)

or as Boolean fields are not Delegable in a Filter with other items

With(
   {
      wList:
      Filter(
         BaggingRecord,
         Title = SelectedFacility.Text
      )
   },
   Filter(
      wList,
      !RecComplete
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

2 REPLIES 2
WarrenBelz
Super User
Super User

Hi @iwonder ,

Try

Filter(
   BaggingRecord,
   Title = SelectedFacility.Text && 
   !RecComplete
)

or as Boolean fields are not Delegable in a Filter with other items

With(
   {
      wList:
      Filter(
         BaggingRecord,
         Title = SelectedFacility.Text
      )
   },
   Filter(
      wList,
      !RecComplete
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Hi @WarrenBelz 

 

Filter( BaggingRecord, Title = SelectedFacility.Text && !RecComplete ) 

 

Worked!!

 

So half of my screens use my original formula and the others use yours... I tried yours on the ones where my formula works and yours failed.... very strange....

 

Thanks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,270)