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.
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