Answered

Auto populate field

(0) Share

Report

Posted on by ShadowTech

Hello,

Scenario:

Working with two data sources within a new submit form. The main data source is a SharePoint list and the secondary is a SQL table. When a number is entered into field "A", Filed "B" (ComboBox) is auto populated with all SQL table rows associated with that number. When the user chooses a value in filed "B" (ComboBox), Field "C" should be auto populated with a value from the Quantity column in the SQL table in that same row.

"PartNumb3" is the ComboBox which determines what the value will be in field "C" but for some reason does not like the equals sign.

Below is the syntax for field "C":

If(Form1.Mode=FormMode.New, LookUp('[dbo].[tblTable01]',ReAuthNum=DataCardValue10.Text && Item = 'PartNumb3',RecQuantity),ThisItem.'Qty.')

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShadowTech .

You need to refer to the combo box selected item, not the field in it

If( Form1.Mode=FormMode.New, LookUp( '[dbo].[tblTable01]', ReAuthNum=DataCardValue10.Text && Item = ComboBoxName.Selected.xxxx ).RecQuantity, ThisItem.'Qty.' )

with xxxx being the valid output from the combo box (Value/Result/FieldName depending on the Items )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Yeah, I was missing the ".Selected.Value" portion.

Thanks again for your help Warren!

Was this reply helpful? Yes No