We have a list, the flow working for the same, some columns in the list are caculated by flow,
so, the problem is when we change the region of the list, flow calculation is not work or displaying wrong values.
please provide the solution for the same.
You mean a sharepoint list?
As far as I remember, all times are expressed in UTC in Microsoft Flow. In SharePoint, it will display the date to you in the time zone you have specified under Site Settings…Regional Settings.
As a workaround, there are some timezone related functions that can help you, you can check it in the following link:
THere is also a 'Convert TimeZone' action block (guess based on the above function) in this post you will find an example on how to use it when interacting with Microsoft Flow
Hope this helps
Hi @NikhilC ,
Your flow is deployed in the region that hosts the environment. Please check the following doc on regions in MS Flow:
Further, please go to Settings under the gear icon, then you are able to choose display language and regional format:
Below i am explain the detail problem,
i have a list with some calculated column and some column that are calculates based on the flow,
for englisg region of the site setting all calculations are working fine,
but when we change the region from English to some other language,
calculations gets wrong.
is there any way to change the region of the flow, so that it matches to site region and calculations gets done in the list.
Let's see if I understood the use case.
Did you share your flow, and you are executing it over a site configured with English timezone; but somebody else is executing it over another site configured with a different timezone?
Hi @NikhilC ,
How is the calculated column configured in the list?
Could you share a screen shot of your flow as well?