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

แชร์
ฝัง
  • เผยแพร่เมื่อ 16 ธ.ค. 2024

ความคิดเห็น • 53

  • @barnoloji
    @barnoloji 9 หลายเดือนก่อน

    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  9 หลายเดือนก่อน

      Thanks and that would be a good video 🩵

  • @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?

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Welcome 🙏

  • @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  ปีที่แล้ว

      Thank you! 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.

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Ok 👌

  • @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 🙏

  • @waiyanhtun6641
    @waiyanhtun6641 2 ปีที่แล้ว

    Thanks. just what I've been looking for!

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Glad we could help! 🙂

  • @TremainSr
    @TremainSr ปีที่แล้ว

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

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      🙌 yes

  • @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.

  • @alekarpy
    @alekarpy 2 ปีที่แล้ว

    wow. Great tutorial, thank you!!

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Thank you! 🙂

  • @acaphamzah
    @acaphamzah 2 ปีที่แล้ว

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

    • @Valtoit
      @Valtoit  ปีที่แล้ว

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

  • @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.

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Thanks 🙏

  • @TheRemyRomano
    @TheRemyRomano 2 ปีที่แล้ว

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

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Sure 👌

  • @claudeuu2
    @claudeuu2 ปีที่แล้ว

    A lifesaver, thank you!

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      You're welcome!

  • @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.

  • @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

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Great 👍

  • @renzonavarro3170
    @renzonavarro3170 2 ปีที่แล้ว

    Really useful, thnaks dude!

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Glad it helped! 🙂

  • @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.

  • @mohamedmoez4408
    @mohamedmoez4408 2 ปีที่แล้ว

    thank you so much this tuto helped me

    • @Valtoit
      @Valtoit  ปีที่แล้ว

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

  • @tubbyda1
    @tubbyda1 3 ปีที่แล้ว

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

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Yup 👍

  • @cesarlarrea4576
    @cesarlarrea4576 3 ปีที่แล้ว

    Excelent tutorial!

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Thank you!

  • @EpicDreamer_
    @EpicDreamer_ 2 ปีที่แล้ว

    Thanks for this!!!!

    • @Valtoit
      @Valtoit  ปีที่แล้ว +1

      No problem!! Glad you liked the video🙂

  • @leobirch1972
    @leobirch1972 3 ปีที่แล้ว

    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  ปีที่แล้ว

      Glad we could help! 🙂

  • @jose19625
    @jose19625 3 ปีที่แล้ว

    Pero deja los codigo para uno trabajar mas comodo

    • @Valtoit
      @Valtoit  ปีที่แล้ว

      Sorry, only English :)