cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

I need help creating an app that populates data into an Excel doc

Hello, 

I am trying to design an app that will feature a drop-down list of "names", once a name is selected then the "next" button is enabled, then when you tap next it takes you to a page that says "where will you be tomorrow 'name'?" and has an input text card underneath for the user to type in their expected location. then there needs to be a submit button that sends the selected name, and location, as well as the date for the following day to an excel document. 

 

If you think you can help please let me know, I have made the basic layout for the app but I cannot figure out how to send over the data. 

 

Thank you for your time.

1 REPLY 1
Power Participant
Power Participant

Can/should they pick a name other than their own? If not,you don't need the drop down. Using the function User().FullName you get the name of the current user and don't need to ask about it. Just set the default value of the datacard to User().FullName instead of the drop down's selected value and then hide it, unless of course you want the user to see it.

 

Have you used the Excel connector and connected the form to that data source?If you have, it's only a matter of calling SubmitForm() in a button's OnSelect.

 

Good luck!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (42,024)