Answered

Populate value (from SharePoint list) based on Dropdown selection and input value

(0) Share

Report

Posted on by Alanisp22

145

I am trying to populate a price value from a SharePoint list onto my form when a user selects a product type from a dropdown and inputs the number of units in an input field. The price is based on a pricing tier so I will need Powerapps to pull the correct price value based on the product type and quantity inputted. I have tried to use Lookup within 'Default' from the input box where I want the value to populate but nothing is populating. I have attempted to create a new form from scratch but the same outcome. Is there something else other than Lookup I should be using?

SharePoint list:
Pricechart: SharePoint list with pricing
Product: Vlookup column with product names

Min: minimum number of units

Max: maximum number of units

Price: price set for the product based on the min and max unit ranges

Form Fields:
ProductName: Dropdown combo box in form that pulls product names from vlookup column from my other 'ProductTracker' list
Units: Input field box on the form where the user will input the quantity of units needed

Priceperunits: Input field box on the form that should populate pricing based on product type selected and units inputted (should reference pricing from PriceChart SharePoint list.)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yutliu-msft on at

Like (2)

Report
Hi @Alanisp22 ,

Do you want to populate price in a textinput based on the selection of product type(drop down) and the value of units(textinput)?

Could you tell me:

1)the fields in 'ProductTracker' list and the fields in PriceChart list and these fields data type?

2)the relationship between 'ProductTracker' list and PriceChart list?

I assume that:

1)product type is a text type field in 'ProductTracker' list

2)product type is a lookup field in PriceChart list, looks up to product type field in 'ProductTracker' list

3)price is a number type field in PriceChart list

If so, you could set like this:

1)the drop down's Items:

Choices(ProductTracker.'product type')

the drop down's OnChange:

Reset(pricetextinputname)

2)the units textinput's OnChange:

Reset(pricetextinputname)

3)the pricetextinput's Default:

LookUp(PriceChart,'product type'.Value=dropdownname.Selected.Value,price)*Value(unitstextinputname.Text)

Best regards,

Was this reply helpful? Yes No
Alanisp22 145 on at

Like (0)

Report

@v-yutliu-msft You are AMAZING!!!!!! You were right on target with my field data types and your solution worked! I am soooo happy right now! Thank you! Thank you!

Was this reply helpful? Yes No