web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issues with VAT Calcul...
Power Apps
Unanswered

Issues with VAT Calculation and Microsoft PowerApps Integration

(0) ShareShare
ReportReport
Posted on by

Hello Microsoft Community,

I’m currently working on a project where I’m trying to integrate VAT calculations into a Microsoft PowerApps application. My goal is to dynamically calculate the VAT between two dates and display the result based on specific conditions. However, I'm facing a few issues that I hope someone can help me resolve:

  1. Date Calculation Issue: I need to calculate the network days between two dates (Start Date and End Date), similar to Excel’s NETWORKDAYS function, but when I try to implement this in PowerApps, I’m unsure about the exact syntax and how to handle conditions based on the result (e.g., showing "In Progress" when the End Date is blank or "OK" if the number of network days is less than or equal to 2).

  2. Text Direction Issue: I also want to translate the app into Arabic and correctly display text in right-to-left (RTL) format. I’ve set the TextDirection property to RightToLeft, but the layout and text are not behaving as expected in certain areas.

Could someone provide guidance on:

  • How to properly calculate network days in PowerApps and apply conditions based on the result?
  • Best practices for handling RTL text in PowerApps while ensuring proper layout adjustments?

You can view the related VAT calculator project I am working on here: Calcvat

Any help or insights would be greatly appreciated. Thank you in advance!

Looking forward to your responses!

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard