How to Save Microsoft Forms Responses to Dataverse and Model-Driven Power Apps

Lisa Crosbie โ€ข January 15, 2024
Video Thumbnail
Lisa Crosbie Logo

Lisa Crosbie

@lisacrosbie

About

This channel is all about making AI at work accessible to everyone. I break down these technologies into practical, easy to follow fun tutorials. Here you will find short and long form tutorials and free courses on Copilot Studio, Microsoft Copilot, Power Apps, and other Microsoft technologies, as well as tutorials on how to use AI at work. You'll also find feature updates here every time there is a major event or new announcement from Microsoft, to help you keep up with what's ahead, and what's important and why. I am a five-time Microsoft Most Valuable Professional (MVP) and Microsoft Certified Trainer, with more than a decade of experience consulting with organizations and training business users to get the most out of Microsoft applications at work. Thanks for watching!

Video Description

This video is a step-by-step tutorial on how to use Power Automate flows to save Microsoft Forms Responses into Dataverse. This helps with use cases for Model Driven Power Apps where you have internal or external users who need to submit data, but who don't need access to the database or the application, and don't have licenses. **** Important note about Licensing **** NOTE that you do need to license the flow owner with a Power Automate premium user license or license the flow with a process license for this scenario. This tutorial is not advice on a licensing workaround, or multiplexing - this is a legitimate scenario where the individual users submitting ideas to not need any access to the app or database. If your particular scenario requires users to have an app directly connected to Dataverse, then they will need a per app or premium Power Apps license. ***************************************** This tutorial covers how to set up your Form, and how to set the sharing permissions to anyone or internal to your organisation only. I go through 4 scenarios for using Power Automate, each adding more complexity. Timestamps: 00:00 Use Microsoft Forms with Dataverse 03:07 Set up your form in Microsoft Forms 05:23 Save Form responses into a Dataverse table 12:54 Save Form responses into Dataverse and link another table 20:50 Licensing 21:23 Create contact records for external submissions who submit a form and link their response 26:12 Link form responses to Microsoft Entra ID (AAD) records for internal submissions 34:08 Microsoft Forms vs Power Pages ------------------------------------------------- Connect with me: โ˜• Buy me a coffee: https://www.buymeacoffee.com/lisacrosbie ๐Ÿ–‡ LinkedIn: https://www.linkedin.com/in/lisa-crosbie/ ๐Ÿ“ผ TikTok: https://www.tiktok.com/@lisa.crosbie ๐Ÿฆ X (Twitter): https://twitter.com/LisaCrosbie ๐Ÿ“šTake my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps https://www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/

Craft Valentine's Magic

AI-recommended products based on this video

Loading...
Handmade 3pcs in Set Cowboy Boots and Hat Clip on Charm for Diy Necklace Bracelet Bags, Enamel Charm Western Style Jewelry Accessories

Handmade 3pcs in Set Cowboy Boots and Hat Clip on Charm for Diy Necklace Bracelet Bags, Enamel Charm Western Style Jewelry Accessories

(0)
$11.02
FREE delivery Sat, Jun 14 on your first order
Loading...
Smallduuck Personalized Photo Keychain for Dad Custom Baby Ultrasound Keychain New Dad Picture Keychain

Smallduuck Personalized Photo Keychain for Dad Custom Baby Ultrasound Keychain New Dad Picture Keychain

(2)
$16.99
$9.99 delivery Jun 23 - Jul 3
Loading...
Surpgift Custom Men's Wallets, Personalized Photo & Name Engraved, Modern Brown Faux Leather, Zip-Around, Lightweight, 14 Compartments, Men's Accessory

Surpgift Custom Men's Wallets, Personalized Photo & Name Engraved, Modern Brown Faux Leather, Zip-Around, Lightweight, 14 Compartments, Men's Accessory

(162)
$23.99
$4.99 delivery Jun 17 - 26
Loading...
2025 Graduation-Garden-Flag Personalized, Custom Photo Name Grad Yard-Sign Congratulations Flag,for University Decoration Outside Lawn,Double Sided Fuchsia

2025 Graduation-Garden-Flag Personalized, Custom Photo Name Grad Yard-Sign Congratulations Flag,for University Decoration Outside Lawn,Double Sided Fuchsia

(2)
$16.26
$14.99 delivery Feb 27 - Mar 6
Loading...
FAURAPMNG FAURAPMNG 5 Pcs Graduation Cap Photo Charm Graduate Memorial Tassel Picture Charms with Angel Wing Personalized Bouquet Tassel DIY Grad Photo Chain for Class of Grad Cap Gown Ceremony Caps Charm Decor

FAURAPMNG FAURAPMNG 5 Pcs Graduation Cap Photo Charm Graduate Memorial Tassel Picture Charms with Angel Wing Personalized Bouquet Tassel DIY Grad Photo Chain for Class of Grad Cap Gown Ceremony Caps Charm Decor

(6)
$11.91
FREE delivery Sat, Feb 14 on your first order
Loading...
Cosplay Wig, Long Rose Red Wig for Women Girls, Hot Pink Straight Cosplay Wig with Ponytails for Halloween Anime Costume Party
Best Seller

Cosplay Wig, Long Rose Red Wig for Women Girls, Hot Pink Straight Cosplay Wig with Ponytails for Halloween Anime Costume Party

(1)
$12.79
$8.99 delivery Oct 30 - Nov 10
Loading...
MOSISO 13-14 inch Laptop Case, 13.3 inch Puffy Laptop Sleeve Compatible with MacBook Air 13 13.6 M4 M3 M2 M1/Pro 13/Pro 14,HP,Dell,ASUS, Lenovo, Polyester Horizontal Bag with Small Case, Rose Red Global Recycled Standard

MOSISO 13-14 inch Laptop Case, 13.3 inch Puffy Laptop Sleeve Compatible with MacBook Air 13 13.6 M4 M3 M2 M1/Pro 13/Pro 14,HP,Dell,ASUS, Lenovo, Polyester Horizontal Bag with Small Case, Rose Red Global Recycled Standard

(918)
$31.04
FREE delivery Tue, Jun 17 on your first order
Loading...
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)

Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)

(32)
$8.99
FREE delivery Wed, Mar 25 on your first order
Loading...
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)

Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)

(34)
$8.70
FREE delivery Fri, Feb 13 on your first order
300+ bought in past month
Loading...
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)

Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)

(41)
$8.18
Prime
800+ bought in past month
Loading...
Windshield Crack Repair kit Windshield Repair kit, Glass Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit 2 Pack (Drakgray)
Best Seller

Windshield Crack Repair kit Windshield Repair kit, Glass Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit 2 Pack (Drakgray)

(44)
$9.20
FREE delivery Fri, Oct 24 on your first order
500+ bought in past month