Hi!! I'm trying to convert a date that I'm getting from SharePoint but the result is really odd.
Solved! Go to Solution.
Hi @diegoadum,
Please try the following code, I have made a test and it works fine:
ConvertTimeZone(triggerBody()?['Created'],'Central Standard Time','Pacific SA Standard Time','dd/MM/yyyy')
Best regards,
Mabel Mao
Looking at your example I noticed that my mistake was to use the mm instead MM in the month conversion. I made the change in the formula and now is working as should!
so the formula now is like this:
convertTimeZone(items('Apply_to_each')?['Created'], 'Central Standard Time', 'Pacific SA Standard Time', 'dd/MM/yyyy')
Hi @diegoadum,
Please try the following code, I have made a test and it works fine:
ConvertTimeZone(triggerBody()?['Created'],'Central Standard Time','Pacific SA Standard Time','dd/MM/yyyy')
Best regards,
Mabel Mao
Thank for the tip! Maybe you can explain what the difference between items and TriggerBody is?
In addition, I'm getting a null error now. Sorry, but I hit the accept as a solution too soon! AS you can see below I do have a value in the Created field, but Flow is not considering it as a valid value.
Looking at your example I noticed that my mistake was to use the mm instead MM in the month conversion. I made the change in the formula and now is working as should!
so the formula now is like this:
convertTimeZone(items('Apply_to_each')?['Created'], 'Central Standard Time', 'Pacific SA Standard Time', 'dd/MM/yyyy')
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
86 | |
58 | |
41 | |
35 | |
32 |
User | Count |
---|---|
79 | |
67 | |
57 | |
49 | |
40 |