Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

MS Forms but smaller? The templates are way too big for what I need. Suggestions?

(0) ShareShare
ReportReport
Posted on by

I posted this over on the Excel forum, but they suggested I post here instead.

 

I need to make a form (or really anything else that connects to an excel spreadsheet). The data is just two columns with 6 different numerical values in each column. I can do this in Forms, technically, but I can't seems to make it fit into one page.

 

I want to do this in Forms because it connects to Excel well, but I'm open to any other Microsoft product that connects to Excel. My issue right now is how much space Forms templates take up. There's 12 fields, I don't want 12 (or even 6) pages of questions.

I don't want direct access to the spreadsheet itself, just the ability to write the most current data to it.

  • ANB Profile Picture
    ANB 7,060 on at
    Re: MS Forms but smaller? The templates are way too big for what I need. Suggestions?

    Hi @MARTHAABERNATHY , Please correct me if I am wrong. You are looking for creating a form which can connect to excel. If yes, then yes you can create PowerApps canvas form which can connect to excel which is store on your OneDrive for Business or SharePoint Online site and using Excel Online connector you can create form. I will share few links which will help you creating the form:

     

    https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/get-started-create-from-data

    https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/get-started-create-from-blank

    https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-excel

    https://www.youtube.com/watch?v=mnHxS5XD8jc

    https://www.youtube.com/watch?v=TiFVQ8UrjDM

     

    ------------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

    Thanks,
    ANB

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard