Forum Discussion

dgwilson's avatar
dgwilson
Resolver III
8 years ago
Solved

Data Entry for "Users"

I'd like to understand the best technology to capture data. Let me explain.   Firstly, my apologies if this is the wrong area to post this - I could not identify a suitable discussion group.   En...
General Comment
Need Help
  • dgwilson's avatar
    dgwilson
    8 years ago

    Progress update:

     

    My investigations and testing have settled on the following as a data capture solution:

     

    A combination of tools, SharePoint Lists, Power Apps (for the data Entry), and Flow (to copy the existing data and prepopulate).

     

    There are quite a number of youtube videos on Power Apps this search "power apps youtube tutorial" gave a lot.

    Power Apps make mobile apps to get access to your data. They work under windows desktop too.

     

     This guy knows what he's talking about:

    https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng

     

    - David

samdthompson's avatar
samdthompson
Memorable Member
8 years ago

If you are running sharepoint then you could make a list that was filled out by the right people on a weekly basis. You can then access the data in powerbi. If you dont have sharepoint you could you use an excel survey form (onedrive: New/Excel Survey) then point the data connection to the resulting spreadsheet table.

 

Both options require a pro license (I think)

 

Cheers,

 

Sam

 

 

 

// if this is a solution please amrk as such

  • dgwilson's avatar
    dgwilson
    Resolver III
    8 years ago

    Have Sharepoint. Actually seems to have "all the apps". Including PowerApps and Dynamics and Flow ... and quite possibly more. I don't know what their capabilities are or what they are best suited for.

    • samdthompson's avatar
      samdthompson
      Memorable Member
      8 years ago

      I built a simlar sort of setup for reporting (I cant claim its the best one, but i can claim that it works with no hiccups). Setting up a sharepoint list is pretty straight foward as is connecting it as a data source. The nice bit is you can then also start mashing it together with what ever other bits of data you want.  I have not really done anything of note with PowerApps or Flow. I suspect that keeping things as simplae as possible is the best thing though. One thing to keep in mind if say you go down the sharepoint route is whether its being used by your organisation or not. If its not, there might be some additional user training to be done. 

       

      Cheers

       

      Sam

       

       

       

       

      // if this is a solution please mark as such

      • dgwilson's avatar
        dgwilson
        Resolver III
        8 years ago

        I need to do more... I have a SharePoint list and was able to customize the input form.

        This is good. I need more and smarts (like data validation)... Progress is being made ...