Update row

(0) Share

Report

Posted on by JW-02052039-0

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.

I have the same question (0)

All responses (2)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

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?

Was this reply helpful? Yes No
JW-02052039-0 29 on at

Like (0)

Report

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.

Was this reply helpful? Yes No