Enable user access for powerapp canvas on sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1415130%22%20slang%3D%22en-US%22%3EEnable%20user%20access%20for%20powerapp%20canvas%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415130%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20the%20'Helpdesk%20template'%20from%20powerapps%2C%26nbsp%3B%20stripped%20everything%20off%20and%20only%20kept%20the%20counters%20as%20attached.%20The%20data%20source%20for%20this%20is%20a%20sharepoint%20list%20and%20I%20am%20using%20this%20as%20a%20dashboard%20counter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20two%20issues%20I%20am%20facing%3A%3C%2FP%3E%3COL%3E%3CLI%3EAt%20the%20moment%20I%20can%20only%20connect%26nbsp%3B%20the%20app%20for%20use%26nbsp%3B%20by%20myself%20and%20not%20other%20users.%3CUL%3E%3CLI%3EIs%20there%20a%20way%20to%20add%20the%20SharePoint%20site%20users%20by%20default%20so%20they%20do%20not%20need%20to%20be%20sent%20the%20'share%20app'%20request%3F%3C%2FLI%3E%3CLI%3EBasically%2C%20I%20have%20a%20group%20I%20made%20within%20SharePoint%20site%20called%20'Customer%20Services'%20who%20I%20want%20to%20be%20able%20to%20see%20the%20dashboard.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EI%20have%20used%20the%20following%20formula%20to%20filter%20the%20list%20items%20for%20the%20current%20user%20so%20whichever%20user%20logs%20in%2C%20the%20dashboard%20should%20show%20those%20associated%20to%20them%3A%3CUL%3E%3CLI%3ECountRows(Filter('Complaints%20Manager%20Archive'%2CCase_x0020_Handler.Email%20%3D%20User().Email))%3C%2FLI%3E%3CLI%3EThis%20works%20for%20me%20but%20not%20for%20another%20user%2F%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20thank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3EMo%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mo_Islam_0-1590352959695.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%2F194172iD39CE68626D6C694%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Mo_Islam_0-1590352959695.png%22%20alt%3D%22Mo_Islam_0-1590352959695.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1415130%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-1415416%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20user%20access%20for%20powerapp%20canvas%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415416%22%20slang%3D%22en-US%22%3EThe%20app%20needs%20to%20be%20shared%20with%20the%20users%20in%20that%20group%20directly%20or%20by%20office%20dist%20or%20365%20group%20membership.%20You%20can%20uncheck%20your%20email%20the%20sharing%20and%20then%20share%20a%20link%20however%20direct%20to%20the%20app%20which%20is%20in%20the%20app%20details.%20%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20users%20also%20need%20access%20to%20the%20underlying%20list%20obviously.%20The%20code%20you%20have%20should%20work%20fine%20if%20the%20access%20is%20correct.%20I%20usually%20like%20to%20wrap%20my%20user%20email%20in%20lower%20function%20as%20sometimes%20there%20can%20be%20caps%20in%20the%20email%2F%20logins.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416731%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20user%20access%20for%20powerapp%20canvas%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20response.%20Other%20than%20direct%20sharing%2C%20how%20can%20I%20enable%20this%3F%3C%2FP%3E%3CP%3EI%20tried%20following%20%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fadvanced-flow-of-the-week-role-based-security-in-powerapps-using-flow-sharepoint-groups%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E(this%20articel)%3C%2FA%3E%26nbsp%3B%2C%20but%20got%20an%20error%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PowerApp_Error.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%2F194328iA8228F47FD769D31%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22PowerApp_Error.PNG%22%20alt%3D%22PowerApp_Error.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20how%20can%20I%20wrap%20user%20with%20lower%20case%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416834%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20user%20access%20for%20powerapp%20canvas%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416834%22%20slang%3D%22en-US%22%3EYou%20just%20Surround%20the%20user.email%20in%20lower().%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Ffunctions%2Ffunction-lower-upper-proper%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Ffunctions%2Ffunction-lower-upper-proper%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20app%20has%20to%20be%20shared%20no%20way%20around%20it.%20The%20article%20you%20linked%20was%20for%20in%20app%20security%20roles%20etc.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416891%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20user%20access%20for%20powerapp%20canvas%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416891%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BThank%20you.%20I%20think%20the%20issue%20I%20am%20having%20is%20not%20being%20able%20to%20share%20the%20connector%20or%20does%20that%20happen%20when%20the%20app%20is%20shared%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20all%20the%20counters%20work%20for%20a%20user%20except%20for%20'My%20Cases'.%20I%20put%20lower%20around%20as%20well%3A%3C%2FP%3E%3CP%3ECountRows(Filter('Complaints%20Manager%20Archive'%2CCase_x0020_Handler.Email%20%3D%20Lower(User().Email)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Acrying_face%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi experts,

 

I have used the 'Helpdesk template' from powerapps,  stripped everything off and only kept the counters as attached. The data source for this is a sharepoint list and I am using this as a dashboard counter.

 

There are two issues I am facing:

  1. At the moment I can only connect  the app for use  by myself and not other users.
    • Is there a way to add the SharePoint site users by default so they do not need to be sent the 'share app' request?
    • Basically, I have a group I made within SharePoint site called 'Customer Services' who I want to be able to see the dashboard.
  2. I have used the following formula to filter the list items for the current user so whichever user logs in, the dashboard should show those associated to them:
    • CountRows(Filter('Complaints Manager Archive',Case_x0020_Handler.Email = User().Email))
    • This works for me but not for another user/

I thank you in advance for your help.

Mo

 

Mo_Islam_0-1590352959695.png

 

4 Replies
The app needs to be shared with the users in that group directly or by office dist or 365 group membership. You can uncheck your email the sharing and then share a link however direct to the app which is in the app details.

The users also need access to the underlying list obviously. The code you have should work fine if the access is correct. I usually like to wrap my user email in lower function as sometimes there can be caps in the email/ logins.
Highlighted

@Chris Webb Thank you for your response. Other than direct sharing, how can I enable this?

I tried following (this articel) , but got an error:

PowerApp_Error.PNG

and how can I wrap user with lower case please.

 

 

Highlighted
You just Surround the user.email in lower(). https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-lower-upper-proper

The app has to be shared no way around it. The article you linked was for in app security roles etc.
Highlighted

@Chris Webb Thank you. I think the issue I am having is not being able to share the connector or does that happen when the app is shared?

 

Currently all the counters work for a user except for 'My Cases'. I put lower around as well:

CountRows(Filter('Complaints Manager Archive',Case_x0020_Handler.Email = Lower(User().Email)))

 

:crying_face: