Model Driven View One-To-Many column

(0) Share

Report

Posted on by AnthonyD

559

Hi guys,

So i was wondering. I have this case: A training has multiple durations. Would it be possible to have a column in my training view that shows the first duration date (related to the training) from the related durations table? How would this be achieved?

Best Regards,

Anthony

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Bipin D365 971 on at

Like (0)

Report

Hi,

You can easily achieve this with the help of Roll up field.

Create new roll up field in Training entity as Date Time data type and select field type as Rollup.

Select Max function in rollup field on Duration Date.

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

CR8.PNG

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Hi @Anthony_Dob ,

If rollup does not meet your needs I would do the following:

Create the field for First Duration Date on the Training record

Create realtime workflow triggering on create of Duration record and on modification of Duration record's Date field

First step in workflow checks if the Training tables "First Duration Date" is null or > Duration table record's "Date" field

If true on #3 then do Update Record on the Training record and set the date tot he Duration table's date

The steps above will handle if you make changes to the dates on the Duration table and if you create a new one with a date < the current first one.

2. The first step should check if the Tra

Was this reply helpful? Yes No
AnthonyD 559 on at

Like (0)

Report

@dpoggemann ,

I've been trying to implement your instructions but i can't seem to find a OR statement in the classis editor. This is how my workflow looks atm:
I see you can add OR and AND groups but you need 2 or more statements for that.

Best Regards,
Anthony

Was this reply helpful? Yes No
AnthonyD 559 on at

Like (0)

Report

@bipinshan

A rollup field does not work for me. I've tried that already and it's not returning any values.

Best Regards,
Anthony

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @Anthony_Dob ,

When you are building the condition there is the ability to create multiple conditions and then group them with OR clause. You select each row and then say "Group OR", see below.

Was this reply helpful? Yes No
AnthonyD 559 on at

Like (1)

Report

@dpoggemann Oh! that's how it works!

Well i kinda did it another way and it works too! Here is how i did it:

Thanks for the great help!
Best Regards,
Anthony

Was this reply helpful? Yes No