A Complete Feasibility Matrix in Power Apps for Project Management

Sdílet
Vložit
  • čas přidán 25. 07. 2024
  • This video is a continuation of Part1: • Creating a Business Va...
    We build an app to chart Business Value vs Feasibility. In the video we only use collections to create the chart, that means the data will not save. In order for the data to save you will need to Patch the data!
    This is the complete feasibility matrix in power apps which could be incorporated into many different types of Matrix. A feasibility matrix is a tool used for evaluating multiple options or solutions against a set of criteria to determine their viability or practicality. It helps in comparing different alternatives based on factors such as cost, time, resources, and risk, enabling decision-makers to identify the most feasible option. The matrix simplifies complex decision-making processes by visually representing the strengths and weaknesses of each option, making it easier to assess and prioritize them.
    If you have trouble patching, let me know I think I can make a Part3.
    If you have other questions feel free to let me know in the comments. And THANK YOU for watching!
    CZcams will not allow me to put the less than or equal than sign in the description, so just double check the formula!
    circleColor code:
    If(
    LookUp(colCircles,ID = 1,Feasibility = 7) &&
    LookUp(colCircles,ID = 1,BusValue = 3),
    Color.Red,
    If(
    LookUp(colCircles,ID=1,Feasibility = 7) &&
    LookUp(colCircles,ID=1,BusValue = 1),
    Color.Orange,Color.Green)
    )
    X of a circle: LookUp(colCircles,ID=1,BusValue*57.5)
    Y of a circle: LookUp(colCircles,ID=1,Feasibility*57.5)
    Visible of a circle: If(varID=1,true,false)
    lblID: LookUp(colCircles,ID=1,ID)
    Chapters:
    0:00 introduction
    1:19 Creating a Component
    4:07 Replacing our Circle with Component
    7:45 Changing the Video based on the ID
    8:45 Thinking about Coloring
    9:30 Changing the Fill or circleColor
    10:39 The Full Color code
    13:30 Just inserting Rectangles and Changing Alpha
    14:30 Conclusion
  • Věda a technologie

Komentáře • 3

  • @rpaconsultant-ericparijs
    @rpaconsultant-ericparijs Před 4 měsíci +1

    Thank you, Andrew, awesome stuff!

    • @andrewhess123
      @andrewhess123  Před 4 měsíci

      Thanks for watching Eric! I feel like there was so much more I could add but maybe that would bore the normal CZcams watcher! Hopefully this is the start of something great!

  •  Před 4 měsíci

    Could you use a gallery and one component inside of it, and as the gallery Item use your collection to populate the dots?