HI All
I need some help with a flow
I have a flow that when a list item is created it does the following:
My sharepoint list stores the date in a datepicker field
but my time field is single line text.
When i create item - Create calender item
As you can see the Event date and time start and finish are entered but the output time is 7hrs earlier
but the output time is 7hrs earlier
I take it i have to convert the dates to UTC before using them in my create Calendar item
This i dont know how to do 😞
Regards Gary
Hi!
Did you tried with this action block, please note the values assigned in the screenshot are from a different project:
Please be careful and keep 'Format string' as the one you originally has in your traces, select your own source time zone, and select as destination time zone UTC.
Hope this helps
Proud to be a Flownaut!
Thank you for the response
My date and time are in 2 different fields in sharepoint list and i am joining them this way in my create item.
the time from my sharepoint list is the correct time entry so do i have to work out the difference for example i am in UTC 00:00 Dublin London etc
I have set Convert Time
This is the output
As you can see in my create item INput its the correct time
But the output changes!
Gary
i also assume that UK Daylight savings cause issues!
Proud to be a Flownaut!
Yes it does these are the outputs after conversion
Hi @gazzo1967,
There is no concept of daylight saving time and time zone in Flow. When creating an item in SharePoint, it will default to Universal time. So, when you create an item, you should convert it by using Expression or Convert time zone action.
We often use the methods given by @efialttes. You need to pay more attention to this when you use Flow in the future. I hope you can enjoy using Flow.
Best Regards,
Community Support Team _ Lin Tu
Ok thank you for your response but then explain to me when i am using Convert time that the correct time is being inputted into my create item (to a sharepoint calendar) but the output adds an hour?
My regional settings are all correct.
I understand teh methods that @efialttes has explained to me but nothing is working!
I have even rebuilt the flow!
Regards Gary
Hi @gazzo1967,
When the hour added in the SharePoint, cause SharePoint has daylight saving, so the return of the SharePoint will add an hour.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So what is your recommendation to make this work correctly?
The data and time are from one Sharepoint list on the same site!
It only changes the time between the create item input and output
Just looking into my columns and i notice that i have the date in one column (date Only) but the time is in a single line of text column would this make a difference?
Can i use the Create event action with a sharepoint calendar?
If so how do i get the sharepoint calendar ID?
Gary
Hi @gazzo1967,
The only way to solve the time issue for now is using the addHour() function, if it less 7 hours, when you append the date in, add 7 Hours in the Start Date and End Date.
If you store the Date in the single text, it will not different from stored in a Date column if you just for the view. However, if you want to create a calendar column based on it, it will unavailable.
Actually, the SharePoint calendar is a SharePoint list, you could use the create item to do it.
If so, you could use Get items or Get item action in the SharePoint connector to get the calendar ID.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gazzo1967,
The Calendar wouldn't appear in the list name, you could enter a custom name into it:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response.
i am using Get Item as it is one record that needs to created
If you look at the previous parts of the thread you suggestion is exactly what i a doing but the create item in the calendar(custom list) is adding an hour to my times when i don't need it too.
The original list where powerapps is sending the information gathered is on the same sharepoint as the calendar.
as you can understand i do not want to have to keep adjusting the outputs from powerapps twice a year to account for this as the whole idea is to automate the process.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
27 | |
26 | |
13 | |
12 |
User | Count |
---|---|
58 | |
51 | |
30 | |
27 | |
27 |