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

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

@TimoMigchielsen 

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)

 

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
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,059)