@Tim_Opie-SWRB The empty() function returns a true or false value. Try this expression instead.
coalesce(body('Get_response_details')?['rb44f98b5f2804da9a17dfab3313b3c4f'], null)
This expression will:
- Attempt to return the value of rb44f98b5f2804da9a17dfab3313b3c4f from the response of the Get response Details action.
- If this field is present and has a value (not null or empty), it returns that value.
- If the field is null or empty, the coalesce() function returns null.
In the meantime, you might 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!
|
