Sharepoint Data missing

(1) Share

Report

Posted on by Seth18

146

Hi everyone,

I’m currently working with two SharePoint lists:

SharePoint 1 stores users' basic information along with the total amount they’ve claimed.

SharePoint 2 stores detailed invoice records. To ensure each invoice is linked to the correct user, I’ve added a Request ID column that matches the ID from SharePoint 1. This helps prevent invoices from being routed to the wrong user when multiple claims are submitted.

In Power Apps, I’ve created a form screen for users to submit their invoice details. Once they complete the form, they click Save, which triggers a SubmitForm function to send the data to SharePoint.

For the Total Amount field, I use the following formula in the Default property of a text input:

If(
    IsEmpty(colInvoices),
    "$0.00",
    Text(
        Sum(
            colInvoices,
            Value(Substitute(Amount, "$", ""))
        ),
        "[$-en-GB]$#,###.00"
    )
)

The calculation in Power Apps is accurate. However, the issue arises when the data is submitted:

Sometimes the Total Amount field in SharePoint is blank.

Other times, it only includes part of the total (e.g., only 3 out of 5 invoices).

Occasionally, it submits correctly.

What I’ve Tried and Observed:

The formula works perfectly in the app interface.

The inconsistency seems to occur during or after submission.

What I Need Help With:

How can I ensure that the Total Amount is always submitted correctly and completely to SharePoint?

Any insights or suggestions would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Seth18

You say that it is correct sometimes, wrong other times (in various ways).

1. How does the collection get populated? my guess is this is the issue. If you are saying the value is wrong, then the question is

a) On the screen does it look right?

b) If you go to the Update property of that Label or Text or whatever it is, what is the Update expression?

If the data is in the label or text correctly, then it wouldn't make sense for it to be wrong, unless the Update property is wrong.

I promise, if the value in the box says 500, it will save 500, so something else (possibly the update), or some Event/way you are capturing the values in the collection is wrong.

If a person saves, and it saves wrong, then they click save again, does it save wrong still? Same number? and yet the label (Total) is ok? where do you see that on the screen?

Was this reply helpful? Yes No
Seth18 146 on at

Like (0)

Report

Hi Michael E. Gernaey !

Thank you for your response!

To answer to your question:

a. The onscreen showing is 100% right and accurate as it sum all the amount and showing it to whatever it shown in the gallery.

b. As i am using text input there's unfortunately no update property code on this that why i am only using the code above in the default.

My suspicious here is when the data submitting to the Sharepoint somehow it not updated or submitting empty when the onscreen of the PowerApp is correct this confuse a lots of users and also me as well as when i test myself everything work complete fine!

Was this reply helpful? Yes No
Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Seth18

Every control should have an Update, otherwise the form has no way to tell the back end how to update it, unless the form is in New Mode, but either way :-) (I forgot to ask the form mode)

If it's just some random control it shouldn't update anything as it means nothing to the form, its just some unbound control.

The control itself of course has to be bound, so unless during the physical submit, the value is changing, yeah it makes no sense.

Can you try something else...

I mean this with no disrespect or assumption, but if you know how to write it as a Patch instead. Can you add a button outside of the form, do a Patch statement instead and see if its correct all the time.

Also, is there anything else in your submit button, other than the submit because... only something triggered by an OnChange (if it has code etc) or a value being wiped prematurely would change the total. It makes no sense that there is nothing changing it but its wrong.

I would try with the patch, if it works all the time, then you know you have something IN the form or the form submit button that is doing it.

Was this reply helpful? Yes No
Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

hi@Seth18

Did you resolve this issue? If so can you share what you did?

Was this reply helpful? Yes No