Power Platform Community Forum Thread Details

Hi guys, I'm creating a Purchase requisition app using NAV connector. So far i've been able to design as i want but i'm encountering issues posting line items from the canvas app to the Purchase Requisition Lines in NAV. The Requisition header is posting successfully without any errors but the case is different with the line Items. I've tried using the collect and patch function to do this but still not getting result

Collect(PurchaseRequisitionLine, First(Filter(PurchaseRequisitionLine, Document_No = SelectedReport2.No)),{Purchase_Type:DataCardValue26_3.Selected.Value, Description:DataCardValue29_3.Text, Unit_Cost :Value(DataCardValue27_3.Text), Quantity :Value(DataCardValue27_4.Text)})

Patch(PurchaseRequisitionLine, defaults(PurchaseRequisitionLine), {Purchase_Type:DataCardValue26_6.Selected.Value, Description:DataCardValue29_3.Text, Unit_Cost: Value(DataCardValue27_3.Text), Quantity: Value(QuantityTextInput.Text)})

Patch(PurchaseRequsitionline, LookUp(Document_No =SelectedReport2.No), {Purchase_Type:DataCardValue26_3.Selected.Value, Description:DataCardValue29_3.Text, Unit_Cost :Value(DataCardValue27_3.Text), Quantity :Value(DataCardValue27_4.Text)})

All ideas are welcome...

Categories:

Building Power Apps