Answered

Display grid line items in a view mode in a different table

(0) Share

Report

Posted on by EBMRay

1,712

Hello,

I have an employee table associated with a payroll table as 1:N which shows that this employee has basic salary, transportation, etc..

The third table is called adjustments, which means that HR can increase the employee's salary by raising a request.

I would like to know if it is possible when selecting an employee on the third table while raising the request to just display the grid lines in a view for the HR visibility about his current amount on the payroll controls. (Screenshot 1 where I have highlighted)

What would be the best approach to achieve it? A custom PCF that displays this data in a grid view on the adjustment table?

I don't want to re-create the same entries in a custom table to avoid growing the data.

Any help is greatly appreciated.

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Julien2

You can add a quick view form with a sub grid for the employee rate grid and link it to the Employee lookup and then it can be displayed on the adjustment form.

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like (0)

Report
Copy link

Link copied!

Hello @Mira_Ghaly ,

Thank you for your suggestion.
I followed the same steps you provided and it worked perfectly. However, we still have a small challenge to make the sub-grid read-only (hiding (+Add New/Existing) buttons)

I didn't find the option to make it read-only. Will the Ribbonworkbench allow us to hide the buttons on a quick-view form in the employee adjustment table?
Awaiting your response.

Best regards,
Julien

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Julien2

I highly doubt you will be able to do it using ribbon workbench.

Another alternative you can use embedded canvas app to display the employee rates grid in place of the quick view.

Was this reply helpful? Yes No