Answered

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:

General Questions

All responses (2)

Answers (1)

Salim_A_M 98 on at

Like (0)

Report

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

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

EddieE 4,641 Super User 2025 Season 1 on at

Like (0)

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

@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).