Answered

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

(0) Share

Report

Posted on by HW1

Hi,

I am receiving the error "This rule creates a circular reference between properties which is not allowed" on a rather simple configuration and I don't understand why.

I have a Sharepoint list that documents our corporate certificates and I am building a Power App so employees can provide feedback if they need the IT department to renew a certificate before expiration. Please see attached screenshot.

The left part highlighted in green is a form connected to the Sharepoint list and on the right side I have a dropdown field so users can choose their action.

If the certificate was issued by the company the dropdown list should show 3 options

1) Renew

2) Deprecate

3) Only update information without changing Renew/Deprecate status

If the certificate was not issued by the company then only 2 options are shown

1) Deprecate

2) Only update information without changing the status

The dropdown list is using following logic in the "Items" field:

If(DataCardValue9.Selected.Value="Company", ["I want this certificate to be renewed","I want to this certificate to be deprecated", "I only want to update the information above without changing the status"], ["I want to this certificate to be deprecated", "I only want to update the information above without changing the status"])

This is working fine but I only want to update the field "Expiration Action" if renew or deprecate is selected and keep it as is if the user chooses to simply update the other information.

However when adding following logic to the Update field on "Expiration Action" I am receiving the error.

Switch(Dropdown1.SelectedText.Value,"I want this certifiate to be renewed","Renew","I want to this certificate to be deprecated","Deprecate")

I clearly have an dependency from A to B to C but I can't figure out how this would result in a circular reference.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HW1 ,

Do you mean that you have this error "This rule creates a circular reference between properties which is not allowed" ?

Do you mean that:

A drop down(DataCardValue9, for issued by column)

B drop down's Items(Dropdown1):If(DataCardValue9.Selected.Value="Company", ["I want this certificate to be renewed","I want to this certificate to be deprecated", "I only want to update the information above without changing the status"], ["I want to this certificate to be deprecated", "I only want to update the information above without changing the status"])

C drop down daracrd's Update:Switch(Dropdown1.SelectedText.Value,"I want this certifiate to be renewed","Renew","I want to this certificate to be deprecated","Deprecate")

A->B->C?

Could you tell me

1)'issued by' column data type, 'issued by' datacard Update?

2)'Expiration Action' column data type, 'Expiration Action' drop down's Items?

Based on the provided information, I haven't found any problem. So I need more details.

Best regards,

Was this reply helpful? Yes No
HW1 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Correct, the error is "This rule creates a circular reference between properties which is not allowed".

I'll try to put this in more and clearer details:

A = "Issued By" field (Issued By_DataCard1)
Sharepoint Type: "Choice" with possible values "Company" and "Other"
Power App Type: Combo Box
Update: DataCardValue9.Selected

B = "Choose task you like to perform" (Dropdown1)
Power App Type: Dropdown1
Update: If(DataCardValue9.Selected.Value="Company", ["I want this certificate to be renewed","I want to this certificate to be deprecated", "I only want to update the information above without changing the status"], ["I want to this certificate to be deprecated", "I only want to update the information above without changing the status"])

C = "Expiration Action"
Sharepoint Type: "Choice" with possible values "Renew" and "Deprecate"
Power App Type: Combo Box
Update: Switch(Dropdown1.SelectedText.Value,"I want this certificate to be renewed",ThisItem.'Expiration Action',"I want to this certificate to be deprecated",ThisItem.'Expiration Action')
Note: In the original post I changed the update value to "Renew" and "Deprecate" for easier understanding. In reality it requires a combobox object like ThisItem.'Expiration Action'. However I've also run a test using a "Text Input" field and it results in the same error.

So according to my understanding the dependencies are "C depends on B and B depends on A" (and there is no dependency between A and C). See updated image attached.

Thank you for your help.

Was this reply helpful? Yes No
Verified answer

HW1 24 on at

Like
a
(0)

Report
Copy link

Link copied!

I have not found a solution to this problem. I assume it is not possible by design.
But by changing the logic of the app I found an alternative solution.

Was this reply helpful? Yes No