web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Circular reference bet...
Power Apps
Unanswered

Circular reference between properties on unconnected fields

(0) ShareShare
ReportReport
Posted on by 4

Hi,

 

Hope someone can shed some light on this.  I'm currently building forms for a SharePoint list called Feedback.  In the Feedback create form, there is a choice field that allows the user to select a category (field value is called CategoryValue).  Once that category is selected, a ComboBox(FAQs) displays a filtered list of FAQs from a second SharePoint list where the category in CategoryValue matches the Category value in the second List called KnowledgeBase.  This works perfectly!  I used a ComboBox because I could not get this filtered list to work on a dropdown list control.

 

The problem is that the user needs to select CategoryValue2, and then something from the FAQs combobox if it applies.  This value should then be written into the text field called "Form_Detail" which has no dependencies.  If no value is selected in the FAQ ComboBox, they can freeform the field "FAQ_Detail".   When I, however, set the value of  to Form_Detail to FAQ.selected.Detail, I am getting a circular reference error.  These three controls have no dependencies or relationships to any other controls or fields in the form and it's driving me mad.  

 

The only custom properties for the three controls are:

CategoryValue - items = Choices([@'Feedback'].Category)

FAQ -                 items = Filter(KnowledgeBase, Category.Value = CategoryValue_2.Selected.Value)

FAQ_Detail -      items = FAQ.selected.Detail

 

As soon as I remove the reference to the FAQs ComboBox Value the error goes away but it doesn't work as we need it to.

 

Help? 

 

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @CastleGarrett 

    Try changing the Choice type column to single line of text in SharePoint.  In the meantime, in PowerApps, you can control the choices offered to the User by putting them in a Dropdown control with the items property ["category1","category2","etc"].  Avoid using Lookup, Choice, yes/no and People type columns in SharePoint.  They are ok shortcuts in SharePoint but complicate things in PowerApps.  To see why, look at my blog post https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 

    IMHO, single line of text, Date/Time and Number type columns are all that are really needed to handle almost every situation in PowerApps.

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard