Need to check one table, and update another - not sure how.

(0) Share

Report

Posted on by Hilda Steyn

291

I have two tables in a one to many relationship.

DEALS (one) - INVESTMENTS (many).

In the DEALS table, I have a column called ACTIVE DEAL (yes / no).

In the INVESTMENTS table, I have a column called CLOSURE DATE

I need to create a flow that will check, and update if necessary, the ACTIVE DEAL column of all the records in the INVESTMENTS table. To do this, all of the CLOSURE DATEs of the deals under the investment must be checked; if none of the dates are blank anymore, then the active deal field in the Deals table should be updated to No.

I can't get my head around it.

Could someone please point me in the right direction.

(I am new to Power Automate).

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Unknown geen idee 1,757 on at

Like (0)

Report
Copy link

Link copied!

Dear Hilda,

What you try to do seems perfectly do-able ... only thing I am wondering about is what kind of environment you are working in. Is this all within OneDrive/Sharepoint or ...? The relationship statement seems to indicate another database or something.

Within OneDrive/Sharepoint it is fairly easy, another environment will be a bit more tricky depending on what it is.

Happy flowing,
Koen

Was this reply helpful? Yes No
Hilda Steyn 291 on at

Like (0)

Report
Copy link

Link copied!

All the data is in Dataverse.

Was this reply helpful? Yes No