Answered

UpdateIf blank colums

(0) Share

Report

Posted on by MicheleGo

Hello to all the PowerApps community,

I'm facing a problem with the UpdateIf function. According to Microsoft Guidelines I'm trying to update a single Record in a data verse Table called Azienda_Anagrafico_listini_righe.

The table initially looks like this:

Now I want to update just only the price Prezzo_netto for the code ABC, and I have added in button the following code:

UpdateIf(Azienda_Anagrafico_listini_righeP, ThisRecord.Codice="ABC",
{
Prezzo_netto: Prezzo_netto*0.1
});
Refresh( Azienda_Anagrafico_listiniP );

I expect that only "Prezzo_netto" will be updated for the record ABC.

But after clicking the button I got the following empty columns in the Dataverse Table:

Prezzo_netto has successfully updated, but Codice and Descrizione have been deleted.

Any Idea about this flaw ?

Thanks to all.

Michele

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Sort by

timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MicheleGo

There shouldn't be any need to reference ThisRecord. What happens when you try this?

UpdateIf(Azienda_Anagrafico_listini_righeP, Codice="ABC", { Prezzo_netto: Prezzo_netto*0.1 } );

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

ignore this - deleted my comment - only Update should replace whole records!

Was this reply helpful? Yes No
MicheleGo 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi timl thanks for reply, but I got the same result

Was this reply helpful? Yes No
MicheleGo 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sancho,
As suggested by you I have tried with Patch with the following code:

Patch(Azienda_Anagrafico_listini_righeP,LookUp(Azienda_Anagrafico_listini_righeP,Codice="ABC"),
{
Prezzo_netto: 10
}
);
Refresh( Azienda_Anagrafico_listiniP );

and also with that I got the same result, it is quite weird.

Michele

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MicheleGo

I attempted to recreate this problem but wasn't able to do so.

What I would say is that what you're seeing here is unexpected behaviour.

Is Azienda_Anagrafico_listini_righe a table that you created yourself?

Could there be any other Flows or Dataverse plugins that could be modifying the data on an Update?

Was this reply helpful? Yes No
MicheleGo 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi timl
Yes Azienda_Anagrafico_listini_righe it's a Dataverse table I have created by myself, and there aren't any plugins that could modify the data un an Update event.
It might be that there is something in the Dataverse Tables that should be set, to avoid putting null values automatically, I really don't know if this is possible.

Was this reply helpful? Yes No
Verified answer

MicheleGo 38 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello Guys,
I have found the problem.
The fact was that the table "Azienda_Anagrafico_listini_righeP" was created as "Elastic table". Creating again the same table as "Standard" magically I was able to update a single column without loosing the values in the other columns.
I don't know if this it's a Microsoft bug on "Elastic tables" or it might be correct for any mysterious reason.

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@MicheleGo Thanks for reporting the cause of this - it's very useful to know.

As this is a preview feature, it's hard to know what the intended behaviour is. However, I would be inclined to label this as bug, given how it differs from the use of Patch/UpdateIf with other data sources.

Was this reply helpful? Yes No
MicheleGo 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok added the Tag "Bug" for all those people who need this information. Have a great day.

Was this reply helpful? Yes No