Update A row action from Dataverse connector missing in Power Automate flow
Update A row action from Dataverse connector was not available to an older Power Automate.The requirement was to add ability to cancel an approval task created via action ‘Create Approval’ within 30 days as Power Automate flows timeout after 30 days. I noticed the action Update a Row in Selected Environment and decided to try it instead.
Unfortunately it threw the forbidden error for no apparent reason with no obvious permissions to grant.
The error message was
Principal user (Id=0e9e3c45-96c2-ed11-83fe-6045bdcfea8c, type=8, roleCount=6, privilegeCount=1491, accessMode=‘0 Read-Write’, AADObjectId=‘78d6253a-35f4-404d-aca2-23b610c55204’, MetadataCachePrivilegesCount=5214, businessUnitId=69535865-29b0-eb11-8236-000d3a874bd8), is missing prvWritemsdyn_flow_approval privilege (Id=2fd4f0b0-ff84-4330-93fc-6bb19834ef71) on OTC=10286 for entity ‘msdyn_flow_approval’ (LocalizedName=‘Approval’). context.Caller=0e9e3c45-96c2-ed11-83fe-6045bdcfea8c. Consider adding missed privilege to one of the principal (user/team) roles.
I tried the action Update a Row (Legacy) failing to get it to work.
The action Update A row action was available in the same environment for same user in a different new flow just not the flow we were trying to add the action.
Solution: Recreate the flow from scratch
After recreating the Power Automate flow from scratch copying across all actions and adding the Update a Row action renamed to Cancel Action
Running the flow succeeded this time. For testing purposes the timeout of the delay action was set to minutes instead of 29 days.
