Unanswered

Existing table data not appearing in canvas app - edit form control.

(0) Share

Report

Posted on by Salim_A_M

Hello,

I am using the 'Edit form' canvas app control, which is relatively new to me, to recreate model driven forms' functionalities in a canvas app.

Among said functionalities is being able to set some fields to read only and set their data to some value of another lookup field's data.

This isn't exactly like a model driven app's 'quick view' form however, let me explain: (and have a screenshot of the form)

For the record, this form is set to FormMode.New

So... the user picks a position, and I want to show the position's job in the form, which will subsequently be set as the new record's job.

As far as I know, it should be as easy as referencing the position dropdown, then plugging the position's job record into the job field then displaying its name.

The way I'm doing it is by setting the Job field's data card's default value to the Position dropdown's job record,

I've researched and asked my colleagues to no avail, so I turn to this community for help. Any suggestions, and perhaps a refresher on some intricacies of the edit form I may have missed would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

EddieE 4,641 Moderator on at

Like (0)

Report
@Salim_A_M

You should be able to use a LookUp function to collect relevant data related to the selected 'Position', try something like this

// pseudo code, adjust to suit your needs // if you are using a DropDown control for Position LookUp( yourDataSource, Position = Position_DropDownName.Selected.Value, Job) // if you are using a ComboBox control for Position LookUp( yourDataSource, Position = First(Position_ComboName.SelectedItems).Value, Job)

To set lookup fields to read-only in your Form, adjust the Display Mode to View (default is Edit).

Was this reply helpful? Yes No
Salim_A_M 98 on at

Like (0)

Report

Hello! Excuse me for the late reply, go caught up with some other work.
Thank you for your answer. This has solved the issue.

Was this reply helpful? Yes No