Queries related to PowerApps with SharePoint

Dear @Kapil Jindal,

Thank you for reaching out to Microsoft Q&A forum.

Correct me if I’m wrong, but I understand you want to create an app through Copilot without using Dataverse. Based on my research, the default Copilot "Start with Data" wizard is designed to promote Dataverse as the primary relational database for Power Platform. When you ask Copilot to build an app from your SharePoint list, it often attempts to migrate that data into a Dataverse table first in order to utilize advanced features like role-based security and relational mapping.

However, you can absolutely build a Power App using only a SharePoint list as the data source, with no Dataverse required. Typically, this would be a Canvas app connected to your SharePoint list. Instead of using the main Copilot chat box, you can follow the dedicated SharePoint path:

• Open your list in SharePoint (or Microsoft Lists).
• Select the three dots next to Forms, then go to Integrate > Power Apps > Create an app.
• Power Apps Studio will open with an auto-generated app (typically 3 screens).
• Save and publish the app.

Alternatively, you can create the app directly in Power App:

On the Power Apps home page:

• Select Start with Data.
• Choose SharePoint.
• Select your Site and List.
• Power Apps will generate a three-screen app in Power Apps Studio, where you can design, build, and manage the app. You can use Copilot to assist with formula generation.

For reference: Create a canvas app with data from a list - Power Apps | Microsoft Learn

I hope this information is helpful and provides you with a clear path forward. Should you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you. I'm looking forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.