Power Platform Community Forum Thread Details

Hello,

In my PowerApp, I am trying to record data from collection as below:

Screen1: I am collecting data in collection called "Shoppingcart".

Screen2: Now I have selected products with specifications in my cart shown with Gallery and "Text Input" box to insert quantity (using patch function to enter quantity in collection called "Shoppingcart" )

Screen3: Overview of selected products with quantity. final "Shoppingcart".

on screen 3, I have a button to submit this order (record data in CDS Table "PlacedOrder").

I have tried 2 formulas as below but it did not worked. (Column name and type is exact same in Collection "Shoppingcart" & CDS Table "PlacedOrder" )

Formula 1:

ForAll(
Shoppingcart,
Patch(
PlacedOrder,
Defaults(PlacedOrder),
{
ID: RPNr_1.Text,
Beschreibung: Beschreibung11.Text,
BestellteMenge: BestellteMenge_1,
Customer: UserName1_2.Text,
}
)
)

Formula 2:

Collect (PlacedOrder, Shoppingcart)

Could you please help me to solve this problem.

Thank you very much!!

Categories:

Building Power Apps

I don't know how your form is set up, so this may not work for you. I have an Entry Form and I wanted to write it to a staging table in SQL. I created a Stored Procedure in SQL and using Power Automate called it from the Save button.

StoredProcWasteDiversionInsertPreLoadData.Run(
 If(IsBlank(CategoryIdSelected.SelectedText.Value),"NULL", CategoryIdSelected.SelectedText.Value),
 If(IsBlank(CharityId.SelectedText.Value),"NULL", CharityId.SelectedText.Value),
 If(IsBlank(ClientId.SelectedText.Value),"NULL", ClientId.SelectedText.Value),
 DateSelected.SelectedDate,
 If(IsBlank(Dollars.Text),0, Dollars.Text),
 If(IsBlank(EventId.Text),0, EventId.Text),
 If(IsBlank(LocationId.SelectedText.Value),"NULL", LocationId.SelectedText.Value),
 If(IsBlank(SubCategoryId.SelectedText.Value),"NULL", SubCategoryId.SelectedText.Value),
 If(IsBlank(Units.Text),0, Units.Text),
 If(IsBlank(WeightTons.Text),0, WeightTons.Text)
 
);
Notify(
 "Successfully Submitted",
 Success
)

Screenshot 2022-04-01 Waste Diversion Form.png