web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : MpoimyvCM3UqMdx63HPg/j
Power Automate - Building Flows
Unanswered

Dataverse Update Row not updating row.

Like (0) ShareShare
ReportReport
Posted on 12 Apr 2023 15:03:06 by 38

In a flow, I have an Update Row block that should change a field with an 'In Progress' when it gets to a point in my approval routing.  I see that the block runs and is marked complete, however, the table doesn't update.  

KGuthrieNF_0-1681311253262.png

KGuthrieNF_3-1681311601209.png

 

 

The part that I do not get is I have the same setup when the approval is done to change the status to 'Complete'.  This update block works as it should.  

KGuthrieNF_2-1681311434979.png

KGuthrieNF_4-1681311661579.png

 

 

The value comes from a choice list.  Nothing that I can tell is overwriting the value, I have even tried to delete the non-working block to re-insert a new one.  Nothing I try seems to be working.  Any thoughts?

 

 

I have the same question (0)
  • abm abm Profile Picture
    32,506 Most Valuable Professional on 12 Apr 2023 at 22:09:59
    Re: Dataverse Update Row not updating row.

    Hi  @KGuthrie-NF 

     

    Thanks for clarifying this. From the screenshot it looks ok. You need to check the run history and check that switch case condition is executed or not.

     

    Thanks

  • KGuthrie-NF Profile Picture
    38 on 12 Apr 2023 at 16:59:47
    Re: Dataverse Update Row not updating row.

    Yes, that is the step.  The InProgress is the first thing done in that case statement.  The conditional step you see below is just a condition to send an email to a user or not based on a yes/no condition.

    KGuthrieNF_0-1681318779771.png

     

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 12 Apr 2023 at 16:52:16
    Re: Dataverse Update Row not updating row.

    Hi @KGuthrie-NF 

     

    Lots of step here 🙂 Is this step? Here where is the InProgress one. I can see a conditional parallel branch here. 

     

    image.png

  • KGuthrie-NF Profile Picture
    38 on 12 Apr 2023 at 16:38:37
    Re: Dataverse Update Row not updating row.

    The one that is not working is in the 'Started (Dept Approval)' case.

    KGuthrieNF_0-1681317388456.png

    KGuthrieNF_2-1681317456170.png

     

      The one that works is in the 'Completed' case. 

    KGuthrieNF_3-1681317474311.pngKGuthrieNF_4-1681317498108.png

     

     

     

     

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 12 Apr 2023 at 16:32:36
    Re: Dataverse Update Row not updating row.

    Hi @KGuthrie-NF 

     

    Thanks for the screenshot. In this which step is the update In Progress?

     

    Thanks

  • KGuthrie-NF Profile Picture
    38 on 12 Apr 2023 at 15:50:05
    Re: Dataverse Update Row not updating row.

    I have gone through the run history and cannot find why it is not working.  From what I can tell it IS updating. Unfortunately, I cannot audit the table.  Our organization does not have this feature turned on. 

     

    As far as seeing the full flow, it is quite expansive (It is a recursive CASE flow) and will be hard to get on one screenshot.  Below is the best I can do.

    KGuthrieNF_1-1681314149806.png

    KGuthrieNF_3-1681314241933.png

    KGuthrieNF_5-1681314350802.png

    KGuthrieNF_6-1681314403358.png

    KGuthrieNF_7-1681314453249.pngKGuthrieNF_8-1681314490103.png

    KGuthrieNF_9-1681314527511.png

    KGuthrieNF_4-1681314308142.png

     

     

     

     

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 12 Apr 2023 at 15:17:38
    Re: Dataverse Update Row not updating row.

    Hi @KGuthrie-NF 

     

    Need to see the full flow to determine what's going on here.

     

    Could of ways to debug this.

     

    1. Check the run history of each steps in your flow. 

    2. Turn on the Audit history of those fields under that table. Check the values after running the flow.

     

    Thanks

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 854 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 525 Moderator

#3
trice602 Profile Picture

trice602 318 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete