Real Time Scenario in Power Apps

There is a requirement to Export gallery data in Excel format from application using Power Automate Flow, but the blocker is that data is exporting in other format at play mode but at the edit mode of application the data is exported in correct format. Data is exporting in one paragraph.

We have analyzed the bug is occur due to region of country and then some implementation is done to resolve this issue.

To resolve the bug, changes was done into the format of query for importing the data in Power Automate and perform some steps according to the requirement. Some hint which we have made in our solution is below.