
Announcements
Hello Team,
Do you have any ideas if we can create a Power App standard table or form that is similar to excel or sharepoint list. Which has 2 columns: Name and Hours and many rows (No Data sources needed). I want to send this table/form to different users to ask them to enter Name and Hours of their team members. Once they click 'Submit', I will use MS flow to capture the information and bring to Sharepoint List (I can work on MS Flow on this). I'm new to Power App so I don't know much about its functionalities.
My purpose is when a new project is built, i will send this table/form to the managers to ask for their resources and estimates hours.
Thank you
Hi @Anonymous
PowerApps can create a temporary table but cannot create or modify the underlying existing structure of a datasource, essentially it is a front end. In PowerApps such a temporary table is referred to as a collection and it only exists during the session. When the program is exited, it ceases to exist.
To use PowerApps, you will need to first create a table or list. My suggestion is to use either SQL, Dataverse or SharePoint to create the table (list in the case of SP). You can do it with an Excel table in OneDrive if you want to practice with PowerApps and see how it works. For most applications that involve more than one user, Excel is not a good choice for production use.