I finally got my flow to add a new calendar (event list) item when a vacation request is approved. But it is off by a day. I am using an existing calendar that was used using SPD workflow and it worked fine. Now I'm using a PowerApps form with Flow on the same calendar, not sure if that is significant. Is there a timezone setting that I should be using in PowerApps?
Solved! Go to Solution.
Hello @RobertC71
So is the issue still your date being a day off?
You do not need the Convert time zone action.
What you need to do is use the expression like you are doing but pass the date you are getting from Power Apps
convertToUtc( <Put your Power Apps date here> ,'Pacific Standard Time')
Also you can get rid of the 'g' at the end
โJosh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Proud to be a Flownaut!
Proud to be a Flownaut!
Proud to be a Flownaut!
Proud to be a Flownaut!
@Jcook Thanks for your reply. I'm still having issues, maybe the issue is with my flow. I've attached screenshots.
Hi @RobertC71
I cannot see your expression.
Can you copy the expression and add a comment to the action it belongs to or paste it in here
โJosh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Proud to be a Flownaut!
My apologies here it is:
convertToUtc(triggerBody()['Sendemailwithoptions_Body_1'],'Pacific Standard Time','g')
It is in compose and compose3 actions. Replacing Sendemailwithoptions_Body_1 with Sendemailwithoptions_Body_2 in compose3.
Hello @RobertC71
So is the issue still your date being a day off?
You do not need the Convert time zone action.
What you need to do is use the expression like you are doing but pass the date you are getting from Power Apps
convertToUtc( <Put your Power Apps date here> ,'Pacific Standard Time')
Also you can get rid of the 'g' at the end
โJosh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Proud to be a Flownaut!
@Jcook The calendar was almost correct. I created an entry in PowerApps startdate 5/14/2020 enddate 5/18/2020, the calendar entry end the pto request at 5/18/2020 12:00 AM instead of the full day for 5/18. Shown in screenshot. And the SP list shows the requested dates in UTC instead of PST. What else could be wrong? Thanks again.
Proud to be a Flownaut!
Hey Sir,
My start and end dates are Date Only. I was able to get the update item fixed, needed to add the output of the converttoutc in those fields. Only one issue left. The calendar doesn't show the end date as part of the pto request because the time is still set to 12AM. You help has been tremendous. Thanks
That is awesome!
Sorry I dont understand the last issue?
โJosh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Proud to be a Flownaut!
@Jcook The last issue is the calendar isn't displaying the way I need it too. I've included 2 screenshots. How it's looking now and the 2nd screenshot is what it should look like if the time was set properly.
In this example the vacation request is from 5/14 - 5/18. I need the calendar to show 5/14 through 5/18. I hope this makes sense now.
Proud to be a Flownaut!
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 |
---|---|
90 | |
55 | |
38 | |
35 | |
29 |
User | Count |
---|---|
75 | |
66 | |
50 | |
47 | |
42 |