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

Order form to be able to order multiple items

I am trying to create an app that allows our staff to order stationery.  The app is connected to a sharepoint list.  Just now the user can complete an order form for 1 item then submit, but there are likely to be times when they want to order more than one item at a time.

 

Is there a way that this can be done?  I was thinking they press a button to add a new line but i really have no idea what i'm doing and any advice would be great?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Order form to be able to order multiple items

Hi @neill_long,

 

Do you want to add multiple orders within your app at the same time?

 

I agree with @Drrickryp's thought almost, I think the following video would help in your scenario:

https://www.youtube.com/watch?v=xgznk4XlPCo

 

You could consider take a try to create a Label control or TextInput control (or other controls) for each column in your SP list within a Gallery control (instead of using Edit form control).

 

I have created a SP list on my side, the data structure as below:10.JPG

I have made a test on my side, please take a try with the following workaround:11.JPG

 

12.JPG

 

Set the OnVisible property of the first screen of my app to following formula:

ClearCollect(OrderCount,1)

Set the Items property of the Gallery control (Gallery1) to following:

OrderCount

Set the OnSelect property of the "New Order" button to following formula:

Collect(OrderCount,CountRows(OrderCount)+1)

Set the OnSelect property of the "Upload" button to following formula:

ForAll(
Gallery1.AllItems,
Patch(
'20180918_case9',
Defaults('20180918_case9'),
{
Title:"PowerApps Test",
Product_x0020_Name:TextInput1.Text,
Price:Value(TextInput2.Text),
Executor:TextInput3.Text
}
)
)

Note: The '20180918_case9' represents the SP list data source within my app.

 

On your side, you should type the following formula:

ForAll(
Gallery1.AllItems,
Patch(
'YourSPList',
Defaults('YourSPList'),
{
Title:"PowerApps Test",
Column1:TextInput1.Text,
Column2:TextInput2.Text,
Column3:TextInput3.Text,
...
}
)
)

 

The GIF screenshot as below:Test1.gif

 

 

 

More details about Patch function in PowerApps, please check the following article:

Patch function

 

Best regards,

Kris

Community Support Team _ Kris Dai
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: Order form to be able to order multiple items

Hi @neill_long,

 

It sounds like you would like something like repeating tables in your gallery.  This is a feature that was popular in Infopath forms.  Shane Young has a great video explaining how to do this.  Please check out https://www.youtube.com/watch?v=xgznk4XlPCo.  There are some other ways to do this using Forms but I think Shane's approach is the best.  

Highlighted
Community Support Team
Community Support Team

Re: Order form to be able to order multiple items

Hi @neill_long,

 

Do you want to add multiple orders within your app at the same time?

 

I agree with @Drrickryp's thought almost, I think the following video would help in your scenario:

https://www.youtube.com/watch?v=xgznk4XlPCo

 

You could consider take a try to create a Label control or TextInput control (or other controls) for each column in your SP list within a Gallery control (instead of using Edit form control).

 

I have created a SP list on my side, the data structure as below:10.JPG

I have made a test on my side, please take a try with the following workaround:11.JPG

 

12.JPG

 

Set the OnVisible property of the first screen of my app to following formula:

ClearCollect(OrderCount,1)

Set the Items property of the Gallery control (Gallery1) to following:

OrderCount

Set the OnSelect property of the "New Order" button to following formula:

Collect(OrderCount,CountRows(OrderCount)+1)

Set the OnSelect property of the "Upload" button to following formula:

ForAll(
Gallery1.AllItems,
Patch(
'20180918_case9',
Defaults('20180918_case9'),
{
Title:"PowerApps Test",
Product_x0020_Name:TextInput1.Text,
Price:Value(TextInput2.Text),
Executor:TextInput3.Text
}
)
)

Note: The '20180918_case9' represents the SP list data source within my app.

 

On your side, you should type the following formula:

ForAll(
Gallery1.AllItems,
Patch(
'YourSPList',
Defaults('YourSPList'),
{
Title:"PowerApps Test",
Column1:TextInput1.Text,
Column2:TextInput2.Text,
Column3:TextInput3.Text,
...
}
)
)

 

The GIF screenshot as below:Test1.gif

 

 

 

More details about Patch function in PowerApps, please check the following article:

Patch function

 

Best regards,

Kris

Community Support Team _ Kris Dai
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

neill_long
Level: Powered On

Re: Order form to be able to order multiple items

Hi

 

I've had a go at the steps you outlined @v-xida-msft and i am half way there.

 

I am having difficulty with the Upload side of things.  I have amneded the details of the patch function to this:

 

ForAll(
   Gallery2.AllItems,
   Patch(
      'Testing',
       Defaults('Testing'),
       {
        Title:"PowerApps Test",
        Date_x0020_of_x0020_Request: DatePicker1.SelectedDate,
        StaffName: Dropdown2.Selected.Value,
Quantity: Value(TextInput7.Text),    
        Item: Dropdown1.Selected.Value,
       ...
       }
    )
)

The SP list is called Testing. 

 

 

I have changed the fields from textinput, one is a datepicker, two fields are dropdowns which get their items from the datasource 'Testing'.  Not sure if this makes any difference.  Do the fields have to be TextInput?

 

Capture.PNG

 

Here is a screenshot of the SP List:

 

Capture2.PNG

Any advice on where i may have gone wrong would be appreciated.

 

thanks

Alistair

Helpful resources

Announcements
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,014)