Model Driven App Command Button Appearance Depending On Field Values On The Form

(0) Share

Report

Posted on by JS-29072031-0

I’ve created a model driven app that has a solution containing a table named Investment. On the main form for the Investment table, there is a field named Assigned_Reviewer. The Assigned_Reviewer is a look up field to the Role table Name (primary) field.
At the top of the Investment Main form is a command button that says Approve.
Here is what I need to know how to do:
When the user viewing a record on the Investment Main form is the same person specified in the Assigned_Reviewer field, I want the Approve command button to be visible and active. Otherwise, I want the Approve command button to be invisible or inactive.
I need the java script to get current user, which I’m assuming will run for the Investment Main form On Load event, but more importantly, I need the fx code that will compare the current user to the Assigned_Reviewer and then control the appearance of the Approve command button.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You can use the following article as a reference: https://softchief.com/2022/07/06/show-hide-command-button-based-on-field-value-of-the-form-using-powerfx-in-dynamics-365-model-driven-apps/

Just change the part where you check for the field in the form.

Instead of checking an option set, check for a lookup field.

Hope this helps.

Was this reply helpful? Yes No
JS-29072031-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Narayan for that suggestion, however, I'm looking for help on how to compare the current user of the app to the person listed in the Assigned Reviewer field. Then, based on whether the current user and the Assigned Reviewer match, make the command button visible or not.

Was this reply helpful? Yes No
Tony_Suslovich 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JS-29072031-0, I know it's been almost 2 months since you asked this question, but have you been able to make this work? I'm facing a similar dilemma and tried using User().Email to compare the logged-in user to a value in a lookup field on the form, but I couldn't get User() to work. I have a feeling it just doesn't work for model driven apps, only for canvas apps.

Was this reply helpful? Yes No
JS-29072031-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

In the end, I chose not to use a command button in part because I couldn't ascertain the current user via FX code in my model driven app as easily as a canvas app. So instead, I added an Approved Yes/No field to my Investment table, and used java script, on the form's On Load event, to compare the current user to the assigned user, to determine whether the Approved Yes/No field is locked or unlocked. If you're not comfortable writing java script: If you clearly describe in detail what you need the script to do, Chat GPT (Openai.com) will do a fairly good job of writing the script for you. Usually some tweaking is needed, but it can be a huge help.

Was this reply helpful? Yes No