Power Platform Community Forum Thread Details

Hello,

I have entity called HC Reports with the following structure:

No.Col (primary key)	HC Country (text)	HC Function (text)
1233	FRANCE	HUMAN RESOURCES
2343	FRANCE	ENGINEER

And other entity called Report with the following structure:

ReportID	HC Report (lookup to HC Reports)	HC Country (HC Report)	HC Function (HC Report)	Date
1323123	1233	FRANCE	HUMAN RESOURCES	01/08/2023
234234	2343	FRANCE	ENGINEER	01/08/2023

Every month the HC Report entity is updated and some HC Functions could be updated with new values.

The report data is created for each month, but every time a record from HC Reports updates, the value reference used in Report entity is updated. That's a normal behaviour in DataVerse.

In our case, we need the records from Report keep the previous values from the HC Reports lookup column and only the new added records use the new/changed values from the lookup.
Is it possible to achieve this in Model Driven APP?

Thank you,
Ruben

Categories:

Microsoft Dataverse with Power Apps

Hi @RubenRD

If you would like to keep the values as originally entered then you'd need to store those values locally in the Report table.

For this, you'd first need to create the fields/columns (with like-for-like field/column types) in the Report table for which you want the old values to be retained. You can set the fields to be read-only if you don't intend to update them in the Report table.

You can then create a Power Automate flow that copy-pastes the values from HC Reports to Report table. You'd need to think of a trigger that'd make the flow run only once.

I hope this information helps.

Kind regards

Gulshan

-----------------------------------------------

Please give a Thumbs Up to my reply if you appreciate my effort. If it helps resolve your query then please accept my reply as a solution.