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
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
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.
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
Жыл бұрын
Thank you! Glad you liked the video! 🙂
Thanks. just what I've been looking for!
@Valtoit
Жыл бұрын
Glad we could help! 🙂
Excellent video, Sir! Thank you so much!
@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.
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
Жыл бұрын
Glad we could help! 🙂
A lifesaver, thank you!
@Valtoit
6 ай бұрын
You're welcome!
Excelent tutorial!
@Valtoit
Жыл бұрын
Thank you!
Thank you very much. Really helpful for beginners like me.
@Valtoit
Жыл бұрын
You're very welcome! Glad the video was helpful 🙂
wow. Great tutorial, thank you!!
@Valtoit
Жыл бұрын
Thank you! 🙂
Thanks for this!!!!
@Valtoit
Жыл бұрын
No problem!! Glad you liked the video🙂
Really useful, thnaks dude!
@Valtoit
Жыл бұрын
Glad it helped! 🙂
thank you so much this tuto helped me
@Valtoit
Жыл бұрын
You're very welcome! Happy to hear that we helped 🙂
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
6 ай бұрын
Welcome 🙏
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
4 ай бұрын
Thanks and that would be a good video 🩵
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
6 ай бұрын
Thanks 🙏
To anyone working with choice columns, try replace the commas with semicolons
@Valtoit
6 ай бұрын
Great 👍
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
6 ай бұрын
Use =
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
11 ай бұрын
Did you find the answer to this question ? I don't understand how to do it either
@therisingsun4828
11 ай бұрын
@@kathleenarragon1897 nope
@NikaBreezyASMR
7 ай бұрын
Same here, did you get any solution?
@NikaBreezyASMR
7 ай бұрын
Updates, I was able to fix this issue by replacing the commas with semicolons.
@Valtoit
6 ай бұрын
Thanks 🙏
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
6 ай бұрын
Ok 👌
What if you wanted to fade the icon color over time to indicate how recent a status has changed?
@Valtoit
6 ай бұрын
Sure 👌
Can this been done with checkboxes instead of new, rejected, and approved? When all subcategories are selected it changes everything to green?
@Valtoit
6 ай бұрын
🙌 yes
i need this for to change from a date, is that possible.
@Valtoit
6 ай бұрын
Yup 👍
It is possible with numbers?
@Valtoit
6 ай бұрын
Anything is possible
@Valtoit
6 ай бұрын
Anything is possible
Pero deja los codigo para uno trabajar mas comodo
@Valtoit
10 ай бұрын
Sorry, only English :)