Unanswered

Data not updating in sharepoint list

Like (0) Share

Report

Posted on 24 Aug 2023 16:37:29 by Vaibhav_k

Dear Community, I have a field called Total in PowerApps list customized form whose Default Value "$" & Text(Value(Sum(DataCardValue21.Text,DataCardValue22.Text,DataCardValue5.Text),"en-US"),"###,###,##0.00", "en-US") it shows correctly in powerapp but doesnt show or update in sharepoint. Data type is number.

I have the same question (0)

All responses (7)

Answers (0)

LaurensM 12,510 Moderator on 02 Sep 2023 at 10:05:22

Like (0)

Report
Re: Data not updating in sharepoint list

@Vaibhav_k,

To help us further troubleshoot the issue:

Did you make any changes to the 'DataField' property of that DataCard?

When does the blank column value occur in that list (during creation, updating, both?)

Did you make any changes to that DataCard or DataCardValue besides using the Sum function?

It may be beneficial to remove that field (DataCard) from your Form and add it again via the right property panel ('Edit Fields'). Try to submit it by filling out a number manually and not yet adding the Sum function, after which you can add my code to the DataCard Update property and retry.

I hope this helps!

Was this reply helpful? Yes No
Vaibhav_k on 02 Sep 2023 at 00:15:16

Like (0)

Report

Re: Data not updating in sharepoint list

@LaurensM ,correct I ambpatching via submitform.

Was this reply helpful? Yes No
LaurensM 12,510 Moderator on 01 Sep 2023 at 18:33:06

Like (0)

Report

Re: Data not updating in sharepoint list

Hi @Vaibhav_k,

When using the supplied code in the Update property of the Total DataCard (container), the number field within SharePoint should contain the correct sum of values. The code expects that all DataCardValue.Text values only contain numbers and no currency symbols or other non-numeric characters.

I unfortunately am unable to recreate the update issue on my end. How are you patching the code, is this via a SubmitForm function?

Was this reply helpful? Yes No
Vaibhav_k on 01 Sep 2023 at 15:50:00

Like (0)

Report

Re: Data not updating in sharepoint list

@LaurensM , Can you please verify the total formula once? The total isn't updating while on the form as well.

Was this reply helpful? Yes No
Vaibhav_k on 25 Aug 2023 at 07:42:07

Like (0)

Report

Re: Data not updating in sharepoint list

@LaurensM , Thanks. The earlier update had similar formula but for some items it shows updated while for others not updated. Not sure how it is inconsistent. The formula you provided has no change

Was this reply helpful? Yes No
Vaibhav_k on 25 Aug 2023 at 07:41:47

Like (0)

Report

Re: Data not updating in sharepoint list

@LaurensM , Thanks. The earlier update had similar formula but for some items it shows updated while for others not updated. Not sure how it is inconsistent. The formula you provided has no change

Was this reply helpful? Yes No
LaurensM 12,510 Moderator on 24 Aug 2023 at 16:47:53

Like (0)

Report
Re: Data not updating in sharepoint list

Hi @Vaibhav_k,

I expect it to be due to the DataCard displaying a Text value and trying to update a Number column. Could you set the Update property of that DataCard (the container) to:

Value(Sum(DataCardValue21.Text,DataCardValue22.Text,DataCardValue5.Text),"en-US")

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No