@moragb
Manual Trigger
While you build and test your flow I would recommend using a Manual Trigger. Add the Get Response details action and enter any Response Id that you can use to help build your flow.
Compose the Date
The Compose actions below are optional. You can insert the expression directly into the Add a Row into a Table action if you prefer. I prefer to use Compose actions so I can run a test and view the outputs.
Add a Compose action.
Insert an Expression and use the formatDateTime() function.
Click on the Dynamic content tab and insert the appropriate dynamic content from the Get Response details action.
Add a comma and single quotes. In between the single quotes—enter the date format. To return the full month enter:
MMMM
Copy the expression to your clipboard. Add a Compose action for the Day and Year.
Replace the format between the single quotes. To return the numerical day enter:
dd
To return the year enter:
yyyyy
Run a test. View the outputs to ensure the expressions are correct.
Group your Actions
Add a Scope action to your flow. I like using Scope actions in my flow to group actions together to keep my flow organized.
Add as many as you need in your flow.
Add Row into a Table
Insert the output from the Compose actions into the appropriate fields.
You might also be interested in a new YT Tutorial I recently uploaded: How to Get a Microsoft Form RSVP Response into a SharePoint List
I cover the following in this video tutorial:
✅ How to get a Microsoft Form Response into SharePoint
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form response
✅ How to Build a Microsoft Form with Conditional Fields
✅ How to used Branching in Microsoft Forms
✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column
✅ How to parse a Microsoft Form multiple choice response as string of text
✅ How to convert a text response to a number
✅ How to use the Switch action
✅ How to create a custom email confirmation for a Microsoft Form submission
✅ How to Create a Custom View in a SharePoint list
✅ How to use the Compose Action
✅ How to write Power Automate Expressions
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!
|
