Override VAT amount

[Wendy3]

I have built a power app which the user inputs data and in the VAT box it automatically calculates at 20% VAT rate.  However on occasions the VAT rate could be 0.00.

I realise that you could have a tick box to ask the user if it is VAT or not but I would like the user to be able to amend it to 0.00 rather than tick a button.

Does anyone know how I can do this please.

[charlessexton]

Have an input that defaults to 20.00? And then the user can change it if need be.

[Wendy3]

This is my code currently but I want the user to be able to key in 0.00 and ignore this code if possible.

If(ddSalesDescription.SelectedText.Value = "********",
"0.00",
Text(Round(Sum(txtSalesAmount / 100 * varVatRate), 2), "0.00" )

[trjackson77]

Hello @Wendy3,

Before suggesting a solution, I want to confirm a key detail: Are users in your Power App selecting products from a predefined table or list? This information is vital to ensure the proposed solution fits your specific scenario.

Assuming your app involves product selection from a table, here's a streamlined approach for dynamically adjusting the VAT rate:

1. Associate VAT Rates with Products: Make sure each product in your database is linked with a specific default VAT rate.

2. Automate VAT Rate Retrieval on Product Selection: When a user picks a product from the list, your app should automatically fetch the corresponding VAT rate associated with that product from your product table.

3. Conditional Logic for VAT Calculation: Utilize Power Apps’ formula language to apply the fetched VAT rate automatically in the VAT calculation field.

This method ensures that the VAT rate adjusts automatically based on the product selected by the user, simplifying the process and reducing the need for manual input.

Could you confirm if this setup aligns with your app's configuration, or if there are additional details that might affect the solution?

Best regards!

Tim

[Wendy3]

Unfortunately it is not from a product list.

My Sales part of the App is pulled through from purchase invoices. We have sales categories which could be either vatable or not and is only determined once we have received the purchase invoice hence why I would like the user to be able to override the calculation.

[trjackson77]

Hello @Wendy3,

@charlessexton eluded to a solution above.  Let me expand on that and help with the code.

To handle VAT calculations based on user input in Power Apps, you'll first need to create a textbox for the VAT rate:

• Create a textbox named txtVATAmount.
• Set its default value to 20.00, which can be changed by the user as needed.

Here are two methods to utilize this textbox for VAT calculations:

1. Original Amendment with User-Input VAT Rate:

   If(
       ddSalesDescription.SelectedText.Value = "********",
       "0.00",
       Text(
           Round(
               Sum(txtSalesAmount / 100 * Value(txtVATAmount.Text)), 
               2
           ), 
           "0.00"
       )
   )
               

   This method uses conditional logic based on product selection.
2. Refactored Code for Direct VAT Addition:

   Text(
       Round(
           txtSalesAmount + (txtSalesAmount * Value(txtVATAmount.Text) / 100), 
           2
       ),
       "0.00"
   )
               

   This approach adds VAT directly to the sales amount.

Choose the method that aligns with your app's workflow. Feel free to ask if you have any questions!

Best regards,

Tim

[Wendy3]

Thank you everyone for your input.

We have decide to go with a VAT tick box so that the user can choose if it is VAT or not.