MS Powerapps database

[Lance]

WTFH needs users to update the records and that would require a premium license unless you use something within office (I.e. the sharepoint list that is both slow and crap)

yes as a database it’s expensive but as a rapid development tool you can’t beat it

use Sharepoint for user input, and a logic app to scrape data from that into a blob store??

[eek]

use Sharepoint for user input, and a logic app to scrape data from that into a blob store??

And where is the record that needs to be updated coming from (remember sharepoint doesn’t work)

[thelastrosbif]

Dataverse for Teams with a dataflow that syncs to your CSV Location, preferably Sharepoint Online or OneDrive. That's all built in and costs nothing.

[Lance]

And where is the record that needs to be updated coming from (remember sharepoint doesn’t work)

I thought the performance issue with Sharepoint was for the backend not the user input.

[Lance]

Dataverse for Teams with a dataflow that syncs to your CSV Location, preferably Sharepoint Online or OneDrive. That's all built in and costs nothing.

isn't Dataverse for teams just a PowerApps DB in the background? So same costs? IE. The Teams bit is free but as soon as you fire up a PowerApps environment to run dataverse you have to pay

[thelastrosbif]

[QUOTE=Lance;n4239724]

Nope. Dataverse for teams is a separate teams-based instance of dataverse that incurs zero costs as long as you remain within the limitations given.

The limits are something like:

1 million records
or 2 GB (ish) of storage

Not huge, but for a single records-based app loading csv data its more than adequate.

About the Microsoft Dataverse for Teams environment - Power Platform | Microsoft Learn

[WTFH]

Nope. Dataverse for teams is a separate teams-based instance of dataverse that incurs zero costs as long as you remain within the limitations given.

The limits are something like:

1 million records
or 2 GB (ish) of storage

Not huge, but for a single records-based app loading csv data its more than adequate.

About the Microsoft Dataverse for Teams environment - Power Platform | Microsoft Learn

Unfortunately, we're talking about a database for power apps, not Teams. According to your link:

• For any standalone Power Apps or Power Automate usage, which includes Dataverse API access as well, the Dataverse for Teams environment will need to be upgraded to Dataverse.

[thelastrosbif]

[QUOTE=WTFH;n4239732]

Unfortunately, we're talking about a database for power apps, not Teams. According to your link:

• For any standalone Power Apps or Power Automate usage, which includes Dataverse API access as well, the Dataverse for Teams environment will need to be upgraded to Dataverse.

[/quote

Yes, and thats why you use PowerApps for Teams!

It's the same as PowerApp, but you have to run it from the Teams Window. It's a dumb limitation but it is what it is. It is just as powerful and customisable as a regular powerapp + more, but you just have to get used to running it via Teams. If it saves you $2000 a month though, that's up to you. You can pop-out the Window and make it more full-screen-app-like, and also get access to Fluent UI components which regular canvas apps currently don't.

[eek]

Unfortunately, we're talking about a database for power apps, not Teams. According to your link:



Yes, and thats why you use PowerApps for Teams!

It's the same as PowerApp, but you have to run it from the Teams Window. It's a dumb limitation but it is what it is. It is just as powerful and customisable as a regular powerapp + more, but you just have to get used to running it via Teams. If it saves you $2000 a month though, that's up to you. You can pop-out the Window and make it more full-screen-app-like, and also get access to Fluent UI components which regular canvas apps currently don't.

So how do you get the data from the CSV files into the Dataverse for Teams database? Remember API calls are not allowed because Dataverse for Teams is designed to be self-contained.

Which is why I ruled Dataverse for Teams out in one of my early replies.

Basically, outside of a Sharepoint list there is no way WTFH can avoid the $5 cost of a Power App per user per App licence cost. Because all the plausible escape routes were disabled years ago. And the reason Sharepoint isn't an option isn't because of slowness within sharepoint of the nightly data migration.

One fix regarding that nightly run. Could you have a routine that identifies which CSV records have been changed relative to the previous run so only changes are sent to sharepoint?

[thelastrosbif]

So how do you get the data from the CSV files into the Dataverse for Teams database? Remember API calls are not allowed because Dataverse for Teams is designed to be self-contained.

Which is why I ruled Dataverse for Teams out in one of my early replies.

Basically, outside of a Sharepoint list there is no way WTFH can avoid the $5 cost of a Power App per user per App licence cost. Because all the plausible escape routes were disabled years ago. And the reason Sharepoint isn't an option isn't because of slowness within sharepoint of the nightly data migration.

One fix regarding that nightly run. Could you have a routine that identifies which CSV records have been changed relative to the previous run so only changes are sent to sharepoint?

"Dataflows" are a specific integrated tool in Dataverse and Dataverse for teams, and do not count as an API Call in the sense you use it.

You point the dataflow function at the data source almost exactly the same way as you would with Power BI, in fact it will let you do some basic data transformation in a power query window as part of this process too. As long as the CSV in a simple MS integrated location (OneDrive preferably) it syncs just fine. You could then set auto-refresh using Power automate flows.

Announcing Power Query dataflows for Dataverse in Teams (Preview). | Microsoft Power Apps

Just built and ran a test in my own tenant, a teams powerapp, a DfT table, a dataflow linked to a CSV in my OneDrive, and a refresh flow scheduled daily. Voila, works like a charm