SOLVED

System Status Button / Image

%3CLINGO-SUB%20id%3D%22lingo-sub-1558544%22%20slang%3D%22en-US%22%3ESystem%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558544%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20just%20wandering%20if%20anyone%20had%20some%20ideas%20how%20to%20setup%20the%20following%20in%20SharePoint%20Online.%3C%2FP%3E%3CP%3EI%20have%20a%20site%20that%20displays%20a%20Word%20document%20(could%20use%20another%20app)%20that%20shows%20the%20status%20(green%20%2F%20amber%20%2F%20red)%20of%20some%20of%20our%20services.%26nbsp%3B%20This%20is%20a%20manual%20process%20and%20is%20good%20but%20we%20want%20to%20be%20able%20to%20have%20another%20idicator%20on%20our%20main%20SharePoint%20page%20-%20so%20an%20image%20or%20text%20box%20that%20shows%20either%20green%2Famber%2Fred%20if%20any%20of%20the%20services%20are%20affected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20the%20word%20doc%20which%20uses%20a%20table%20has%20only%20green%20status%20fields%2C%20the%20image%2Ftext%20on%20the%20main%20SharePoint%20site%20will%20be%20Green%20with%20a%20status%20of%20All%20Services%20UP%3C%2FP%3E%3CP%3EBut%20if%20one%20of%20the%20fields%20are%20Amber%20or%20Red%2C%20the%20main%20SharePoint%20page%20will%20show%20as%20either%20amber%20or%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20word%20document%20could%20be%20a%20list%20instead%20if%20it%20has%20to%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20as%20to%20how%20I%20would%20do%20this%20%3F%3C%2FP%3E%3CP%3EI%20wanted%20to%20keep%20to%20a%20small%20image%2Ftext%20on%20the%20main%20SharePoint%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1558544%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Esharepoint%20status%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559091%22%20slang%3D%22en-US%22%3ERe%3A%20System%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437047%22%20target%3D%22_blank%22%3E%40GaryS123%3C%2FA%3E%26nbsp%3B%20I%20would%20suggest%20giving%20a%20try%20to%20low%20code%20no%20code%20option%20that%20is%20PowerApp%20as%20you%20said%20any%20other%20app%20will%20be%20good%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20is%20a%20very%20comprehensive%20docs%20about%20Power%20apps%20I%20am%20sure%20exploring%20this%20wouldn't%20hurt%20as%20you%20could%20do%20much%20more%20using%20Sharepoint%2C%20Sharepoint%20lists%2C%20and%20PowerApps%2C%20besides%20there%20are%20some%20automation%20using%20PowerAutomate%20(previously%20known%20Flows)%20and%20Some%20PowerBi%20for%20reporting%20and%20dashboards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fpowerapps-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fpowerapps-overview%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561382%22%20slang%3D%22en-US%22%3ERe%3A%20System%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561382%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437047%22%20target%3D%22_blank%22%3E%40GaryS123%3C%2FA%3E%26nbsp%3Bwhy%20don't%20you%20just%20add%20the%20status%20into%20a%20SharePoint%20list%20as%20a%20Choice%20column%20and%20you%20can%20then%20format%20the%20column%20with%20Red%2C%20Amber%20and%20Green%20out-of-the-box%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22RAG.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209726i4D4D66730E2A9EBD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22RAG.png%22%20alt%3D%22RAG.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22RAG2.png%22%20style%3D%22width%3A%20672px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209725i871644AFC331AF1D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22RAG2.png%22%20alt%3D%22RAG2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562475%22%20slang%3D%22en-US%22%3ERe%3A%20System%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%20Thanks%2C%20yes%20I%20have%20done%20that%20it%20looks%20good%20on%20my%20status%20page%20which%20may%20have%20up%20to%2012%20services%20listed%20but%20I%20was%20then%20after%20a%20way%20to%20show%20a%20summary%20on%20our%20main%20sharepoint%20page%20so%20if%20all%20services%20were%20green%2C%20it%20would%20somehow%20indicate%20that%20on%20the%20main%20page%2C%20if%20we%20had%20any%20amber%20services%2C%20it%20would%20just%20have%20an%20amber%20sign%2Fmessage%20and%20if%20any%20red%20services%2C%20a%20red%20sign%2Fmessage.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wanted%20a%20short%2Fsmall%20indicator%20on%20the%20main%20page%20and%20if%20the%20'indicator'%20was%20not%20green%20they%20could%20click%20and%20go%20to%20our%20service%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20take%20a%20look%20at%20powerapps%20too.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562477%22%20slang%3D%22en-US%22%3ERe%3A%20System%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562477%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F181929%22%20target%3D%22_blank%22%3E%40Pervaiz%20Dostiyar%3C%2FA%3E%26nbsp%3Bthanks%20will%20have%20a%20look%20at%20the%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562511%22%20slang%3D%22en-US%22%3ERe%3A%20System%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437047%22%20target%3D%22_blank%22%3E%40GaryS123%3C%2FA%3E%26nbsp%3Bthe%20way%20I%20would%20do%20that%20is%20to%20have%20a%20separate%20list%20for%20the%20main%20page%20dashboard%20and%20use%20a%20flow%20in%20Power%20Automate.%26nbsp%3B%20You%20could%20get%20the%20status%20from%20several%20lists%20all%20in%20that%20flow%20and%20update%20the%20overall%20status%20column%20in%20the%20main%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562533%22%20slang%3D%22en-US%22%3ERe%3A%20System%20Status%20Button%20%2F%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562533%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi all, just wandering if anyone had some ideas how to setup the following in SharePoint Online.

I have a site that displays a Word document (could use another app) that shows the status (green / amber / red) of some of our services.  This is a manual process and is good but we want to be able to have another idicator on our main SharePoint page - so an image or text box that shows either green/amber/red if any of the services are affected.

 

So if the word doc which uses a table has only green status fields, the image/text on the main SharePoint site will be Green with a status of All Services UP

But if one of the fields are Amber or Red, the main SharePoint page will show as either amber or red.

 

The word document could be a list instead if it has to be.

 

Any ideas as to how I would do this ?

I wanted to keep to a small image/text on the main SharePoint page.

 

Thanks

 

6 Replies
Highlighted

@GaryS123  I would suggest giving a try to low code no code option that is PowerApp as you said any other app will be good,

 

here is a very comprehensive docs about Power apps I am sure exploring this wouldn't hurt as you could do much more using Sharepoint, Sharepoint lists, and PowerApps, besides there are some automation using PowerAutomate (previously known Flows) and Some PowerBi for reporting and dashboards.

 

https://docs.microsoft.com/en-us/powerapps/powerapps-overview

Highlighted

@GaryS123 why don't you just add the status into a SharePoint list as a Choice column and you can then format the column with Red, Amber and Green out-of-the-box:

RAG.png

 

RAG2.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott  Thanks, yes I have done that it looks good on my status page which may have up to 12 services listed but I was then after a way to show a summary on our main sharepoint page so if all services were green, it would somehow indicate that on the main page, if we had any amber services, it would just have an amber sign/message and if any red services, a red sign/message.  

 

Just wanted a short/small indicator on the main page and if the 'indicator' was not green they could click and go to our service page.

 

I'll take a look at powerapps too.

Thanks

Highlighted

 @Pervaiz Dostiyar thanks will have a look at the link.

 

Highlighted
Best Response confirmed by GaryS123 (Contributor)
Solution

@GaryS123 the way I would do that is to have a separate list for the main page dashboard and use a flow in Power Automate.  You could get the status from several lists all in that flow and update the overall status column in the main list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

Thanks @Rob Elliott