Share
Report
13Hello,
i want to create a flow which follow these steps.
- When an item is created in SharePoint, the flow should check the availability of the needed Participants.
- Invite all the needed participants for the first free slot in time.
The issue: i was able to create an event only for the next 2 days. When no free slots are available for the next 2 days, I couldn’t create an Event. See following Appendix
The 07.05.2022 from 14:00 to 15:00 isn’t a free slot so the filter has no output for the Create event.
Find meeting times 1
Start time:
The next working day
if(equals(dayOfWeek(utcnow()),5),startofday(adddays(convertFromUtc( utcnow(),outputs('Your_Time_Zone')),3)),if(equals(dayOfWeek(utcnow()),6),startofday(adddays(convertFromUtc( utcnow(),outputs('Your_Time_Zone')),2)),startofday(adddays(convertFromUtc( utcnow(),outputs('Your_Time_Zone')),1))))
End time:
In the next 240 hours
addHours(utcnow(),240)
Max candidates: 1
Fillter array 2
Create event
Start time:
convertFromUtc(concat(body('Filter_Array')[0]['MeetingTimeSlot']?['start']?['dateTime'],'Z'),outputs('Your_Time_Zone'))
End time:
convertFromUtc(concat(item()?['MeetingTimeSlot']?['end']?['dateTime'], 'Z'), outputs('Your_Time_Zone'))
All responses (
Answers (
