Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : 08w80LMBJwVI7gjMpZNeAE
Power Platform Community / Forums / Power Apps - Building Power Apps / How to solve - Error: ...
Power Apps - Building Power Apps
Answered

How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

Like (0) ShareShare
ReportReport
Posted on 23 Mar 2023 12:59:35 by muzamil-baxture 174

Hello Experts, 

I have a gallery named Gallery_jobReports, I have placed an Icon beside every name of the column to sort each column. Also I have five checkboxes to filter my data. To filter I have placed five text labels and set its text property to : If(Checkbox4_5.Value = true, Checkbox4_5.Text) this way I get the value of check box into the label which is not visible, so when the user checks any box the data gets filtered. The Items property I have set as below

 

Switch(
 locSortColumn,
 "Title",
 Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label28.Text
 ) || StartsWith(
 Brand,
 Label29.Text
 ) || StartsWith(
 Brand,
 Label30.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 )
 )
 ),
 Title,
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
 ),
 "Project",
 Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label28.Text
 ) || StartsWith(
 Brand,
 Label29.Text
 ) || StartsWith(
 Brand,
 Label30.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 ) || StartsWith(
 Brand,
 Label32.Text
 )
 )
 ),
 Project,
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
 ),
 "Episode",
 Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label28.Text
 ) || StartsWith(
 Brand,
 Label29.Text
 ) || StartsWith(
 Brand,
 Label30.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 ) || StartsWith(
 Brand,
 Label32.Text
 )
 )
 ),
 Episode,
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
 ),
 "Photographer",
 Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label28.Text
 ) || StartsWith(
 Brand,
 Label29.Text
 ) || StartsWith(
 Brand,
 Label30.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 ) || StartsWith(
 Brand,
 Label32.Text
 )
 )
 ),
 Photographer,
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
 ),
 "Shoot Date",
 Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label20.Text
 ) || StartsWith(
 Brand,
 Label21.Text
 ) || StartsWith(
 Brand,
 Label22.Text
 ) || StartsWith(
 Brand,
 Label23.Text
 ) || StartsWith(
 Brand,
 Label24.Text
 )
 )
 ),
 'Shoot Date',
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
 ),
 "Brand",
 Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label28.Text
 ) || StartsWith(
 Brand,
 Label29.Text
 ) || StartsWith(
 Brand,
 Label30.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 ) || StartsWith(
 Brand,
 Label32.Text
 )
 )
 ),
 Brand,
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
 ),
 'SU_Job_List'
)

 

 The error I am getting is - 

Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.  However when I use the same formula in my other app it works fine. Please help me in how to deal with this issue.

Thanks.

Below are the screenshots of my screen for your reference.

 

pw5.PNG

Categories:
General Questions
  • WarrenBelz Profile Picture
    WarrenBelz 148,833 Most Valuable Professional on 14 Jun 2023 at 08:46:17
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    @walaa96 ,

    You need to check all of the things I mentioned

  • walaa96 Profile Picture
    walaa96 6 on 14 Jun 2023 at 07:51:32
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    @WarrenBelz , @muzamil-baxture

    Thanks for your quick support, Num_of_Inv is a label inside the gallery that I want to filter by the checkbox, if the user clicks it the gallery will return only the values that >0, and the CheckboxNum is outside the gallery. I'm a little bit confused. 

  • muzamil-baxture Profile Picture
    muzamil-baxture 174 on 14 Jun 2023 at 07:33:18
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    @WarrenBelz , @walaa96 

    I committed the mistake that I placed one of the controls inside a gallery, that's what gave me this error. Please check all your controls are outside the gallery. That would solve your issue.

     

  • WarrenBelz Profile Picture
    WarrenBelz 148,833 Most Valuable Professional on 14 Jun 2023 at 07:14:38
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    @walaa96 ,

    The first place to look if the Default of any of these controls refers to the gallery and also confirm that none are in the gallery

    • OU_Login
    • cbCustomers
    • CheckboxNum
    • Num_of_Inv
  • walaa96 Profile Picture
    walaa96 6 on 14 Jun 2023 at 07:02:45
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    I wrote the formula on the gallery items property:

    Filter(
    Customers_Data_Automate,
    (OU_Name = OU_Login.Selected.Result)
    && (Customer_Name = cbCustomers.Selected.Customer_Name || cbCustomers.Selected.Customer_Name = Blank())
    && If(CheckboxNum.Value, Value(Num_of_Inv.Text)>0, true))

  • walaa96 Profile Picture
    walaa96 6 on 14 Jun 2023 at 06:49:24
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    I have the same scenario with the same error, I tried to rename the checkbox or check the formula, it showed like this I didn't get it: 

    walaa96_0-1686725287439.png

     

    Appreciate your support. 

    Many thanks, 

  • muzamil-baxture Profile Picture
    muzamil-baxture 174 on 24 Mar 2023 at 12:12:55
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    @BCBuizer , I tried your given formula and its working perfectly fine. 

    I also tried @WarrenBelz , solution its also working fine but I have delegation issue.

    I really appreciate for your reply's @Drrickryp.

  • Drrickryp Profile Picture
    Drrickryp Super User 2024 Season 1 on 23 Mar 2023 at 20:57:14
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    @muzamil-baxture 

    @RezaDorrani has a very nice video showing how sort and filter columns like you have in your screenshot.  https://www.youtube.com/watch?v=6KlI1iZ_KD0 

  • WarrenBelz Profile Picture
    WarrenBelz 148,833 Most Valuable Professional on 23 Mar 2023 at 20:56:53
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    HI @muzamil-baxture ,

    As per the PM you sent, I agree with @BCBuizer that there is nothing there that should cause a circular reference unless one of your labels or check boxes, or sort order Variable refers to the gallery or something inside it. I have broken it down bit more and suggest you get rid of those calculated labels as they are prone to calculation order/priority issues, rename your check boxes as below and try this

    SortByColumns(
 Filter(
 'SU_Job_List',
 (
 !ckABC.Value ||
 Brand = "ABC Entertainment"
 ) &&
 (
 !ckHulu.Value ||
 Brand = "Hulu"
 ) &&
 (
 !ckEpisode.Value ||
 Brand = "Episode"
 ) &&
 (
 !ckPhotographer.Value ||
 Brand = "Photographer"
 ) &&
 (
 !ckShootDate.Value ||
 Brand = "Shoot Date"
 )
 ),
 locSortColumn,
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
)

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • Verified answer
    BCBuizer Profile Picture
    BCBuizer 22,262 Super User 2025 Season 2 on 23 Mar 2023 at 18:02:38
    Re: How to solve - Error: This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

    Hi @muzamil-baxture ,

     

    After simplifying your formula a bit, there's nothing in there that makes a circular reference stand out:

     

    Sort(
 If(
 IsBlank(Label28.Text) && IsBlank(Label29.Text) && IsBlank(Label30.Text) && IsBlank(Label31.Text) && IsBlank(Label32.Text),'SU_Job_List',
 Filter(
 'SU_Job_List',
 StartsWith(
 Brand,
 Label28.Text
 ) || StartsWith(
 Brand,
 Label29.Text
 ) || StartsWith(
 Brand,
 Label30.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 ) || StartsWith(
 Brand,
 Label31.Text
 )
 )
 ),
 Switch(
		locSortColumn,
		"Title", Title,
		"Project", Project,
		"Episode", Episode,
		"Photographer", Photographer
		"Shoot Date", 'Shoot Date',
		"Brand", Brand
	),		
 If(
 locSortAscending,
 SortOrder.Ascending,
 SortOrder.Descending
 )
)

     

    This makes me think this formula is perhaps not the one causing the circular reference.

     

    Can you check the error details to see what control / property is causing the issue: 

    BCBuizer_0-1679594505688.png

     

    BCBuizer_1-1679594545329.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans