Unanswered

Validations for Add Button icon and PO Amount and Remaining PO Amount Calculation down when add one row.

(0) Share

Report

Posted on by Jez1

Validations for Add Button Icons:
1 PO Amount and Remaining PO Amount Calculation:
1.1. When a value is entered in the PO Amount field, it should be reflected in the Remaining PO Amount column.
1.2 As new rows are added, the amount is calculated phase-wise.

2. Example Workflow: If the PO Amount is set to 1000:
1. Adding Row 1 (Phase 1) with an invoice amount of 500 will update the Remaining Charges to 1000.
2. Adding Row 2 (Phase 2) will automatically set the Remaining Charges to 500 (1000 - 500) in the new row with an invoice amount of 500.

How to implement this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jez1 ,

Could you please show some screenshots about your app?

Best regards,

Rimmon

Was this reply helpful? Yes No
Jez1 10 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-mengmli-msft :

I need assistance with implementing validations for an "Add" button in Power Apps. Here’s the scenario:
I have a text field named "POAmount" and a gallery where I can add rows using an "Add" button.
When the "Add" button is clicked, a new collection should be added only if the "POAmount" field has a value.
Each collection in the gallery includes a field called "RemainingPOAmountTextInput". The first row's "RemainingPOAmountTextInput" should initially match the value in the "POAmount" field.
For subsequent rows added via the "Add" button:
The "RemainingPOAmountTextInput" field should only accept a value if an "InvoiceAmount" is entered.
When an "InvoiceAmount" is entered for a row, the "RemainingPOAmountTextInput" for the next row should automatically update by subtracting the "InvoiceAmount" from the previous row's "RemainingPOAmountTextInput".
Could someone please help me with the formula or approach to achieve this in Power Apps? Thank you!
these are my rows name:
Patch(
CMSRequestDetails,
Defaults(CMSRequestDetails),
{
Comments: CommentsTextBox.Text,
PoAmount: Value(PoAmountTextBox.Text),
InvoiceAmount: Value(InvoiceAmountTextBox.Text),
InvoiceDueDate: InvoiceDueDateDatePicker.SelectedDate,
ProceedDate: ProceedDateDatePicker.SelectedDate,
EmailBody: EmailBodyTextBox.Text
}
);

Was this reply helpful? Yes No
Jez1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mengmli-msft : THERE?

Was this reply helpful? Yes No