Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Need to check one tabl...
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by Hilda Steyn 265

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).

 

  • Hilda Steyn Profile Picture
    Hilda Steyn 265 on at
    Re: Need to check one table, and update another - not sure how.

    All the data is in Dataverse. 

  • Unknown geen idee Profile Picture
    Unknown geen idee 1,755 on at
    Re: Need to check one table, and update another - not sure how.

    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

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans