cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

what's the best option to Build this app ?

Hello

 

I am reasonably well with PowerBI but 0 experience with PowerApps.

 we have requirement for new business app. 

 1 Table with some existing data and the user need to input new fields, data completed and comments

  • The user can not add new rows just edit those two fields
  • Row level security, users see only rows assigned to them
  • I need to have the option to access that data from PowerBI for reporting
  • I need to see when the edits were done and by whom
  • The total rows should be around 3000 and maybe 40 users

We have Office 365 E5 and extra license for PowerApps should not be a problem,

What do recommend, should we use CDS or a SQL server , canvas or model driven, the app is internal only

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Hi @mim ,

 

I would recommend to use the following options

 

1. Dataset: SharePoint list

- The data record limit on SharePoint is 5000 records but your business requirement is 3000 records which is good

- The SharePoint list is eligible for standard license which is included in E5 license

- CDS or a SQL server require Premium license that should be paid license (PowerApps App plan or User plan)

 

2. Canvas App in PowerApps

- The Canvas App can create CRUD(Create/Read/Update/Delete) from the SharePoint list (In your business scenario, remove the Create feature in the form)

- After receiving the SharePoint list collection(dataset), using filter expression, it shows right records only based on current logged on user

- Using form submission or PATCH expression, the user may update the SharePoint list item correctly and the list fields has "Modified by" field that shows who updated the field

 

3. SharePoint list data is fully supported for Power BI

 

 

Hope this helps. Thanks!

Best regards,

Jisung Han

View solution in original post

1 REPLY 1
Microsoft
Microsoft

Hi @mim ,

 

I would recommend to use the following options

 

1. Dataset: SharePoint list

- The data record limit on SharePoint is 5000 records but your business requirement is 3000 records which is good

- The SharePoint list is eligible for standard license which is included in E5 license

- CDS or a SQL server require Premium license that should be paid license (PowerApps App plan or User plan)

 

2. Canvas App in PowerApps

- The Canvas App can create CRUD(Create/Read/Update/Delete) from the SharePoint list (In your business scenario, remove the Create feature in the form)

- After receiving the SharePoint list collection(dataset), using filter expression, it shows right records only based on current logged on user

- Using form submission or PATCH expression, the user may update the SharePoint list item correctly and the list fields has "Modified by" field that shows who updated the field

 

3. SharePoint list data is fully supported for Power BI

 

 

Hope this helps. Thanks!

Best regards,

Jisung Han

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

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

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (45,080)