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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Circular reference Pro...
Power Apps
Answered

Circular reference Problem!

(0) ShareShare
ReportReport
Posted on by 137

In my app there are cells for Months (which correspond with month columns in a sharepoint list), these month cells are text fields which form a grid.


I'm creating an auto-populate feature that uses an invisible table with dates and some basic math (total amounts, divided by months equals monthly amount).

I got this to work successfully in my test environment, however - when working with the live app, any time I try to have one of the visible month cells reference one of the hidden math cells (either total, monthly count, or monthly amount) it tells me it creates a 'circular reference' between properties - but it doesn't, I don't think.


The monthly cells do total up in another area, but that field isn't being referenced in any of the equations - has anyone else had trouble with non-existent circular references?

Categories:
I have the same question (0)
  • mmollet Profile Picture
    3,187 on at

    Make sure you use Self.Value instead of ControlName.Value when referencing the same control you are typing code in for. This can cause what you are talking about. So for example:

    If(Label1.Text = "Monday", **do something**)

    If(Self.Text = "Monday", **do something**)

  • Verified answer
    JeffT2022 Profile Picture
    137 on at

    I was able to resolve my issue, for anyone reading this later....

     

    my problem was the hidden cells I was trying to reference were not actually "in" the edit form, rather floating on top (invisible) - I remade the table in a custom card within the edit form and it works fine.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 547

#2
WarrenBelz Profile Picture

WarrenBelz 444 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 322

Last 30 days Overall leaderboard