Hello,
I've been tasked with a creating a configurator for products/solutions that my company sells.
The main issue why I was approached is that I have some Visual Basic programming skill, and could probably make a decent program using Excel.
I started looking into using MS Access instead of Excel, and found that Microsoft themselves discouraged using it, and referenced Power Apps along with this statement.
I've never heard about Power Apps before reading this, though I found it interesting based on the set of criterias I imagine my configurator should be able to provide our sales team. For this instance, I will use the example of letting our sales team sell computers:
1st screen (with images)
2nd screen (based on their first choice)
- Size of screen (dynamically updated image on the side showing the dimensions of the size)
- Ram
- List of compatible Graphics card
- etc.
3rd Screen (Summary)
- Output a sales report in Excel or PDF with a custom format and store their entries in Dataverse.
Now I am just on the edge, getting ready to make the jump and try to make this configurator, but I need some kind of reassurance that it will look better, work better and potentially will let other colleagues be encouraged to use it, instead of creating some old looking excel-sheet.
From what I can tell, I will be needing to incorporate:
- Model driven app using Dataverse as source
- Power Automate to automatically generate reports based on input
Any help, or guidance would be useful.
Best regards,
John
