Skip to main content

Notifications

Power Platform integration forum
Unanswered

Update row

Posted on by 29
I'm trying to update a row based on a condition.
 
Steps are:
 
1- find all rows in table equal to ko_deal id value added to the same table.
2- find row with process step = process step in added row - 1
3 - update this row's active stage end date
 
two problems:
1. I'm not able to build a calculation using process step. It's a number field, but is not accessible in the formula editor to create Process Step - 1
2. My condition doesn't seem to allow me to select the row that was found in the conditional statement. ie. the condition finds the correct row, and I want to complete the action based on that row. But it still asks me to input the row ID etc. so it's unclear whether it will perform the action on the correct row from the condition.////
  • JW-02052039-0 Profile Picture
    JW-02052039-0 29 on at
    Update row
    Attached some more screenshots. I've created a loop which checks for the Deal id in the table. When it finds the deal id where the process step = process step from the new row (one step behind), it should update the stage end date on the previous process step to the start date on the new row.
     
    This does not seem to work. 
     
    I think there are some problems with the Process Step. Attached some screenshots. The output is blank in many cases, and the numbers don't make any sense in others. I'm not able to access process step in the formula editor, even though it's a number field. Not sure what to do from here.
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Update row
    Hi Partner,
    The process in your conditional statement was obtained from that step, and you need to get the guid value for application status histories in the same step
    Could you share full screenshot about this flow?

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans