Notifications
Announcements
I am creating an application that it generates an excel for printing and storage.
But I would like to know if there is any way to create a new list in SharePoint or a new excel file, by clicking on a button or some other type of action, to start putting the data in the new list for the end users.
@Gorilla_8
Not directly in PowerApps.
You could utilize PowerAutomate to instantiate new lists for files, but this would not be meaningful in PowerApps as you MUST supply the datasources in your app design in order for PowerApps to use it.
I hope this is helpful for you.
@RandyHayes
Thanks for the help!
I know that I MUST provide a connection on PowerApps, however I would like some way to let one list be finalized, and would initialize another list for adding data, and always like this, continuously.
Yes, you'll not be able to do that in PowerApps (switch datasource during play).
The best you might be able to come up with is a standard datasource that PowerApps will use and perhaps PowerAutomate to "shuffle" around the data to other lists from that, but, always maintaining that standard datasource for the app.
Yeah, I agree with you, I thought of it that way too.
My idea would be to reset the default list and leave that list "aside" to save later and check.
But I would like a way to or separate various data in different spreadsheets in Excel, or in SharePoint, some way to separate the data.
Yep, an intermediate list/table would be about the only way to achieve it.
Thanks
But I cannot do this, because the application administrator will check her items before finalizing. In the meantime, another list would be added to start the new data creation step to check later.
Wouldn't there be a way to separate the sharepoint when exported to excel in different "tabs", or a filter, or something like that?
I would reconsider the need for separate lists at all then based on that last statement. It seems that there is a "data creation step" that you have. If that is the case, then you should have such a column that indicates the data creation step in it. This way you can filter based on that value - app admin can check items for data creation step X while another set of records can be being created for data creation step X+1
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
