Update project

[Ronald123]

Hello,

I have the following question.

I have users who have the ability to enter data via a Power App.
I need for every project one row.

The rule can be defined as follow : Every new input overwrites the old value. Only overwrite if the value isn't blank.

Expected output from the file: 

Project	Budget	Level
100	100	1
300	300	1

Thanks in advance,

Ronald

Link : https://1drv.ms/u/s!An5X7wdH9O9ejlFXihAv_VuMcUBX

[v-yingjl · Accepted solution]

Hi @Ronald123 ,

In Power Query, seems that there is not a 'overwrite' definition but  'Replace values' or 'Refresh', not certain what did you want based on your description.

If you want to replace values, please refer this article: Override-values-with-formula-using-power-query 

Compared with the expected output and the sample file, 'overwrite if the value isn't blank.' seems not clear that for which column value is not blank or all column values are not blnak to replace values.

Best Regards,
Community Support Team _ Yingjie Li