cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OsmandFernando
Post Prodigy
Post Prodigy

How to create an invoice interface from power apps

Hi, 

 

I am developing an app using sharepoint lists. I have 2 lists as follows, 

  • SalesTable
  • SalesDetailsTable

Under the Sales table I have basic information such as, Invoice number, date, Customer. Under the Sales Details Table I have model no, Item name, qty, unit price and Total (this is a calculated column). 

 

For the invoice number in Sales Details Table, I have a look up from Sales Table and established a relationship as well. 

 

What I want is to design a screen where I can input Invoice data with mutiple items in the Invoice. Based on my knowledge I designed forms, to display and edit but I can only input one item at a time. But what I want is, I should be able to enter mutiple Items, qty, price in the same invoice. Kindly I need your support

 

Thank you in advance

Osmand Fernando from Sri Lanka 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @OsmandFernando ,

Could you please share a bit more about your scenario?

Do you want to add multiple Invoice data back to your SP List once time?

 

Based on the needs that you mentioned, I think the Gallery control could achieve your needs. You could consider add a Gallery conrol in your app, then configure it as a Editable Grid, then you could multiple entries once time, then save them back to your SP List at the same time.

Please check and see if the following video would help in your scenario:

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

https://www.youtube.com/watch?v=41Mpgn7svLs&t=1s

 

In addition, I also think the Repating Table sample scenario provided by @Shane Young would help in your scenario:

https://www.youtube.com/watch?v=xgznk4XlPCo&t=66s

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

https://www.youtube.com/watch?v=HUX_0AA4-Hs

 

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

6.JPG3.JPG4.JPG5.JPGSet the OnStart property of the App to following:

ClearCollect(EntryColelction, 1)

 

set the OnSelect property of the "+" button to following:

Collect(EntryColelction,1)

set the OnSelect property of the "Patch" button to following:

ForAll(
Gallery1.AllItems,
Patch(
RecordsTable,
Defaults(RecordsTable),
{
ModelNo: TextInput1.Text,
ItemName: TextInput2.Text,
QTY: TextInput3.Text,
UnitPrice: TextInput4.Text
}
)
)

On your side, you may need to type:

ForAll(
       Gallery1.AllItems, 
       Patch(
             'YourSPList', 
             Defaults('YourSPList'), 
             {
              ModelNo: TextInput1.Text, 
              ItemName: TextInput2.Text, 
              QTY: TextInput3.Text, 
              UnitPrice: TextInput4.Text
             }
       )
)

Please take a try with above solution, then check if the issue is solved.

 

Best regards,

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

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @OsmandFernando ,

Could you please share a bit more about your scenario?

Do you want to add multiple Invoice data back to your SP List once time?

 

Based on the needs that you mentioned, I think the Gallery control could achieve your needs. You could consider add a Gallery conrol in your app, then configure it as a Editable Grid, then you could multiple entries once time, then save them back to your SP List at the same time.

Please check and see if the following video would help in your scenario:

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

https://www.youtube.com/watch?v=41Mpgn7svLs&t=1s

 

In addition, I also think the Repating Table sample scenario provided by @Shane Young would help in your scenario:

https://www.youtube.com/watch?v=xgznk4XlPCo&t=66s

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

https://www.youtube.com/watch?v=HUX_0AA4-Hs

 

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

6.JPG3.JPG4.JPG5.JPGSet the OnStart property of the App to following:

ClearCollect(EntryColelction, 1)

 

set the OnSelect property of the "+" button to following:

Collect(EntryColelction,1)

set the OnSelect property of the "Patch" button to following:

ForAll(
Gallery1.AllItems,
Patch(
RecordsTable,
Defaults(RecordsTable),
{
ModelNo: TextInput1.Text,
ItemName: TextInput2.Text,
QTY: TextInput3.Text,
UnitPrice: TextInput4.Text
}
)
)

On your side, you may need to type:

ForAll(
       Gallery1.AllItems, 
       Patch(
             'YourSPList', 
             Defaults('YourSPList'), 
             {
              ModelNo: TextInput1.Text, 
              ItemName: TextInput2.Text, 
              QTY: TextInput3.Text, 
              UnitPrice: TextInput4.Text
             }
       )
)

Please take a try with above solution, then check if the issue is solved.

 

Best regards,

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

OsmandFernando
Post Prodigy
Post Prodigy

Thank you so much

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (921)