Others

How to Display Dataverse Date and Time in IST in Power Pages

Partner Editor Sep 25, 2026 869 views

Question details

The user wants to accurately convert and display Dataverse date and time values into Indian Standard Time (IST) on Power Pages.

How to Display Dataverse Date and Time Values in IST in Power Pages

Product: Microsoft Power Pages
Device & OS: not provided
Scenario: Formatting date and time data retrieved from Dataverse on a Power Pages portal using Liquid expressions.
Observed behavior: Liquid expressions fail to convert the time correctly to IST when manually adding seconds or applying unsupported time zone filters.

Before you start

Verify the original time zone settings of your Dataverse date and time columns and ensure you have administrative access to check your Power Pages site configurations.

Solution 1Recommended

Use Supported Liquid Date Functions and Verify Site Settings

Instead of manually calculating time differences, rely on native Power Pages site configurations and standard Liquid date formatting.

Manually adding time offsets (like 19,800 seconds for IST) often leads to display errors due to calendar variations and limitations in Liquid math filters. The most reliable approach is to leverage the built-in time zone handling of Dataverse and Power Pages.

Verify Dataverse column type

Check your Dataverse table configurations to see if the date and time column is set to 'User Local' or 'Time-Zone Independent'. This determines how the base value is passed to Power Pages.

Check the Power Pages site time zone

Navigate to the Portal Management app, go to Site Settings, and ensure the default time zone for your portal is correctly configured for your target audience.

Apply standard Liquid date filters

Format your date output using standard Liquid syntax (e.g., {{ my_date_column | date: '%d/%m/%yyyy %H:%M' }}). This lets the system handle the offset automatically based on the site settings.

Consult the Power Pages Community

If standard formatting still does not yield the correct IST output, post your specific scenario and Liquid code in the Microsoft Power Pages Community for specialized troubleshooting.

Use Supported Liquid Date Functions and Verify Site Settings

Avoid Manual Time Addition: Do not attempt to add 19,800 seconds manually using Liquid math operations, as this method is generally unsupported for datetime objects and breaks easily during edge cases.

Free Microsoft Office alternative

Manage Exported Dataverse Records with WPS Office

While Microsoft Power Pages manages your web front-end, you can easily export your Dataverse tables to CSV or Excel to analyze your date and time data locally. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your data analysis needs.

1. Export your data: Export your target date and time records from Dataverse into a standard CSV or Excel file format.
2. Open in WPS Spreadsheet: Launch WPS Office, select Spreadsheets, and open your downloaded file to view the raw timestamp values.
3. Format local time zones: Use WPS Spreadsheet's built-in date formatting and custom formula tools to instantly convert and verify your time zones offline.

Fully compatible with Microsoft Excel (.xlsx) and CSV formats.Analyze and adjust exported Dataverse date and time data using powerful Spreadsheet functions.Lightweight installation with a familiar user interface for seamless migration.Built-in tools to convert data reports directly into professional PDF documents.

microsoft office alternative - wps office

Frequently Asked Questions

Why does adding 19,800 seconds to a Dataverse date fail in Liquid?

Liquid math filters are typically designed for integers and floats. Applying them directly to datetime objects is often unsupported and can result in parsing errors or completely incorrect timestamp outputs.

How do I check the time zone of my Power Pages site?

You can verify and update the site's default time zone by accessing the Portal Management app and reviewing the specific time zone configurations under the Site Settings section.

Does the Dataverse column behavior affect Liquid outputs?

Yes. If a Dataverse column is configured as 'Time-Zone Independent', it will display the exact stored time regardless of the portal's settings. If it is set to 'User Local', it dynamically adjusts based on the configured environment or user time zone settings.

Office Quick Solutions