Hi @Rutu1455,
Choosing the right data source for your application is probably the most critical decision you can make when designing a Power App. If you're building a new app that will be transactional in nature and will require relationships between data, you should look at Dataverse. It is highly scalable and suitable even for large and complex enterprise applications.
For simple applications with relatively flat or unstructured data, SharePoint is common and suitable for most simple needs.
If your data is already in a SQL Server database and you want to build a new application on top of that data, Power Apps will work well for this as you don't need to completely overhaul your back end data model.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
