collecting data via Power Apps

baitmaster

Well-known Member
Joined
Mar 12, 2009
Messages
2,042
Good morning all, I've been given the task of setting up a data collection activity via Power Apps, and want to check if this is the best way to go

I have multiple users providing similar KPI data relating to different KPIs. I'll have a simple data table of {Sector, Contract, KPI1 score, KPI2 score... KPIx score}

The issue is to collect accurate data in a simple way, without version control issues or interfering with other Users data. Data security is not a big concern and everyone will be on Teams. The idea is that the User will have a pop-up form where they enter their data, it gets pushed to a database, and then I analyse it with Power BI

Before I waste time learning Power Apps to do this task, is this a good way to go or is there a better way? TIA
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Seems reasonable to me. I think the big thing here is figuring out your database and how you are storing that (i.e. what you use for the database). If you have that straight, then the rest shouldn't be too much of a hassle (coming from a relatively new learner too).
 
Upvote 0
Seems reasonable to me. I think the big thing here is figuring out your database and how you are storing that (i.e. what you use for the database). If you have that straight, then the rest shouldn't be too much of a hassle (coming from a relatively new learner too).
Yeah, database is an issue for a number of reasons... Luckily right after I posted this Microsoft spammed me about free training on Power Apps (Bill Gates is obviously watching me through my new Covid implant!), so I'm getting a free day's crash course next week and can ask the experts, and maybe get it solved as a training case study :D
 
Upvote 0

Forum statistics

Threads
1,223,705
Messages
6,173,996
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top