cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filtering a sharepoint in a gallery based on a value in another sharepoint

Hello there!

Like the title is saying, I am trying to filter a sharepoint list in a gallery based on a value in another sharepoint. 

I have a label which is named Label12.Text, which is an unique number like:       31-D-01-B V1.1

I am checking if that number is already existing in the Sharepoint named OpleverApp with this formula;

 

Filter(
    'D-Nummers-OpleverApp';
    Gallery2_1.Selected.Order0 = Order && 
    Left(Gallery2_1.Selected.Deelordernummer;2) = Deelorder && 
    Verdieping = Dropdown1.SelectedText.Result &&
    
    Not(Label12.Text in OpleverApp.UniekNummer)
)

 


The top part of the filter works fine, we are looking at the Not() formula here. I am checking if the information from Label12.Text is inside of the column UniekNummer in the SharePoint OpleverApp. It tells me this; 

 

This rule creates a circular reference between the properties, which is not allowed. A property must not refer to itself or other properties that are affected by the property's value.

 

 How can I get this formula to work?

2 REPLIES 2
Drrickryp
Super User
Super User

@Anonymous 

You will have to address the column name describes the value that populates the Lebel12.Text in the xxx part of this formula.   wUnique will be true if the number is not found in the OpleverApp table.  

 

With(
      {wUnique: IsBlank(
                        Lookup(
                               OpleverApp; UniekNummer=ThisItem.xxx
                         )
                 )
       },

   Filter(
          'D-Nummers-OpleverApp'; Gallery2_1.Selected.Order0 = Order &&
           Left(
                 Gallery2_1.Selected.Deelordernummer; 2
            ) = Deelorder &&
            Verdieping = Dropdown1.SelectedText.Result && wUnique
   )
    
)

 

If Lebel12.Text is based on a field,  UniekNummer, then the Lookup will be

Lookup(OploeverApp; UniekNummer=ThisItem.UniekNummer)

 

Anonymous
Not applicable

Thank you for your answer!

I've tried it out and I am unable to replace xxx with UniekNummer (which is indeed label12.text)

It says the name can not be found. But when I just do ThisItem. it doesn't suggest me anything. When I put label12.text there, I get the same error as before

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,267)