Unfortuantely I am using a Microsoft Form as the intial input for colleciton of flows, and selecting a time isn't possible the way it is with dates. I am trying to automate the creation of events from sharepoint, but in order to do so, I need a yyyy-mm-ddThh-mm-ss format. Is there a simple way to do this? Or a better way to create events? I feel like I am so deep in the trees here I can't see the forest.
Solved! Go to Solution.
I have been playing with this and I am very close I think. I am using
The problem is, 3:00 PM is converting to 03:00:00, not 15:00:00. Any suggestion on that? Once that's fixed I am good to go. Thank you again for your help!
Bringing up an old topic here, but can you post snippets of where you put the expression formatDateTime(utcNow(),'HH:mm:ss')?
I'm fairly new to Flow and am having the same issue when it comes to creating an event in the calendar. I want people to be able to just put in standard time and not military time. Here's my flow....
Based on your screenshot, I will assume you are having this issue in the "Create event (V2)" step. Are you working with both date and time or just time? If you can expand the "Create event (V2)" step and upload a screenshot of that, I can point out where to add the expression.
One thing I must point out: the expression used to solve the original issue is just using time, but the user wanted military format. For standard time, the expression would be as follows:
@faustocapellanj Thanks for the quick response!! I'm racking my brain here with the power of Flow and options.
Here's the expanded view of the "Create Event (V2)" section. Any suggestions are greatly appreciated. Basically what I want to happen is the user to put in standard time and the event to be recorded in military time since that's the only way it will be accepted and automatically put into the calendar.
If you are forcing the users to use military time format in the Start Time field, you don't need to format, but if that's not the case, then the formatting must be done. The expression below was used in the Start Time and End Time fields. I will break down the expression so you can understand it better.
To get started with the expression above, click in the Start time field and select the Expression tab next to the Dynamic content.
Once in there, you can type concat or select it from the list. Click inside the parenthesis for concat(), go back to the Dynamic content tab and select the Request Date field. It will look like this in the expression: body('Get_response_details')?['r562e2ac2239249c9adc16e60d4325ab4'].
After this bracket ], add the following ,'T',. After the last comma, enter the formatDateTime() expression and inside the parenthesis, select the Start Time from the Dynamic content, followed by this ,'HH:mm:ss' and then click OK.
Do the same thing for the End time field, but with the respective fields from the form. Please let me know the results.
Fausto Capellan, Jr
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!