Microsoft PowerApps: How to Change Colors based on Status with Switch Formula

Поделиться
HTML-код
  • Опубликовано: 1 фев 2025

Комментарии • 53

  • @usurper762
    @usurper762 3 года назад

    Finally a video I can follow with ease and where my results are the same as yours. Thanks for the video, this was a big help. Cheers!

    • @Valtoit
      @Valtoit  2 года назад

      Thank you! Glad you liked the video! 🙂

  • @duncanmacintyre6972
    @duncanmacintyre6972 3 года назад

    Hi Dougie, just to say thanks so much for putting this video up it has allowed me to conditionally format each gallery item as well (instead of an icon) and when sorted based on modified date feels really professional thanks :)

    • @Valtoit
      @Valtoit  3 года назад

      Thanks for the great feedback Duncan, I would love to hear how you are getting on using PowerApps. If you have any ideas for future videos we can create that will help you, please let me know.

  • @waiyanhtun6641
    @waiyanhtun6641 2 года назад

    Thanks. just what I've been looking for!

    • @Valtoit
      @Valtoit  2 года назад

      Glad we could help! 🙂

  • @acaphamzah
    @acaphamzah 2 года назад

    Thank you very much. Really helpful for beginners like me.

    • @Valtoit
      @Valtoit  2 года назад

      You're very welcome! Glad the video was helpful 🙂

  • @claudeuu2
    @claudeuu2 Год назад

    A lifesaver, thank you!

  • @alekarpy
    @alekarpy 2 года назад

    wow. Great tutorial, thank you!!

    • @Valtoit
      @Valtoit  2 года назад

      Thank you! 🙂

  • @TheTrainIsCominggggg
    @TheTrainIsCominggggg 3 года назад

    Excellent video, Sir! Thank you so much!

    • @Valtoit
      @Valtoit  3 года назад

      You are welcome! If you have any ideas of videos you would like to see from us, please let us know in the comments.

  • @leobirch1972
    @leobirch1972 4 года назад

    Great tutorial, thanks for the tips which saved me a lot of time. I was initially trying to use an IF statement, however this is simpler for the task :-)

    • @Valtoit
      @Valtoit  2 года назад

      Glad we could help! 🙂

  • @kathrynhall2019
    @kathrynhall2019 3 года назад +1

    Great video, thank you. Exactly what I want, but need it to link to a date value so that anything past a set date value would be red, anything in the 30 day lead up to the set date value would be yellow, and anything more than 30 days from the selected date would be green. Based on today's date in relation to the set date values. (E.G. expiry of a Drivers Licence, to track visually when it's getting close to expiry and when it's lapsed and we need an updated copy) How would I achieve this?

  • @barnoloji
    @barnoloji 11 месяцев назад

    thanks mate it was helpful. Do you have a video about how to create top of the categories on your screen? I wanna see every status in diffrent tab. thanks.

    • @Valtoit
      @Valtoit  11 месяцев назад

      Thanks and that would be a good video 🩵

  • @mohamedmoez4408
    @mohamedmoez4408 2 года назад

    thank you so much this tuto helped me

    • @Valtoit
      @Valtoit  2 года назад

      You're very welcome! Happy to hear that we helped 🙂

  • @renzonavarro3170
    @renzonavarro3170 2 года назад

    Really useful, thnaks dude!

    • @Valtoit
      @Valtoit  2 года назад

      Glad it helped! 🙂

  • @therisingsun4828
    @therisingsun4828 2 года назад +1

    Great tutorial. I was able to do this when my value was based on a single line of text column in Dataverse. However, I'm unable to reproduce this effect with a choice column. Any tips or adivce?

    • @kathleenarragon1897
      @kathleenarragon1897 Год назад

      Did you find the answer to this question ? I don't understand how to do it either

    • @therisingsun4828
      @therisingsun4828 Год назад

      @@kathleenarragon1897 nope

    • @Simone_Nika
      @Simone_Nika Год назад

      Same here, did you get any solution?

    • @Simone_Nika
      @Simone_Nika Год назад

      Updates, I was able to fix this issue by replacing the commas with semicolons.

    • @Valtoit
      @Valtoit  Год назад

      Thanks 🙏

  • @TremainSr
    @TremainSr Год назад

    Can this been done with checkboxes instead of new, rejected, and approved? When all subcategories are selected it changes everything to green?

  • @EpicDreamer_
    @EpicDreamer_ 2 года назад

    Thanks for this!!!!

    • @Valtoit
      @Valtoit  2 года назад +1

      No problem!! Glad you liked the video🙂

  • @jl8660
    @jl8660 2 года назад +1

    Hello, I get this error message "this formula uses scope which is not presently supported for evaluation" how do I solve it? My app is connected to a Sharepoint list fyi.

  • @joenice242
    @joenice242 2 года назад

    Great! Still struggling with color formatting a date picker. It works after a date has been selected but shows wrong colour as default. (Default White, under30days green, under 60 days yellow and 61+ days=red.

  • @patrickc.3185
    @patrickc.3185 2 года назад

    Thank you very much, this is very helpful. However, I am having some difficulty comparing more than 1 status. Can you show me how to compare more than one status? Here is an example I have (Ex. 1. ThisItem.Power.Value 2. ThisItem.Building.Value 3. ThisItem.Water.Value) I can only change the color for 1 value. I need to meet all the 3 conditions to decide which color to change. Hope you can help me with this, thanks.

  • @cesarlarrea4576
    @cesarlarrea4576 3 года назад

    Excelent tutorial!

  • @TheRemyRomano
    @TheRemyRomano 3 года назад

    What if you wanted to fade the icon color over time to indicate how recent a status has changed?

  • @cristiancamilohernandezuri337
    @cristiancamilohernandezuri337 3 года назад +1

    It is possible with numbers?

    • @Valtoit
      @Valtoit  Год назад

      Anything is possible

    • @Valtoit
      @Valtoit  Год назад

      Anything is possible

  • @Simone_Nika
    @Simone_Nika Год назад

    To anyone working with choice columns, try replace the commas with semicolons

  • @tubbyda1
    @tubbyda1 3 года назад

    i need this for to change from a date, is that possible.

  • @jose19625
    @jose19625 3 года назад

    Pero deja los codigo para uno trabajar mas comodo

    • @Valtoit
      @Valtoit  Год назад

      Sorry, only English :)