web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Tips needed for first ...
Power Apps
Unanswered

Tips needed for first time developing with powerapp

(0) ShareShare
ReportReport
Posted on by 7

Hello anyone! Thank you in advance for you replies hoping can help others too.


I'm trying to develop a Power Application that keep tracks few fields of N users of a company. I mean, this application have to show a gallery where each record contain (Date, Company worked for, Hour in and Hour out). I would like to use a single Excel file to store all the data and I've already filtered the things to show up to the people who use the application through a:
Filter(User().Email exactin "Field".Email).

Now my first question is: since to let the app works for all the employes I have to share the Application + the Excel file to the people I want in Powerapp there is no problem cos they can not read and edit others people information but just regardingthemself, but of course they can access to the shared Excel and manipulate other employes data, right??


Which solution could be better?

I was thinking about different ideas:

- Can be doable to create a single Excel file/table for each employee? In this case how can I manage that the User X can only read the excel X.Y?
- Is there a way to let the Connectors be dynamics? I mean, if I have a user X, he can call the relative connector to display/add/edit the datas.
- Is the only solution to let the application be based SQL?

Thanks a lot !

Categories:
  • Florian_Kleinz Profile Picture
    227 on at

    Hello,

     

    For my understanding, yes they need permission to the excel file, but they have no possibility to get the file location.

    So If the file is stored somewhere on SharePoint where it can't be found easily you are good to go.

     

    Is it correct that they don't need to pull data from the excel but the PowerApp is only appending new lines?

     

    Best regards

  • foozar Profile Picture
    7 on at

    Oh, okay. I didn't know there was the possibility to store the file in Sharepoint but not giving the the file location. I will do some test to see if the solution can be up to me!


    I reply to your last question:

    All the employes need to pull and push data regarding themself and nothing else. I already did it with few checks inside the Forms and the Gallery.


    The only thing I'm scared is if anyone can directly edit the Excel with all the information of all the employes.

     

     

     

  • foozar Profile Picture
    7 on at

    I have an update:

     

    I've been trying to share the Excel File without sending them any notification but when they log-in inside OneDrive they can see the file, open and edit as they like.

     

    On to the file clicked the three vertical dot -> Manage Access -> Typed the email without sending notification.

     

    Did I misunderstood how to do that or is there another way to let the other people use the Excel file only through PowerApp?

  • foozar Profile Picture
    7 on at
    up

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 232 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 202 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard