Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
Expand all | Collapse all

powerapps shared access

  • 1.  powerapps shared access

    Posted May 13, 2020 09:11 AM
    Edited by Mohamed Younis May 13, 2020 09:11 AM

    Dear All,

     I've created an app to show Dial invoices for each users  using (Filter) function on powerapps ,

    my data source is an Excel sheet so I have to share it with the users to get access  ( why I used excel: cause I update every month this sheet with the invoices using lookup function from another sheet)

    I've tried to upload to share point list but always keep shows me an error update just one column

    my question is,   how can I hide this excel sheet from (shared with you) tab, to restrict the user shown full data in excel sheet 

    OR

    used another one 

    used SharePoint list with how to pass this error,



    ------------------------------
    Kind regards

    Mohamed Younis
    ------------------------------


  • 2.  RE: powerapps shared access

    Top Contributor
    Posted Jun 02, 2020 09:52 AM
    I would suggest using a Sharepoint list for this. I do not know a way to hide the excel file since people need permission to write to the file.
    You will have the same issue  with Sharepoint, but there are ways to hide the list from users while still giving them access.
    Do a google search on Sharepoint list security and April Dunham and Laura Rogers. They both have blog posts about how to obscure the lists

    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------



  • 3.  RE: powerapps shared access

    Posted Jun 03, 2020 03:23 AM
    A quick way to obscure the list in SharePoint can be done using SharePoint Designer 2013

    ------------------------------
    Nabeel Salie
    SharePoint Developer
    ------------------------------



  • 4.  RE: powerapps shared access

    Top Contributor
    Posted Jun 03, 2020 07:03 AM
    All the advice I have seen for the last 2 years is to NEVER use Sharepoint Designer. It has been abandoned for quite a while

    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------



  • 5.  RE: powerapps shared access

    Posted Jun 03, 2020 07:57 AM
    Respectfully, I do not believe that is entirely accurate.

    SPD can still be used, depending on what you want to do.
    To hide a list, no issue.

    ------------------------------
    Nabeel Salie
    SharePoint Developer
    ------------------------------



  • 6.  RE: powerapps shared access

    Top Contributor
    Posted Jun 03, 2020 08:17 AM
    I'm not saying you can't use it, but development never went beyond the 2013 release.

    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------



  • 7.  RE: powerapps shared access

    Posted Jun 03, 2020 08:32 AM

    Hi Brian, Thanks for your respond 

    yes I did that, I have uploaded this Excel data source to SharePoint list 

    Thanks,



    ------------------------------
    Mohamed Younis
    11753
    ------------------------------