Power Platform Community Forum Thread Details

Dear Community,

I am trying to create a total for credit column within gallery. But not able to

Refresh(Pricing_Error_Request);
ResetForm(SharePointForm1);
Set(_FormMode, "View");
Clear(ProjectItem);
Clear(ProjectItem2);
Clear(ProjectItem3);
Clear(ProjectItem4);
Clear(_itemColumns);
//Clear(_items);

Set(spinner, true);

Set(CurrentItem , LookUp(Pricing_Error_Request , ID = SharePointIntegration.SelectedListItemID));
Set(CanEditItem,(CurrentItem.Status.Value = "Rejected" || _FormMode = "New" || CurrentItem.Status.Value = "Draft" ));
/*Set(CanEditItem,((CurrentItem.Status.Value = "Rejected" && _FormMode = "View") || _FormMode = "New" || (CurrentItem.Status.Value = "Draft" && _FormMode = "View") ));*/


Set(_discount,LookUp(PRConfig,'Configuration ID'="1",'Configuration Value'));
ClearCollect(_InvoiceDetails , GetInvoiceDetail.Run(CurrentItem.InvoiceNo)
.'soapenv:Envelope'.'soapenv:Body'.'NS1:GetInvoiceDetailResponse'.LINEITEMS.INVOICE_DETAILS);



/*New code */
//collect all items'
//ClearCollect(_AllItemsColumn , Split(CurrentItem.AllItems, _rowDelim));
ClearCollect(_AssortmentKeyColumn , ForAll(Split(CurrentItem.AssortmentKey, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_AssortmentKeyDescColumn , ForAll(Split(CurrentItem.AssortmentKeyDesc, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_SKUColumn , ForAll(Split(CurrentItem.SKU, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_ProductLineDescColumn , ForAll(Split(CurrentItem.ProductLineDesc, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_TotalInvoicedAmountColumn , ForAll(Split(CurrentItem.TotalInvoicedAmount, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_InvoicedPriceColumn , ForAll(Split(CurrentItem.InvoicedPrice, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_AdjustedPriceColumn , ForAll(Split(CurrentItem.AdjustedPrice, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_InvoicedQtyColumn , ForAll(Split(CurrentItem.InvoicedQty, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_CreditColumn , ForAll(Split(CurrentItem.Credits, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_CreditQtyColumn , ForAll(Split(CurrentItem.CreditQty, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_SubstitutionItemColumn , ForAll(Split(CurrentItem.SubstitutionItem, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_SubstitutionItemPriceColumn , ForAll(Split(CurrentItem.SubstitutionItemPrice, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_InvoicedTaxColumn , ForAll(Split(CurrentItem.InvoicedTax, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_TaxPercentageColumn , ForAll(Split(CurrentItem.TaxPercentage, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_TaxCreditColumn , ForAll(Split(CurrentItem.TaxCredit, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_AdditionalDiscountPriceColumn , ForAll(Split(CurrentItem.AdditionalDiscountPrice, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_AdditionalDiscountPercentageColumn , ForAll(Split(CurrentItem.AdditionalDiscountPercentage, _rowDelim), {Result: ThisRecord.Value}));
ClearCollect(_TotalDiscountPriceColumn , ForAll(Split(CurrentItem.TotalDiscountPrice, _rowDelim), {Result: ThisRecord.Value}));

Clear(_itemColumns);
ClearCollect(_ItemCount , Sequence(CountRows(_SKUColumn)));

If(
 CurrentItem.PricingScenario in ["Adjusted Quotation", "On Demand Programs", "Pricing Groups"],

 ForAll(_ItemCount , 
 Collect(_itemColumns ,
 {
 ProjectSerialNumber: Text(ThisRecord.Value),
 ProjectAssortmentKey: Last(FirstN(_AssortmentKeyColumn,ThisRecord.Value)).Result,
 ProjectAssortmentKeyDesc: Last(FirstN(_AssortmentKeyDescColumn,ThisRecord.Value)).Result,
 ProjectSKU: Last(FirstN(_SKUColumn,ThisRecord.Value)).Result,
 ProjectProductLineDesc: Last(FirstN(_ProductLineDescColumn,ThisRecord.Value)).Result,
 ProjectTotalInvoicedAmount: Last(FirstN(_TotalInvoicedAmountColumn,ThisRecord.Value)).Result,
 ProjectInvoicedPrice: Last(FirstN(_InvoicedPriceColumn,ThisRecord.Value)).Result,
 ProjectAdjustedPrice: Last(FirstN(_AdjustedPriceColumn,ThisRecord.Value)).Result,
 ProjectInvoicedQty: Last(FirstN(_InvoicedQtyColumn,ThisRecord.Value)).Result,
 ProjectCredit: Last(FirstN(_CreditColumn,ThisRecord.Value)).Result
 
 }
 )
 );
 ClearCollect(ProjectItem , _itemColumns),

 CurrentItem.PricingScenario in ["Display", "Model Home"],

 ForAll(_ItemCount , 
 Collect(_itemColumns ,
 {
 ProjectSerialNumber: Text(ThisRecord.Value),
 ProjectSKU: Last(FirstN(_SKUColumn,ThisRecord.Value)).Result,
 ProjectProductLineDesc: Last(FirstN(_ProductLineDescColumn,ThisRecord.Value)).Result,
 ProjectTotalInvoicedAmount: Last(FirstN(_TotalInvoicedAmountColumn,ThisRecord.Value)).Result,
 ProjectInvoicedPrice: Last(FirstN(_InvoicedPriceColumn,ThisRecord.Value)).Result,
 ProjectPerDiscount: Last(FirstN(_AdditionalDiscountPriceColumn,ThisRecord.Value)).Result,
 ProjectAdditionalDiscount: Last(FirstN(_AdditionalDiscountPercentageColumn,ThisRecord.Value)).Result,
 ProjectTotalDiscountPrice: Last(FirstN(_TotalDiscountPriceColumn,ThisRecord.Value)).Result,
 ProjectInvoicedQty: Last(FirstN(_InvoicedQtyColumn,ThisRecord.Value)).Result,
 ProjectCreditQty: Last(FirstN(_CreditQtyColumn,ThisRecord.Value)).Result,
 ProjectCredit: Last(FirstN(_CreditColumn,ThisRecord.Value)).Result
 
 }
 )
 );
 ClearCollect(ProjectItem2 , _itemColumns),

 CurrentItem.PricingScenario in ["Substitution"],

 ForAll(_ItemCount , 
 Collect(_itemColumns ,
 {
 ProjectSerialNumber: Text(ThisRecord.Value),
 ProjectSKU: Last(FirstN(_SKUColumn,ThisRecord.Value)).Result,
 ProjectProductLineDesc: Last(FirstN(_ProductLineDescColumn,ThisRecord.Value)).Result,
 ProjectTotalInvoicedAmount: Last(FirstN(_TotalInvoicedAmountColumn,ThisRecord.Value)).Result,
 ProjectInvoicedPrice: Last(FirstN(_InvoicedPriceColumn,ThisRecord.Value)).Result,
 ProjectSubstitutionItem: Last(FirstN(_SubstitutionItemColumn,ThisRecord.Value)).Result,
 ProjectSubstitutionItemPrice: Last(FirstN(_SubstitutionItemPriceColumn,ThisRecord.Value)).Result,
 ProjectInvoicedQty: Last(FirstN(_InvoicedQtyColumn,ThisRecord.Value)).Result,
 ProjectCreditQty: Last(FirstN(_CreditQtyColumn,ThisRecord.Value)).Result,
 ProjectCredit: Last(FirstN(_CreditColumn,ThisRecord.Value)).Result
 
 }
 )
 );
 ClearCollect(ProjectItem3 , _itemColumns),

 CurrentItem.PricingScenario in ["Tax Credit"],

 ForAll(_ItemCount , 
 Collect(_itemColumns ,
 {
 ProjectSerialNumber: Text(ThisRecord.Value),
 ProjectSKU: Last(FirstN(_SKUColumn,ThisRecord.Value)).Result,
 ProjectProductLineDesc: Last(FirstN(_ProductLineDescColumn,ThisRecord.Value)).Result,
 ProjectTotalInvoicedAmount: Last(FirstN(_TotalInvoicedAmountColumn,ThisRecord.Value)).Result,
 ProjectInvoicedPrice: Last(FirstN(_InvoicedPriceColumn,ThisRecord.Value)).Result,
 ProjectInvoicedTax: Last(FirstN(_InvoicedTaxColumn,ThisRecord.Value)).Result,
 ProjectTaxPercentage: Last(FirstN(_TaxPercentageColumn,ThisRecord.Value)).Result,
 ProjectTaxCredit: Last(FirstN(_TaxCreditColumn,ThisRecord.Value)).Result
 
 }
 )
 );
 ClearCollect(ProjectItem4 , _itemColumns);
);


EditForm(SharePointForm1);
Set(spinner, false);

//within gallery, I have a text input to calculate the default value of credit as Value(ThisItem.ProjectCreditQty) * Value(ThisItem.ProjectTotalDiscountPrice)

Categories:

Building Power Apps