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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,795)