Form Primary column autofill

Like (0) Share

Report

Posted on 1 Sep 2022 21:12:44 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 13 Sep 2022 at 13:15:47

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 09 Sep 2022 at 03:10:32

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 08 Sep 2022 at 15:49:33

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 08 Sep 2022 at 07:08:54

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 Moderator on 07 Sep 2022 at 16:52:32

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 07 Sep 2022 at 13:46:14

Like (0)

Report

Re: Form Primary column autofill

Hi ,any more help on this please?
KT61 347 on 03 Sep 2022 at 17:28:06

Like (0)

Report

Re: Form Primary column autofill

Yes, it is the Dataverse for Teams app. Value property did not work
AhmedSalih 6,678 Moderator on 03 Sep 2022 at 17:08:00

Like (0)

Report

Re: Form Primary column autofill

@KT61 , try the Value property. Is this Dataverse for Teams app?
KT61 347 on 03 Sep 2022 at 17:04:16

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 Moderator on 03 Sep 2022 at 16:46:05

Like (0)

Report

Re: Form Primary column autofill

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