Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Change Approval tasks from Active to Inactive

(0) ShareShare
ReportReport
Posted on by 58

I want to clean up abandoned approval tasks. I have found the table 'Approvals' within the dataverse area. 

 

In my flow I have added this after an approval time out so it will change the status from Active to Inactive. 

 

I have followed these instructions but keep getting an error. Has anyone been successful? 

 

Microsoft Dataverse update row.png

 

error.png

error1.png

 

error2.png

  • karenlacey Profile Picture
    58 on at
    Re: Change Approval tasks from Active to Inactive

    Hi, by deleting the row in the Approvals table it stops the task being submitted. It alerts the user that the request no longer exists so they cannot press submit. In Teams the task now comes up with a correlation ID which alerts the user that it no longer exists. 

    requested approval unavailable copy.png

     

     

    requested approval unavailable - ms teams.png

     

    This is good enough for me. The user knows that they cannot action any longer rather than being misled to believe that they have submitted a response. 

  • Pstork1 Profile Picture
    66,004 Most Valuable Professional on at
    Re: Change Approval tasks from Active to Inactive

    Unfortunately, there is no way to clean up the reference in Outlook or Teams that I am aware of.

  • karenlacey Profile Picture
    58 on at
    Re: Change Approval tasks from Active to Inactive

    this is why it is always good to ask, yes delete row makes sense as users will never care about seeing that approval task status in a database. There is no use for it after the workflow ends. I have now used Delete Row and it has removed it from the table. In Outlook I get Requested Item is unavailable and in MS Teams I get a correlation error.

     

    Sorted thanks so much 

  • Verified answer
    Pstork1 Profile Picture
    66,004 Most Valuable Professional on at
    Re: Change Approval tasks from Active to Inactive

    Instead of marking them inactive it would be easier just to delete that row.  That will have essentially the same effect.  The approval will be removed from the pending approvals pane.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow