cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus
Level: Powered On

Collect data from many datafields, how to best do this?

What is best practice on how to solve this?

 

I have a need of collecting lots of data at once. I want a person to report how many hours he/she have worked during a day over a period of month. Then a 3-4 questions to each day he reports workhours on.

 

My datasource will be a sharepoint list

I have setup the list and i have now opened a form trying to build the form. But since it is over 60 datacards in the form it is hard to make it good looking and easy to work with.

The form is quite slow and clumsy..

 

Is there a better way to build a form and collect data like this.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Collect data from many datafields, how to best do this?

Hi @Oskarkuus ,

Do you mean that if you display all the fields in one form, the form will be quite slow and clumsy?
To improve this, I suggest you split the fields to several forms and one form display in one screen.

After you fill in form1, you could click "next", then you will navigate to form2, fill in form2, click"next", navigate to form3,...

I've made a similar test for your reference:

I split all the fields to three forms, you could split to more forms

1)in screen1, insert form1, a next button

in screen2, insert form2, a next button

in screen3, insert form3, a submit button

Set all the forms to the same data source.

in form1, choose field1-field10

in form2, choose field11-field20

in form3, choose field21-field30

11132.PNG

 

2)set next button1's OnSelect:

Navigate(Screen2,None)

set next button2's OnSelect:

Navigate(Screen3,None)

set submit button's OnSelect:

Patch(table,Defaults(table),form1.Updates,form2.Updates,form3.Updates)

 

Then, if you click the button in screen3, it will submit data in three forms together.

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Collect data from many datafields, how to best do this?

@Oskarkuus
Wow, 60 datacards in a single form is quite long! I am trying to imagine how you have setup the data form to collect information from your company's employees. Are you trying to collect an entire week or month of information all at once?

If you can share a screenshot of your current form I am sure a forum member or myself will be able to suggest a different way of designing the form. Make sure to blackout any sensitive information (or use dummy data instead).
Community Support Team
Community Support Team

Re: Collect data from many datafields, how to best do this?

Hi @Oskarkuus ,

Do you mean that if you display all the fields in one form, the form will be quite slow and clumsy?
To improve this, I suggest you split the fields to several forms and one form display in one screen.

After you fill in form1, you could click "next", then you will navigate to form2, fill in form2, click"next", navigate to form3,...

I've made a similar test for your reference:

I split all the fields to three forms, you could split to more forms

1)in screen1, insert form1, a next button

in screen2, insert form2, a next button

in screen3, insert form3, a submit button

Set all the forms to the same data source.

in form1, choose field1-field10

in form2, choose field11-field20

in form3, choose field21-field30

11132.PNG

 

2)set next button1's OnSelect:

Navigate(Screen2,None)

set next button2's OnSelect:

Navigate(Screen3,None)

set submit button's OnSelect:

Patch(table,Defaults(table),form1.Updates,form2.Updates,form3.Updates)

 

Then, if you click the button in screen3, it will submit data in three forms together.

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Oskarkuus
Level: Powered On

Re: Collect data from many datafields, how to best do this?

Yeah it is an undertaking 😛

 

I have a paperform today where employee that get salary by reporting how many hours they work each day need to fill. This paperform need to be filled every month and handed to their boss.

 

I want to get rid of the paperform and have a digital way for the employee to create this form and collect data of how many hours they have worked during a month.

 

So i have built now an app where the user create one report per month. It is posible to fill in data each day in a report (record) by just editing. When the month is over the employee "signs" and locks the report (record) and then i have a flow that sends the data to the boss for his signature and then he can send it to the bank (kind of).....

 

This is how a form looks like. I want to record 3 fields per day during a month. Time you started working. Time you ended working and how many hours that is
So i have created One form per day and then patch them together.
Screenshot: https://prnt.sc/q26fnw

Im far from done. Not sure how this will work out... but since it is so much data that is needed in many different fields.... a simple paperform becomes a huge effort to make a bit more modern and digital 🙂

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,169)