Flow Designer - how to connect two tables

[SnowUser09]

Hi All, 

I am trying to create a process flow in flow designer, trying to change the "state" of a Release(rm_release) based on "Approval" in Group approvals ( sysapprovals_group). So trigger condition is in table sysapprovals_group - when approval is approved or rejected, based on that Action should be rm_release- State should be approved or rejected. But unable to tag actions in release table based on trigger in release... so how to connect these two tables. 

Tried using Flow variable also but did not able to use it properly.

[Uncle Rob]

Your approval record is going to have a reference to the task its approving.
So you do a lookup on that reference.
Then you do an update record on the record you just looked up.

No need to join tables.

[SnowUser09]

Can you pls provide.some more info as how to create or check reference 

[Amit Gujarathi · Accepted solution]

HI @SnowUser09 ,
I trust you are doing great.

1. Create a new flow in Flow Designer and select the trigger as "Record Updated" for the table "sysapproval_group".

2. In the Conditions section of the Flow, add the condition to check if the Approval is either "approved" or "rejected".

3. In the Actions section of the Flow, add an action to retrieve the associated Release record for the current Approval.

4. Once you have the Release record, you can set its state to "approved" or "rejected" based on the Approval status.

5. To connect the two tables, you can use a reference field in the Release table to the Approval table. This will allow you to retrieve the associated Approval record for the Release and vice versa.

6. Alternatively, you can use a Flow variable to store the Release record when the Approval is updated and then use this variable to update the Release state in a separate Flow action.