Answered

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

(0) Share

Report

Posted on by Applications

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?

At the moment the collection posts to this SharePoint List:

And the Text Input Boxes post to this SharePoint List:

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:

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)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Applications on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Applications on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Applications on at

Like (0)

Report
Copy link

Link copied!

The first one worked, thank you so much!

Was this reply helpful? Yes No