This rule creates circular reference between properties, which is not allowed

[chaitanyaChavan]

If(CompletedShow.Value=true, SortByColumns(Filter('[dbo].[ProjectScheduling]', Takeoff_Completed= -1, AssignedTo = User.Text, Project_Name = Body1_4.Text),"Finish_Date"),SortByColumns(Filter('[dbo].[ProjectScheduling]',Takeoff_Completed = 0, AssignedTo = User.Text, Project_Name = Body1_4.Text ),"Finish_Date")) 

When I try to filter in my app, I get the above error, I am new to powerapps, can anyone tell me where I am going wrong.

Thanks

[CarlosFigueira]

If you're using this expression in the Items property of a gallery control, and Body1_4 is the name of a control inside the gallery, then you would see this error. Basically, the value of Body1_4.Text (what that control shows) is dependent on the items that are shown by the gallery, which is dependent on the value of Body1_4.Text, which is dependent on... PowerApps detects this cycle and gives you this error.

If you want to filter the project name based on a value that the user will enter, then you need to define that control outside the gallery.

If this is not your scenario, please provide more information about where this formula is defined, and what controls it is referencing.

[kintomey]

I am also having the same issue while trying to combine two text value in one text field.

DateOnly.Text : I get the date with formula -> Text(Now(), "[$-en-US]mm/dd/yyyy") - 05/02/2020 (Today date)

Label5.Text : I get from lookup field from my table - > LookUp(CC_Packages,PackageName=DataCardValue51.Text,CutOffTime)  - 18:00:00 PM
Its working fine to display both value.

However when I tried to combine both value in one label field CutOffTime.Text=DateOnly.Text & Label5.Text I got this kind of error. "This rule creates circular reference between properties, which is not allowed"
Anyone can help on this issue. Thanks a lot.

[WarrenBelz · Accepted solution]

Hi @kintomey ,

Firstly you have posted on an old thread, so you were lucky this was found.

However you need to do this.

 LookUp(
   CC_Packages,
   PackageName=DataCardValue51.Text &&
   DateDiff(
      CutOffTime,
      Today(),
      Days
   )=0
)

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.

[WarrenBelz]

Hi @kintomey ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

[kintomey]

Hi thank you for your reply. 

Yes I am able to solved this issue with your code.

Now its working fine.

[WarrenBelz]

Thanks @kintomey 

Please mark Accept as Solution so others with the same issue can find this more readily. I also closes the item.

[Ronak83garg]

Thanks @CarlosFigueira, it worked for me