Unanswered

Help with automating price system!

(0) Share

Report

Posted on by MarioSassano

Hi All,

I run a blinds business and am building an app to run all my jobs, quotes and pricing on etc. I currently have several price sheets for each kind of blind and size etc. I want to base the price on the size, colour, style of blind etc. I have build the inputs needed as shown below. I have also attached a typical price sheet. I have found a way to do this but it would literally take hundreds, if not thousands of hours to code manually the way I have started (I have attached below), and was wondering if there is a much easier way to do this!

Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,974 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

I am sorry but I dont follow. I see what you posted but I dont understand what the issues are, what you want to do, how you interact with that data.

If you can walk us through how it will be used and where you put the data you were inputting etc. And which part would take thousands of hours? what are you stuck on exactly?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
MarioSassano 2 on at

Like (0)

Report
Copy link

Link copied!

Okay, sorry for the bad explaining.....
Basically I will use this app on quotes. I will select what type of blind, I then want to select what colour. Then I input the width and height of that blind. I then want the price field to be automatically calculated once all of that has been done. In my bottom screenshot I am showing what I have currently done to automatically work out a price. As you can see from the amount of sizes I deal with in my price chart (Top Screenshot) this would take a long time to manually keep putting in the sizes this way, and this is only for one specific blind and colour (I have maybe 30 altogether) . All the prices are different based on blind type, colour and size. Once this is automatically filled, I have a button which would add that specific blind to a collection so I can reset the fields and do it for another blind. Once I have completed the quote for that person I would have a button to patch my collection to a sharepoint list to store the quote. My main issue is speeding up the automatic pricing part, I don't know if using an excel connector would help in soneway? Or building a table within the power app of all my price lists?

Let me know if you need more info or if it still doesn't make sense!

Was this reply helpful? Yes No
Michael E. Gernaey 53,974 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes, personally I would put this in SharePoint or Excel. To me SharePoint is easier to leverage, (not in all cases) but it might be in this case.

Either way, you need somewhere that we can essentially do this.
CalulatePrices = LookUp(BlindPrices, BlindType = X, Size = Y, Color = T, WhateverElse = EE).Price * Units

or something to that effect. Yes if you had an Excel Sheet or SharePoint List, you could do this very easy.
I'd have to understand all the pivots (such as in my fake LookUp above.

Columns Would Be
Blind Name
Color
Size
Drop
Price Per Unit
AnythingElse

Now you can do this and then just have 1 to many rows in the same List for every color of the blind, or have a lookup to color or sizes etc. I think for you, having it all in one list is easier based on the volume of data you have.

So yeah, I'd put it in SharePoint myself as a Flat Table, then you can have your Price Text Value (I'd use a Label here if you didn't) be the Formula (with error handling of course)

Something like
If(all the fields have selections, calculuate price, do nothing yet)

Happy to help please provide column names and anything else you want in there.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No