PowerApps as a Business Maintained Table Solution ? Need Suggestions

[smohapatra1984]

Hi ,

I am a new user of Power Apps and need some inputs from this forum to impement a Business Maintained Table(BMT) Solution. We have an existing solution in place which use Access Web App in Sharepoint, which takes business inputs and then ttrasfer the data to Azure SQL DW. As per current communication it Access Web App is going to get retired soon and Microsoft is suggesting the use of Power Apps Instead. 

But when I tried using Power Apps , I found a few features  which Access Web App was giving me is not the same in Power Apps(Or May be I am not aware of how to implement the same , hence need inputs)

1) Allowing multiple users to edit the data at the same time without locking. Access Web App didn't have any issues with this but Power APP is locking the screen when one user is editing the data. the other user is not even able to see the data.

2) Access web app was user friendly in terms of we can copy and paste data into the form. But I am not getting any option how to insert bulk data into existing screen. It only allows me to edit one by one which will be tedious when we enter bulk data.

I have to ultimately consume the data into azure and then Power BI with user friendly screens for business users to enter data into BMT.

Please provide your valuable inputs on the above points if you have implemented any such solution or any idea how to do ?

Regards,

Shakti

[v-micsh-msft]

Hi @smohapatra1984,

Well, didn't aware the editing lock under PowerApps, I will make some tests on that. From my opinion, I think the edit locking should be mostly related with the data source.

For issue 2, see here:

Useful features of PowerApps, Multiple records adding / Editing

Regards,

Michael

[smohapatra1984]

@v-micsh-msft,

Thanks for your reply. I will take a look at the stated link.

Regards,

Shakti

[smohapatra1984]

Hi @v-micsh-msft ,

I still didn't get how to do bulkcopy for existing app. Is there any import option frome excel ?? Also please let me know how multiple persons can insert data at same time. Here end users are business folks , hence they are not familiar with any technical coding if required for cooying multiple records.

Regards,

Shakti