Answered

Customer price class

(0) Share

Report

Posted on by NurNina

375

Hi, I have both model-driven and canvas apps that are using the same cds. I have to make a sales price according to the customer group (customer price class). However, I still do not understand the workaround of customer price class. How does the approach should be like?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the name of your table and what are the relevant columns

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 for now, I just use the standard entity in cds, the Account and Product. The price is all inside the product entity

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to get the price based on selected group then:
Insert a dropdown and a textbox
In the items property of the dropdown put: Product.CustomerGroup
Then in the textbox put :
LookUp(Product,CustomerGroup=DropdownName.Selected.Value,SalesPrice)

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NurNina ,

Could you please share a bit more about your scenario?

Is there a column called "Customer Group" in your Products Entity?

I assume that the Customer Group is a Option Set type column in your Products Entity, and there is a available option for this field -- "Customer Price Class".

If you want to get the Sales Price value (Sum value) based on the specific Customer Group value (e.g. 'Customer Price Class'), please take a try with the following formula:

Sum( Filter( Products, 'Customer Group' = [@'Customer Group'].'Customer Price Class' ), 'Sales Price' )

Note: The 'Sales Price' represents the Number type column in your Products Entity.

If you could provide more details about your scenario, we could provide a proper workaround for you.

Best regards,

Was this reply helpful? Yes No