cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Applications
Helper IV
Helper IV

Possible to Have A Collection and Text Input Boxes Post to One SharePoint List?

Good morning! I have a PowerApp that is working quite well in and of itself, but at the moment it's posting to two different SharePoint lists, with the thought of trying to use PowerAutomate to combine two SharePoint lists together. Is there a way to forego that altogether within PowerApps? 

 

Applications_1-1654783364980.png

 

At the moment the collection posts to this SharePoint List:

Applications_2-1654783405026.png

And the Text Input Boxes post to this SharePoint List:

Applications_3-1654783443476.png

 

But I would like to forego the PowerAutomate step of the process and just have both of those elements post to this SharePoint List instead:

Applications_4-1654783495746.png

 

Is this possible? Thanks!

 

Edit: Here is my formula for it to post:

 

Set(varRecordID, Patch('Shopping Cart Orders', Defaults('Shopping Cart Orders'), {Title: Name.Text, 'Building Location': Building.Text, 'Seat Location': Seat.Text, Email: Email.Text, 'Phone Number': Phone.Text}).ID); Collect('Shopping Cart Ordered Items 2', AddColumns(colUserShoppingCart, "OrderID", varRecordID)); Reset(Name); Reset(Building); Reset(Seat); Reset(Email); Reset(Phone); Clear(colUserShoppingCart); Navigate(Screen2)

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Applications ,

 

Please try:

Collect(
  'Full Inventory Order', 
   AddColumns(
   colUserShoppingCart, 
   "OrderID",
   varRecordID
   "Building Location",
   Building.Text,
   "Seat Location",
   Seat.Text,
   "Email",
   Email.Text,
   "Phone Number",
   Phone.Text
   )
); 
Reset(Name); 
Reset(Building); 
Reset(Seat); 
Reset(Email); 
Reset(Phone); 
Clear(colUserShoppingCart); 
Navigate(Screen2)

or

Collect(
  'Full Inventory Order', 
   ForAll(
    AddColumns(
    colUserShoppingCart, 
    "OrderID",
    varRecordID
    ),Patch(ThisRecord,{Title: Name.Text, 'Building Location': Building.Text, 'Seat Location': Seat.Text, Email: Email.Text, 'Phone Number': Phone.Text}))
); 
Reset(Name); 
Reset(Building); 
Reset(Seat); 
Reset(Email); 
Reset(Phone); 
Clear(colUserShoppingCart); 
Navigate(Screen2)

 

Best Regards,

Bof

View solution in original post

4 REPLIES 4
Applications
Helper IV
Helper IV

When changing the formula to this:

 

Set(varRecordID, Patch('Full Inventory Order', Defaults('Full Inventory Order'), {Title: Name.Text, 'Building Location': Building.Text, 'Seat Location': Seat.Text, Email: Email.Text, 'Phone Number': Phone.Text}).ID); Collect('Full Inventory Order', AddColumns(colUserShoppingCart, "OrderID", varRecordID)); Reset(Name); Reset(Building); Reset(Seat); Reset(Email); Reset(Phone); Clear(colUserShoppingCart); Navigate(Screen2)

 

This was the result when posting:

Applications_0-1654784139389.png

 

Applications
Helper IV
Helper IV

Anybody have any thoughts on how to accomplish this, or if it's even doable? Thank you!

Hi @Applications ,

 

Please try:

Collect(
  'Full Inventory Order', 
   AddColumns(
   colUserShoppingCart, 
   "OrderID",
   varRecordID
   "Building Location",
   Building.Text,
   "Seat Location",
   Seat.Text,
   "Email",
   Email.Text,
   "Phone Number",
   Phone.Text
   )
); 
Reset(Name); 
Reset(Building); 
Reset(Seat); 
Reset(Email); 
Reset(Phone); 
Clear(colUserShoppingCart); 
Navigate(Screen2)

or

Collect(
  'Full Inventory Order', 
   ForAll(
    AddColumns(
    colUserShoppingCart, 
    "OrderID",
    varRecordID
    ),Patch(ThisRecord,{Title: Name.Text, 'Building Location': Building.Text, 'Seat Location': Seat.Text, Email: Email.Text, 'Phone Number': Phone.Text}))
); 
Reset(Name); 
Reset(Building); 
Reset(Seat); 
Reset(Email); 
Reset(Phone); 
Clear(colUserShoppingCart); 
Navigate(Screen2)

 

Best Regards,

Bof

The first one worked, thank you so much!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,941)