Answered

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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
kintomey 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,929 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
WarrenBelz 155,929 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
kintomey 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thank you for your reply.

Yes I am able to solved this issue with your code.
Now its working fine.

Was this reply helpful? Yes No
WarrenBelz 155,929 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ronak83garg 117 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @CarlosFigueira, it worked for me

Was this reply helpful? Yes No