Answered

Model Driven App Command Button To Post Look Up Value To Text Field

(1) Share

Report

Posted on by JS-29072031-0

I am creating a model driven power app. In the app, I have an investment form over the investment table.
On the investment form I have a field called reviewer 1 which is a look up field using the Role table to
get the Reviewer 1 name. I also have a field called reviewer 2 which is a single line of text field on the
investment form. On the Investment form I have a command button called Approve. When the user clicks the
approve command button, I would like the value of the reviewer 1 look up to be posted to the reviewer 2 text field.
What is the best way to accomplish this? I have not been able to come up with any Power Fx code that
avoids triggering an error.

Categories:

Using Apps Using Formulas

Dataflows

All responses (2)

Answers (1)

Suggested answer

JS-29072031-0 10 on at

Like (1)

Report

Model Driven App Command Button To Post Look Up Value To Text Field

Jonathan, Thank you very much for your answer. It led me to the solution that worked for me. Specifically, here is what I ended up with, which does exactly what I needed:

Power Fx code when command button Input By is clicked:

Patch(Investments,Self.Selected.Item,{Reviewer1:LookUp(Roles,Name=Text(Self.Selected.Item.'Trans Reviewer1'.Name),Name)});

Note the use of commas instead of semi-colons, but then that may be a geographical based setting???

Also note the table names are "pluralized".

I've included the following in case anyone is curious why the Patch is written as it is:
Verified answer

Jonathan Manrique 2,678 on at

Like (2)

Report
Model Driven App Command Button To Post Look Up Value To Text Field

Hi

You have two ways to achieve this

I have a field called Requester against the users table

One without the need for a button, simply using Power FX formula columns, when you select the approver in the lookup field, the name will appear in the text field
'Requested By'.'Full Name'

The other way is with the button that says you must make a patch

Patch('Approval Requests';Self.Selected.Item;{'Approver Name Form 2':LookUp(Users;'Full Name'=Self.Selected.Item.'Requested By'.'Full Name' ).'Full Name'})

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
Follow me on Linkedin, I talk about Power Platform
www.linkedin.com/in/jonathan-manrique-rios