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
Solved! Go to Solution.
Hi @Anonymous ,
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:
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,
Hi @Anonymous ,
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:
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,
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
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
183 | |
71 | |
37 | |
33 |
User | Count |
---|---|
344 | |
274 | |
118 | |
76 | |
58 |