Collection not updating null values

[AShep]

Hi All,

I have a collection which is not updating null values.

It seems this is a known limitation of powerapps and I have gone through earlier posts where a workaround to set the null field to "" in the collection before patching is suggested.

I have 3 values which have null values in collection. Out of these only one value is showing the updated value (after I set it to null), the other two merely get set to null in the first iteration and then get updated with  new non null value after I re-run the code.

The code that has been written is exactly the same, which makes me wonder what is the issue here.

The piece of code is:

UpdateIf(
WellDataCollection,
WellID = WellSearchResultsGallery.Selected.WellID && IsBlank(ContractorName),
{ContractorName: " "}
);
UpdateIf(
WellDataCollection,
WellID = WellSearchResultsGallery.Selected.WellID && IsBlank(DirectionalCompany),
{DirectionalCompany: " "}
);
UpdateIf(
WellDataCollection,
WellID = WellSearchResultsGallery.Selected.WellID && IsBlank(RigName),
{RigName: " "}
);

Update(
WellDataCollection,
First(
Filter(
WellDataCollection,
WellID = WellSearchResultsGallery.Selected.WellID
)
),
{
WellID: WellSearchResultsGallery.Selected.WellID,
APINumber: APIDCValue.Text,
CommonWellName: Trim(Upper(CWNDCValue.Text)),
OfficialWellName: Trim(Upper(CWNDCValue.Text)),
Operator: OperatorComboBox.Selected.Result,
OperatorId: GUID(
LookUp(
WellDataCollection,
Operator = OperatorComboBox.Selected.Result,
OperatorId
)
),
ContractorName: ContractorComboBox.Selected.Result,
RigConfigID: GUID(
LookUp(
Filter(
WellDataCollection,
ContractorName = ContractorComboBox.Selected.Result
),
RigName = RigComboBox.Selected.Result,
RigConfigID
)
),
RigName: RigComboBox.Selected.Result,
DirectionalCompany: DirCompComboBox.Selected.DirectionalCompanyName,
DirectionalCompanyId: Value(DirCompComboBox.Selected.DirectionalCompanyID),
SpudDate: DateAdd(
DateValue1.SelectedDate,
-TimeZoneOffset(DateValue1.SelectedDate),
Minutes
),
LastUpdatedBy: User().FullName,
LastUpdated: Now(),
SystemListCodeValuesID_DIRTYP: LookUp(
WellProfileCollection,
ListDesc = WellProfileDropdown.Selected.Result,
SystemListCodeValueId
),
NewSpudDate: DateValue1.SelectedDate
}
);
SaveData(
WellDataCollection,
"WellDataCache"
);

Any idea why this is happening? All of them - Directional Company, Contractor, Rig are combo boxes with value listing in them.

Thanks,

AShep

[v-xida-msft · Accepted solution]

Hi @AShep ,

Do you want to update the column with Nulll value within your Collection?

Actually, it is an known issue within PowerApps, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Patch-Problem-Existing-data-updated-new...

Based on the formula that you mentioned, I think there is something wrong with it. I think it is not necessary to set the null field to "" in the collection before patching is suggested.

As an fixed solution, I think the UpdateIf function could achieve your needs. Please consider modify your formula as below:

UpdateIf(                   /* <-- Modify your formula here */
        WellDataCollection,
        WellID = WellSearchResultsGallery.Selected.WellID,
       {
       WellID: WellSearchResultsGallery.Selected.WellID,
       APINumber: APIDCValue.Text,
       CommonWellName: Trim(Upper(CWNDCValue.Text)),
       OfficialWellName: Trim(Upper(CWNDCValue.Text)),
       Operator: OperatorComboBox.Selected.Result,
       OperatorId: GUID(LookUp(WellDataCollection,Operator = OperatorComboBox.Selected.Result,OperatorId)),
       ContractorName: ContractorComboBox.Selected.Result,
       RigConfigID: GUID(LookUp(Filter(WellDataCollection,ContractorName = ContractorComboBox.Selected.Result), RigName = RigComboBox.Selected.Result, RigConfigID)),
       RigName: RigComboBox.Selected.Result,
       DirectionalCompany: DirCompComboBox.Selected.DirectionalCompanyName,
       DirectionalCompanyId: Value(DirCompComboBox.Selected.DirectionalCompanyID),
       SpudDate: DateAdd(DateValue1.SelectedDate,-TimeZoneOffset(DateValue1.SelectedDate),Minutes),
       LastUpdatedBy: User().FullName,
       LastUpdated: Now(),
       SystemListCodeValuesID_DIRTYP: LookUp(WellProfileCollection,ListDesc = WellProfileDropdown.Selected.Result,SystemListCodeValueId),
       NewSpudDate: DateValue1.SelectedDate
      }
);
SaveData(WellDataCollection, "WellDataCache")

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

[AShep]

Hi v-xida-msft,

This worked! Thanks so much!

Instead of UpdateIf, I had Patch statement in my original code. Then after reading on forums, I realized that Patch does not update null values and needs to be initialized with "".

It never occured to me that UpdateIf would solve the issue.

Thanks

--AShep