Date

[romi]

Hi, 

I am using microsoft forms and microsoft flow. 

In microsoft forms, I used text question for the dates since I want to add multiple dates

Question: Dates Booked

Answer: 8/8/2021, 8/16/2021, 8/25/2021

I made an approval then if it is approved. it will create an event in Outlook Calendar.

But since the dates are multiple. The flow is having an error

Is there a way that I can fix this?

Thank you

[annajhaveri]

@romi  you can use compose action and split expression to split the date value first, and then with Apply to each action use output of compose action, and inside it add Create Event action.

[romi]

hi,

what will i put in start time and date time? thank you

[Nived_Nambiar]

Hi @romi 

From the dates that u had received from the forms, what would be the start time and end time ?

[annajhaveri]

@Nived_Nambiar  are you taking the time from user in create event, if not, do you want to create event for all day or for specific time slot?

[romi]

Hi, 

What if I received multiple dates?

For example: The client booked for August 15, 2021; August 17, 2021 and August 25, 2021. 

[romi]

Hi, 

I want it to be event for full day. 

Thank you.

[romi]

Hi,

I'm getting this error 

The 'inputs.parameters' of workflow operation 'Create_event_(V4)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/start' is required to be of type 'String/date-no-tz'. The source type/format 'Array' of the value '["8/15/2021"," 8/19/2021"," 8/25/2021"]' is not convertible to type/format 'String/date-no-tz'.

[annajhaveri · Accepted solution]

@romi  configure the flow as shown below, here i am assigning static value to variable but you can assign form response date field to the variable

In Compose action use following expression

split(variables('Dates'),',')

Then in apply to each action use output of compose action. Then in Create event action use current item for dates.

[romi]

Thank you for your help!! 

It works.. 😍