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

Ғылым және технология

In this episode of the series we show you how to create your own RAG Status (Red, Amber, Green).
We achieve this by placing a circle icon within the PowerApp Gallery then place the following Switch Formula to change the icon background colour depending on the status of the item:
Switch(ThisItem.'Body Part Injured'.Value, "Head", Red, "Shoulders", Yellow, "Toes", Green, Green)
If you have any questions in regards to Power Apps or would like to hear more about our services, please contact us via: Hello@valto.co.uk
More Information:
valto.co.uk/microsoft-powerapps/
-----------------------------------------------------------------------------------------------------
power apps,power platform,powerapps,microsoft power platform,learn powerapps,powerapps forms,powerapps,powerapps tutorial,powerapps data card,powerapps list form,microsoft powerapps,office 365 powerapps
-----------------------------------------------------------------------------------------------------
digital transformation,digital transformation strategy,digital transformation 2020,what is digital transformation,digitale transformation,digital transformation 2019,digital transformation video,digital transformation trends,digital transformation speaker,digital transformation tutorial,digital transformation training,digital transformation examples,digital transformation mckinsey,what is digital transformation 2018,digital transformation disruption,simplilearn digital transformation

Пікірлер: 53

  • @duncanmacintyre6972
    @duncanmacintyre69723 жыл бұрын

    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

    2 жыл бұрын

    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.

  • @usurper762
    @usurper7622 жыл бұрын

    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! 🙂

  • @waiyanhtun6641
    @waiyanhtun6641 Жыл бұрын

    Thanks. just what I've been looking for!

  • @Valtoit

    @Valtoit

    Жыл бұрын

    Glad we could help! 🙂

  • @TheTrainIsCominggggg
    @TheTrainIsCominggggg2 жыл бұрын

    Excellent video, Sir! Thank you so much!

  • @Valtoit

    @Valtoit

    2 жыл бұрын

    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
    @leobirch19723 жыл бұрын

    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! 🙂

  • @claudeuu2
    @claudeuu27 ай бұрын

    A lifesaver, thank you!

  • @Valtoit

    @Valtoit

    6 ай бұрын

    You're welcome!

  • @cesarlarrea4576
    @cesarlarrea45763 жыл бұрын

    Excelent tutorial!

  • @Valtoit

    @Valtoit

    Жыл бұрын

    Thank you!

  • @acaphamzah
    @acaphamzah Жыл бұрын

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

  • @Valtoit

    @Valtoit

    Жыл бұрын

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

  • @alekarpy
    @alekarpy Жыл бұрын

    wow. Great tutorial, thank you!!

  • @Valtoit

    @Valtoit

    Жыл бұрын

    Thank you! 🙂

  • @EpicDreamer_
    @EpicDreamer_2 жыл бұрын

    Thanks for this!!!!

  • @Valtoit

    @Valtoit

    Жыл бұрын

    No problem!! Glad you liked the video🙂

  • @renzonavarro3170
    @renzonavarro31702 жыл бұрын

    Really useful, thnaks dude!

  • @Valtoit

    @Valtoit

    Жыл бұрын

    Glad it helped! 🙂

  • @mohamedmoez4408
    @mohamedmoez44082 жыл бұрын

    thank you so much this tuto helped me

  • @Valtoit

    @Valtoit

    Жыл бұрын

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

  • @kathrynhall2019
    @kathrynhall20192 жыл бұрын

    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

    6 ай бұрын

    Welcome 🙏

  • @barnoloji
    @barnoloji4 ай бұрын

    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

    4 ай бұрын

    Thanks and that would be a good video 🩵

  • @joenice242
    @joenice2422 жыл бұрын

    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

    6 ай бұрын

    Thanks 🙏

  • @NikaBreezyASMR
    @NikaBreezyASMR7 ай бұрын

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

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Great 👍

  • @patrickc.3185
    @patrickc.3185 Жыл бұрын

    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.

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Use =

  • @therisingsun4828
    @therisingsun48282 жыл бұрын

    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

    11 ай бұрын

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

  • @therisingsun4828

    @therisingsun4828

    11 ай бұрын

    @@kathleenarragon1897 nope

  • @NikaBreezyASMR

    @NikaBreezyASMR

    7 ай бұрын

    Same here, did you get any solution?

  • @NikaBreezyASMR

    @NikaBreezyASMR

    7 ай бұрын

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

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Thanks 🙏

  • @jl8660
    @jl86602 жыл бұрын

    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

    6 ай бұрын

    Ok 👌

  • @TheRemyRomano
    @TheRemyRomano2 жыл бұрын

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

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Sure 👌

  • @TremainSr
    @TremainSr8 ай бұрын

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

  • @Valtoit

    @Valtoit

    6 ай бұрын

    🙌 yes

  • @tubbyda1
    @tubbyda13 жыл бұрын

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

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Yup 👍

  • @cristiancamilohernandezuri337
    @cristiancamilohernandezuri3372 жыл бұрын

    It is possible with numbers?

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Anything is possible

  • @Valtoit

    @Valtoit

    6 ай бұрын

    Anything is possible

  • @jose19625
    @jose196253 жыл бұрын

    Pero deja los codigo para uno trabajar mas comodo

  • @Valtoit

    @Valtoit

    10 ай бұрын

    Sorry, only English :)

Келесі