cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KoenJanssensPD
Advocate II
Advocate II

Side by side record comparison

Dear,

In a model-driven app, how can I have 2 (identical) forms of 2 (different) records of the same table  side by side?

Ideally, I would also like to highlight differences between the two records in the forms...

Any idea?

Thanks,

Koen

18 REPLIES 18

Another option to consider - totally outside technical solutions - is that there might be some rules-based mechanism for making the "do I overwrite" determination on users' behalf. Often people are just so accustomed to making that sort of call that it doesn't even occur to them that it is systematic and reproducible.

 

For example, let's say the field is a phone number. In the 'internal' system we have (123) 123-1234 (forgive the US formatting, @KoenJanssensPD - I'm guessing you don't use that!) then from the "external" system we get an update for (234) 234-2345. This new number has a valid format, and therefore there is probably no reason we wouldn't just automatically accept it, whereas if it came back 234-2345 we might reject it because the format is not what we expect and we don't want to lose the quality of what we have. 

 

Of course, this is a very simple case and the real business operation would be much more complex, but in many... maybe the real majority of cases, there are such heuristic rules that could be applied to make any exceptions so infrequent that special tooling is not required.

a33ik
MVP

@KoenJanssensPD I wrapped the first version of the extension and it is available here - https://github.com/AndrewButenko/SideBySideComparisonReport

I plan to release the video today/tomorrow so if you don't want to miss the release - subscribe to my Youtube channel.

View solution in original post

Wow, that's awesome.
I checked the code a bit and it even contains a Diff-view, nice! I will wait the video to see the results 🙂

@KoenJanssensPD  I will work on the video today and may publish it tomorrow but as a spoiler you can see this:

SideBySideComparison.png

a33ik
MVP

HemantG
Power Apps
Power Apps

Interesting discussion.  Keeping both the internal and external records in the same table means filter for showing one needs to be added at all places like views, lookup etc etc.  Why not use another table which is copy to make it master for external and use the workflow/Plugin to copy the data when master external data record is created. 

 

For compare and merge you can write a control which when clicked uses WebAPI to fetch the right record data from external table using the record key from the current form of internal entity and shows the readonly  tabular values side by side for the values which differ. Something like 

HemantG_0-1623132425097.png

User can pick and choose the right fields which the control uses to update the internal record when the save is clicked. Control default UI can be just one button saying merge external and when clicked , it goes full screen and uses pre-fetched values to render the UI. 

 

@a33ik entity name for master and key field name can be configurations for theis PCF if you are planning to code 🙂 

 

hemant

 

 

 

KoenJanssensPD
Advocate II
Advocate II

@a33ik Awesome! It's so wonderful a community is that helpful AND Power Platform is highly customizable!

@HemantG I have been thinking about putting the "internal" and "external" records in different tables, but that means I have to make forms, field definitions,... twice and keep them synchronized...

The filtering is currently not really a problem; I was also thinking of deactivating all the external records, so they don't appear in default views...

@HemantG no PCF involved and I coded it - check my previous reply.

this is perfect @a33ik , i saw the video .. great stuff. Thanks for helping the community .

 

hemant 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,285)