You’re offline. This is a read only version of the page.
4
Hello,
I am new to Flow and I try to use it with our on-prem Sharepoint and I seem to do something wrong.
Following simple flow:
- Read a SP list, filters out everything that has today or less in single field.
- Create HTML table from it.
- Send email with HTML table.
Filtering logic looks fine, but output has a date with day before, ie. SP has 06.02.2019 - Email has 05.02.2019.
On testing runs, it seems wrong data are already picked in "Read from SP" step.
Out SP has UTC+1 time zone - can that be the problem?
If convert timezone is way to go, how can I just apply conversion to SP data and send correct result to HTML table?
Kind thanks for any advice!
Hi @DK_MSW,
How long is the time difference between your sharepoint lime and the utc time?
What is the column in your sharepoint list to save the date?
I have made a test to create a "Date" column in my sharepoint list to save the date.
You could add the time difference in flow as screenshot below:
The expression in the flow is as below if the time difference is 1 hour:
addHours(item()?['Date'],1)
The expression in the flow is as below if the time difference is 1 day:
addDays(item()?['Date'],1)
Best regards,
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,537
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,908
Most Valuable Professional
Share
Report
All responses (
Answers (
