Power Platform Community Forum Thread Details

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!

Categories:

Microsoft Dataverse with Power Apps

Hi @KellyMcLaren ,

I would probably do the following to accomplish this functionality.

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