web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / ProductList Pricelist ...
Power Apps
Unanswered

ProductList Pricelist issue

(0) ShareShare
ReportReport
Posted on by Djack 44

I'm building an quote tool for our sales people and I run into an issue.

 

Have 2 sharepoint lists

 

 Productlist

Djack_0-1628760415956.png

 

PriceList

Djack_1-1628760452550.png

 

Depending on the type of flat product and site your price of a flat can be different.

 

So when the sales select the product "basisprijs 1ste bewoner" and they selected the flat type B he should lookup in the pricelist the price of the article and let show the prijsB.... if the type of flat is c the field prijsC. But if there is a PrijsAlgemeen it should overrule the detail price .... (normally you only have or a PrijsAlgemeen of a PrijsA PrijsB .... you can not have PrijsAlgemeen and PrijsA ...)

 

I load the screen I create a Collection that will hold all correct products that can be sold on that site and a full price collection...

 

how to fix it ???

Categories:
Building Power Apps
I have the same question (0)
  • Nogueira1306 Profile Picture
    Nogueira1306 7,390 Super User 2024 Season 1 on at

    I did not understand your question well because of the non english names.

     

    But. You can always try LookUp() to get the itens from the other list

    You want to create a collection...

    So

    Collect(colList; {Name: LookUp(List; Name = "Name").Name; Number: LookUp(List; Name = "Name").Number})

     

    Something like that

  • Djack Profile Picture
    Djack 44 on at

    Djack_0-1628762379467.png

     

    The pulldown FlatType will define in what collumn in the price table he should see for the correct price... if and only if there is no AlgemeenPrijs defined

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans