Hi PowerApps Community,
I'm encountering a perplexing issue with the 'simple_paid' column in my Power App, and I could really use your expertise to help me understand and resolve it.
Problem Description: In my Power App, I have a table with line items, and each item has a corresponding 'simple_paid' column. Strangely, I noticed that for four specific line items, the 'simple_paid' column values appear to be blank initially.
However, things get even more puzzling when I inspect the table's form and include the 'simple_paid' column in the layout - lo and behold, there's a value present for those supposedly blank line items.
To make matters more confusing, when I try to exit the form without making any visible changes, the app prompts me to save changes as if I had modified something. I'm positive that I haven't made any edits, but it seems like the 'simple_paid' column's value is in a state of uncertainty until I access the record's details. Upon clicking 'save changes', the record refreshes and finally displays the 'simple_paid' value that was already there but wasn't visible before. I had to do this for every line item to get the right values:
This is a problem for us because there is a separate field in a different table called 'Total Payments' that we use via rollup to determine whether an invoice is paid or not:
Now, I'm reaching out to the PowerApps community for your valuable insights and suggestions. Has anyone experienced similar behavior with columns seeming to be blank until a record is accessed? What could be causing this "dirty" record behavior, prompting unnecessary save changes? Are there any other factors I might have overlooked?
I have one more invoice with line items that are experiencing the same behavior, I'm holding off on making changes to these in case anyone has some ideas I can use to test.
