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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Excel Form into a Powe...
Power Apps
Unanswered

Excel Form into a Power App

(1) ShareShare
ReportReport
Posted on by 8
Hello,
 
I am looking for some advice please, I have the attached excel spreadsheet that currently has an automated flow that pulls some of the data from it into a sharepoint list, but it can be very clunky and relies on a couple of items to be exact or it does not work.
 
I want to move away from excel and use PowerApps to complete the Monthly Update, save it to a sharepoint folder as a PDF with a name so we can use it for review meetings - I have already done this as a PDF on a current so I was going to use the same again. 
 
However I am not sure how to create the same format seen in the excel document on a PowerApp Screen? I know there is a form template but not sure if this would provide what is needed, in this layout?
 
I also only want to take certain text boxes to update the sharepoint list not all of the data cards/ text boxes, can this be done on PowerApps?
 
Last question on this feature, can you restrict a Power app screen to only show the items in the gallery to the person logged on to the App?
 
Thank you for the advice. 
 
Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,335 Super User 2025 Season 2 on at
    Hi @HEW
     
    Your Questions
     
    I also only want to take certain text boxes to update the sharepoint list not all of the data cards/ text boxes, can this be done on PowerApps?
     
    So yes, you can build a screen (without a form and just use a Patch statement which is easy enough) and only add what you want. That being said, it gets complicated when you have a 1-M thing, not to show it so much, but if you want people to ADD 1-M into a "grid/table". If you know what you are doing its not hard and there are 1000000 examples all over.
     
    The only thing again that is imperative is if a column is required, you need to put it on the screen OR, if you just build a Screen (no forms) with controls on it to look like this (totally possible), then you can just add a value to the field, versus making them type/select something.
     
    But yes this is very doable and people do it all the time.
    If the List is already made, you can even just have Power Apps AI use the list to build it for you, then remove what you do not want (again if its not required).
     
    Last question on this feature, can you restrict a Power app screen to only show the items in the gallery to the person logged on to the App?
    Yes, you would have to use a little bit of filtering. So for instance
    There is a created by column in sharepoint which you can use to Compare against the user logged in, or you can create your own like (email only) column and then compare the user who is logged into that.
     
    You would use the User(). function to get to the email etc of the person logged in and you would essentially do
     
    Filter(mysource, EmailColumn = User().Email)
     
    and only have it pull back where they matched
     
  • Verified answer
    Hasrie Profile Picture
    202 on at
    However I am not sure how to create the same format seen in the excel document on a PowerApp Screen? I know there is a form template but not sure if this would provide what is needed, in this layout?
     
    I also only want to take certain text boxes to update the sharepoint list not all of the data cards/ text boxes, can this be done on PowerApps?
     
    You can create the ui with or without using Form, Gallery. The trick is by using either Text, Label, Dropdown etc, and use Patch to submit the data back to the Sharepoint column. Refer to the attach photo
     
    Last question on this feature, can you restrict a Power app screen to only show the items in the gallery to the person logged on to the App?
     
    Visible > If(User().Email = "admin@admin.com", true)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard