Unanswered

Trouble with Flow and Sharepoint list calendar

(0) Share

Report

Posted on by myyytest

Hi guys

I am new to Flow and Sharepoint, having some trouble getting the Sharepoint List calendar App to correctly show the dates of events.

I have a master list of events which is stroed in a sharepoint list. If this list's items are added or modified then events will be added/modified on the Sharepoint Calendar APP, which is also technically a sharepoint list.

I can get this working using Flow, but the only thing I can't get working is to get the event on the Sharepoint Calendar App to show the event start and finish times of events from the master list. I can get the start and finish DATES working fine. But the start and finishing TIMES are needed so that the event's start and finish time can be shown on a Calendar Webpart on site's front page.

Any ideas on how I can use Flow to take the event's start and finish time and inject it into the Sharepoint Calendar app? The ultimate goal is to give the Sharepoint calendar Webpart the ability to show an event's start and finish times.

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @myyytest

Can you check and confirm that the master list has the date and time column and this column has the time option enabled on it for the Start and End times of the event?

You can then directly refer these to create the event in the sharepoint calendar app and it will display the event accordingly.

If not, can you share a screenshot of the flow you already built? That way it will be easier to identify the issue and assist you with this.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the fast reply,

The start date and end date fields do have time enabled.

The isssue is, the start/end date and start/end time information are in two different columns. So I use a calculated column to combine this info into a single date/time column, this calculated column/variable is used to create the event in Flow. But the Sharepoint calendar app still does not recognise the start/end time, only the start/end dates.

All info attached in the photo.

Thanks again for your help.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @myyytest

I think we need to format the date time string appropriately to pass in the calendar list. you can use the concat function to join the date and time individually as concat('datefield','T','timefield','z') and then use a format date time expression to formatdatetime(concatoutput, 'yyyy-MM-ddThh:mm:ssz') and then put it in the calendar attributes.

can you try this?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

thanks for another speedy reply

so you mean

a) use a calculated column to concatenate DATE & TIME

b) use a second calculated column to convert the concatenated string from above into a time format,

c) then use the above in the flow?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @myyytest

No! You shouldn't create any extra columns in SP. Initialize variables or use compose action along with the expression editor in Flow itself and create the date time strong from the sharepoint columns of date and time.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I will try this.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @myyytest ,

Perhaps you can achieve your needs directly on the basis of your current configuration.

The reason why the previous configuration didn't implement your requirements before is that there is a missing T in the middle of SP cal start date + start time/SP cal end date + end time.

The expected format of the Start time/End time field in the Event list is "yyyy-MM-ddTHH:mm:ss".

Your previous calculated column is missing a T.

After adding T, the problem should be solved. It seems that you do not need to changed the current Flow configuration.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

HI @v-bacao-msft
I tried ur way and still get funnt results, I added a T between the date and time, just a text T. But all I get is a 3 digit number in return.
plz see attached ss of how I set up the calculated column and the result.

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

@yashag2255

Tried your solution too, followed ur instructions precisely but got an error.

I created a variable to hold the concat of date + time.
concat(triggerBody()?['EventStartDate'],'T',triggerBody()?['Event_x0020_start_x0020_time'],'z')

the output from concat was stored in a string var called: concact date and time

then used a formatdatetime on the concat results. formatDateTime(variables('concact date and time'),'yyyy-MM-ddThh:mm:ssz')

I've treid leaving out the 'z' from the concat and formatdatetime, and leaving out the 'z' from concact & 'ssz' from formatdate time,

but still got an error, please see attached ss for error msg.

Was this reply helpful? Yes No