SOLVED

Hekpdesk dashboard from Sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1397867%22%20slang%3D%22en-US%22%3EHekpdesk%20dashboard%20from%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397867%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20in%20the%20middle%20of%20creating%20a%20complaints%20management%20system.%3C%2FP%3E%3CP%3EI%20have%20the%20different%20views%3A%3C%2FP%3E%3CUL%3E%3CLI%3EAll%20Items%3C%2FLI%3E%3CLI%3EActive%3C%2FLI%3E%3CLI%3EMy%20Items%3C%2FLI%3E%3CLI%3EHigh%20Priority%3C%2FLI%3E%3C%2FUL%3E%3CP%3EWhat%20I%20need%20is%20a%20dashboard%20to%20show%20the%20total%20numbers%2C%20a%20bit%20like%20the%20one%20here%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22app-on-sharepoint.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192381iB21E3AAA47E52A93%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22app-on-sharepoint.png%22%20alt%3D%22app-on-sharepoint.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1397867%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404370%22%20slang%3D%22en-US%22%3ERe%3A%20Hekpdesk%20dashboard%20from%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404370%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663412%22%20target%3D%22_blank%22%3E%40Mo_Islam%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20dashboard%20items%20are%20simply%20labels%20based%20on%20the%20counts%20of%20the%20different%20categories.%20You%20should%20be%20able%20to%20use%20the%20%22Service%20Desk%22%20sample%20code%20to%20reverse%20engineer%20what%20they%20did.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404397%22%20slang%3D%22en-US%22%3ERe%3A%20Hekpdesk%20dashboard%20from%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3EThank%20you%20for%20this%20suggestion.%20I've%20had%20a%20go%20with%20your%20suggestion%20and%20come%20to%20two%20problems%3A%3C%2FP%3E%3COL%3E%3CLI%3EIssue%20Tracking%20list%20cannot%20be%20added%20as%20a%20data%20source%20on%20Powerapps%3C%2FLI%3E%3CLI%3EThe%20alternative%20is%20to%20extract%20the%20data%20to%20an%20excel%20doc%20-%20but%20would%20you%20know%20if%20i%20leave%20this%20on%20the%20same%20server%20if%20there%20is%20a%20way%20for%20data%20to%20auto%20refresh%20even%20without%20opening%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EMo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405643%22%20slang%3D%22en-US%22%3ERe%3A%20Hekpdesk%20dashboard%20from%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405643%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663412%22%20target%3D%22_blank%22%3E%40Mo_Islam%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20recreate%20the%20Issue%20Tracking%20app%20as%20a%20modern%20list%20and%20you%20will%20be%20good.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415086%22%20slang%3D%22en-US%22%3ERe%3A%20Hekpdesk%20dashboard%20from%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415086%22%20slang%3D%22en-US%22%3EThank%20you%20Norman.%20I%20created%20another%20list%20which%20I%20am%20able%20to%20add%20as%20a%20data%20source%20to%20the%20Powerapps%20Canvas%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

I am in the middle of creating a complaints management system.

I have the different views:

  • All Items
  • Active
  • My Items
  • High Priority

What I need is a dashboard to show the total numbers, a bit like the one here:

app-on-sharepoint.png

 

How can I create this using powerapps? An help will be much appreciated.

 

Thank you in advance for your help.

4 Replies
Highlighted

Hi @Mo_Islam,

 

The dashboard items are simply labels based on the counts of the different categories. You should be able to use the "Service Desk" sample code to reverse engineer what they did.

 

I hope this helps.

 

Norm

Highlighted

@Norman YoungThank you for this suggestion. I've had a go with your suggestion and come to two problems:

  1. Issue Tracking list cannot be added as a data source on Powerapps
  2. The alternative is to extract the data to an excel doc - but would you know if i leave this on the same server if there is a way for data to auto refresh even without opening?

Thank you

Mo

Highlighted
Solution

Hi @Mo_Islam,

 

You could recreate the Issue Tracking app as a modern list and you will be good. 

 

I hope this helps.

 

Norm

Highlighted
Thank you Norman. I created another list which I am able to add as a data source to the Powerapps Canvas