Announcements
Hi
Can anyone help me sales calculations for example
Date Sku Description txtQty txtRate txtAmount
4/13/20 RB123 Coke 1.5 L 4 $1.50 $6
SharePoint List
txtQty - number field txtRate - Currency fieldtxtAmount - Currency field
Thanks
Use:
txtRate.Text *txtQty.Text
OR
Value(txtRate.Text) *Value(txtQty.Text)
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hi @eka24
sorry i forget to ask Product is Lookup field and description is on the product list same, how can i make it when i select product the description to come auto please, see the screenshot.
Date Product Description txtQty txtRate txtAmount
Try the formula below in the Description textbox if you want autopopulate description:LookUp(YourTableName,Product=ProductTextBoxText,Descripton)
If the product is a dropdown:
LookUp(YourTableName,Product=ProductDropdown.SelectedValue,Descripton)
I dont know what wrong i ma doing but is not populating description from the comboBox to txtDescriptionLookUp(SalesTable,'Product/Service'.Value=ComboBox1.Selected.Value,'Product/Service:Purchase Description'.Value)
And combo-box i am using this code on items property
Hi @Ramole ,
Do you mean that?
1) product field is text type in product list
2)description is text type in product list
3)product field is look up type in SalesTable(look up to product field in product list)
If so, please set txtDescription's Text:
LookUp(Productlist ,'Product/Service'=ComboBox1.Selected.Value,description)
//description is a field in product list, you need to filter based on product list
Best regards,
Please which of your column names are choices in your sharepoint list
Is this 'Product/Service:Purchase Description' two columns or one
here is my SharePoint List columns
Hi @v-yutliu-msft
Yes to filter so when i select product combo, the descriptions to auto populate on textbox
Have you tried my solution?1)connect your app with product list and SalesTable list
2)set product combo box:
Choices(SalesTable.'Product/Service')
3)set the descrption textinput's default:
//you need to get desrption value from product list, so you need to filter productlist, not saleslist.
you correct i have done that yesterday and connected both sales and products and its working, but can i patch to sales table ?
second question is there a way the combo to show 2 lines example tow show sku and product plus if there is a way to search multi field ?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 432 Super User 2026 Season 2
Mohsin Ali 347
WarrenBelz 254 Most Valuable Professional
