Post Microsoft Form Submission into Team SHIFT app using Power Automate flow

(2) Share

Report

Posted on by CU03031744-0

Hi,

I have Microsoft form looks like this,

Now once user submit response the response should go to here,

End result should be like all information that user submit from microsoft form it should entered here.

I have tried to create flow by calling Form, groupid id for shift app, followed by compose and JSON Parse to access data in JSON format.

This is the result I am getting,

This is where I am having issue,

In this scenario start date should 10/05/2025 and End date should be 10/15/2025 as seen in first image.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @CU03031744-0,

The runtime value suggests it is not using the actual year, but just YYYY.

Can you share the expressions/fx with the formatdatetime functions you are using in the start time and end time field?

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
CU03031744-0 6 on at

Like (0)

Report

Thanks for your response.

here is expression i am using,

Formatdatetime(adddays(outputs('Get_response_details')?['body/submitDate'], -15), 'YYYY-MM-DDTHH:MM:SS').

What i want is if look at image where all dates are there as row column and answers are in columns selection.

For example, if user select Shifts est 2pm - 10pm for 10/05/2025 then response should send to TEAMS SHIFT calendar for 10/05/2025.

Thanks

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @CU03031744-0,

I see you used the submit date in your expression. However, that is the day/time when the user submitted the form. And you are subtracting 15 days from that. In other words, a form which has been submitted today will use the 12th of September?

That is not what they selected in the likert question of your screenshot. Secondly, those questions will only record what the user has selected. The dates are just labels. Below is an example output of that. For that part you might require some more advanced expressions, with for example xpath.

If you still want to use the submit date you could adjust the date time formatting. I see you used all uppercase characters. Date time formatting is case sensitive (yyyy-MM-ddTHH:mm:ss)

https://learn.microsoft.com/en-us/power-automate/date-time-values#format-date-and-time

Try something like:

formatdatetime(adddays(outputs('Get_response_details')?['body/submitDate'], -15), 'yyyy-MM-ddTHH:mm:ss')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No