cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JPCuevas
New Member

UpdateIf not updating Microsoft Dataverse table

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.

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,962)