web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Push latest record val...
Power Apps
Unanswered

Push latest record value from a certain column into another table

(1) ShareShare
ReportReport
Posted on by 23

Hello everyone,

I'm new to Power Apps/ Dataverse so please bare with me while I try to explain.

 

I have two tables. One is a master table and one is an activities table. Let's say it's a book tracking example:

 

Table One (Master Table)

- Book Name

- Book Genre 

 

Table Two (Activity Table)

- Book Name

- Activity Date

- Rented To

- Book Status (choice column: available, rented)

 

I want to create a Book Status column in Table One that pulls in most recent Book Status for that Book Name from Table Two. This means when Table 2 has a new record, the lastest 'Book Status' value should be pushed into Table One. I'm not sure how to set this up in Dataverse. Calculation? Business Rule? Thanks! 

 

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @KellyMcLaren ,

     

    I would probably do the following to accomplish this functionality.

    1. Add two columns to the parent table being "Latest Activity Date" and "Latest Book Status".  You need the "Latest Activity Date" to handle if someone creates an Activity that is in the past, you don't want to overwrite the latest status.
    2. Create a real-time workflow that will execute on the "creation" of the record or when the "Activity Date" or the "Book Status" changes

    The Real-Time Workflow will kick off when a new record is created and should check first to verify the regarding is the Master Table and then see if the Latest Activity Date is null or it is < the Activity Date of the Activity and if it is then Set the Parent record's Book Status to the Activity record's book status.

     

    The Workflow would look something like the following (representative...)

    dpoggemann_0-1632879665576.png

     

    Hope this helps.  Please accept if answers your question or Like if helps in any way.

     

    thanks,

     

    Drew

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard