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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (19)

Answers (2)

Sort by

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @KT61, are using Model-Driven app or Canvas?

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Hi, Canvas.

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@KT61, then in your case you sill simply use the LookUp function to get the "Equipment Name" value into the Form Field Default property.

Your formula will be something like this:

LookUp(ET, Tag= TagField.Selected.Value, "Equipment Name Column Name")

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for the help
Do you mean I enter LookUp(ET, Tag= TagField.Selected.Value, "Equipment Name Column Name") in the default property of the data card? like below

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@KT61 , from ET table, what is the column name of your equipment name? Use that instead what I have as an example.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Thanks, changed the name, unfortunately not working

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@KT61 , the display name which is in your case is the “Equipment Name”

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@KT61, also, you should use the default value of the Text Input not the Card.

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I don't see "default" on the text input properties

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No