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)
Solved! Go to Solution.
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
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:
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!
User | Count |
---|---|
160 | |
91 | |
68 | |
64 | |
63 |
User | Count |
---|---|
210 | |
157 | |
93 | |
81 | |
71 |