Hello,
I am working on an application that needs to perform a massive update on a defined set of records. This records are from a table found in the dataverse.
I am trying to, that with a button the records on dataverse could get updated. Here is my formula:
Set(
RejectApprove,
Get_Status_Action.SelectedText.Value
);
Set(
Get_ED,
Get_Locations.SelectedText.'Location Number'
);
Refresh(MyTable);
UpdateIf(
MyTable,
IsEmpty('Approval Review - Approval Status') && Executive_LookUp = Get_Locations.SelectedText.'Location Number',
{
'Rejected Reason': Get_Rejected_Reason.Text,
'Approval Review - Approval Status': "Approved",
'Approval Review - Date Updated': Today(),
'Approval Review - Update By': User().Email
}
);
Set(
Warning_Box,
false
);
Reset(Get_Status_Action);
Refresh(MyTable);
When a use the same filters on a list, the list displays what I need to update. But when the filter is with the updateif it does not update the data, the action never occur and I don't get any error message.
Please if somebody have an idea of why this happen, I will highly appreciate your help.