Hello,
I have an issue that seems like it should be rather common to fix. I am using SharePoint as my data source. The scenario is, basically when a person no longer has an assignment, they need to be removed and that should update in SharePoint.
My issue is that the user can be blanked out in the default combo box control in PowerApps but when the record updates the change to a null value does not propagate back to SharePoint.
To get around this issue I have tried many things and I will describe the one that seems like it should by all means work.
1. I have created a Blank Person record variable in my PowerApp at the initial app level
Set(BlankPerson,{ Claims:Blank(),
DisplayName:Blank(),
Email:Blank(),
Department:Blank(),
Picture:Blank(),
JobTitle:Blank()});
2. I then check for a change to blank in the default combo box control in the On Change property.
If(IsBlank(ProjectManagerDataCardValue.Selected.DisplayName),
UpdateIf(MyList, ID = varRecord.ID,
{'Project Manager': BlankPerson}
);
I run the code and X out the assigned Project Manager. The code runs successfully, which I know because I set a variable in the next line of code in the block and I display that value which does change. So I know it runs well. There are no errors registered.
I refresh my page and the old Project Manager value is still showing. When I check SharePoint, no change has been applied.
Am I approaching this incorrectly? Or is this a known bug? Or does anyone know how to make this change reflect in SharePoint after being removed in PowerApps?
