Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : NjdtRivKQQjN2qbQRQo96z
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Excel Form into a Powe...
Power Apps - Power Apps Experimental Features
Answered

Excel Form into a Power App

Like (1) ShareShare
ReportReport
Posted on 26 Mar 2025 18:51:25 by HEW 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. 
 
  • Verified answer
    Hasrie Profile Picture
    Hasrie 192 on 27 Mar 2025 at 03:47:16
    Excel Form into a Power App
    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)
    t9.png
  • Verified answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 38,255 Super User 2025 Season 1 on 26 Mar 2025 at 19:32:43
    Excel Form into a Power App
    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
     

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,681 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans