Power Platform Community Forum Thread Details

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:

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).
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:

Experimental features