Answered

Form Primary column autofill

(0) Share

Report

Posted on by KT61

347

Hi, in power apps through teams using a dataverse table, I add a new screen with data. I select the datasource i have called "Work" in dataverse.

In "Work" table I have "TAG" as a lookup column to table "ET" (TAG is the primary column in ET)

"TAG" is a drop down in the form.

Another column in ET table is "Equipment Name"

If I select a value for "TAG" in the form for "Work" how can I add "Equipment Name" into form and get the associated value in "Equipment Name" to fill automatically.

Thanks

Categories:

General Questions

All responses (19)

Answers (2)

KT61 347 on at

Like (0)

Report

Re: Form Primary column autofill

Hi, got it working, was using the incorrect name for the datacardvalue. thanks
Verified answer

v-jefferni on at

Like (0)

Report

Re: Form Primary column autofill

Hi @KT61 ,

It should be very similar. I have confirmed this by a small test:

This Employee column is of type text and I am able to make the app auto-populate that Text Box based on the Dropdown selection. The Dropdown above is from a LookUp column, which relates to another table. The "BAP" is the application name column value stores in that table.

Best regards,
KT61 347 on at

Like (0)

Report

Re: Form Primary column autofill

Thanks for the help, couldn't get it to work. Would it be because of teams and using canvas?
Verified answer

v-jefferni on at

Like (1)

Report
Re: Form Primary column autofill

Hi @KT61 ,

Try the formula below on Value of the Equipment Name Data Card Value (which is a Text Input and seems you have set to view only):

TAG.Selected.'Equitment Name'

The reason is, when selecting something in the TAG Combo box, it is a record from the ET table being selected and the value you have seen is from the display field of this Combo box. As the result, you will be able to reference the columns of that selected record.

Best regards,
AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Form Primary column autofill

@KT61, do you get any error from the formula you have in the Value property?
KT61 347 on at

Like (0)

Report

Re: Form Primary column autofill

Hi ,any more help on this please?
KT61 347 on at

Like (0)

Report

Re: Form Primary column autofill

Yes, it is the Dataverse for Teams app. Value property did not work
AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Form Primary column autofill

@KT61 , try the Value property. Is this Dataverse for Teams app?
KT61 347 on at

Like (0)

Report

Re: Form Primary column autofill

Really appreciate you helping me while you are travelling, sorry for all the questions!
I don't seem to have the option
AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Form Primary column autofill

@KT61 @Sorry the Text property. I am traveling 🤭