How to Send a Collection from Power Apps to Power Automate | 2022 Tutorial

Hi Everyone,
In this video, I demonstrate how to send a collection from Power Apps to Power Automate. After, I create an HTML table with the collection and send that to the user's email.
If you enjoy my content feel free to like, comment, and subscribe!
#powerautomate #powerapps #microsoftflow

[@drexelfiend]

Thank you, this resolved an issue I have been dealing with all day! The additions needed to the schema solved my issue of getting type mismatches.

[@aimeeoneil7029]

This was AWESOME!!!!!!!!!!!!!!!! Thank you so much. I searched and searched for content on emailing a collection to the current user.... SO happy I came across this video and I will definitely be subscribing.

[@michaelalex2322]

Glad it helped!

[@1155074]

Thank you so so so much for this brilliant video, your way of explaining is very intuitive, and your pace is excellent. You head right to the point. and you don't waste time talking about not related issues or stories that do not concern us, those who have a problem and need to get to the solution ASAP.

[@michaelalex2322]

Glad it was helpful!

[@TioXpi]

This literally saved me hours of work. Thank you

[@michaelalex2322]

Happy to hear :)

[@petereriksson6859]

Thanks 4 all the effort to share this video :)

[@rajansingh6282]

can shared any one which type json giving in schema i have got an error

[@jimmyjohn7490]

Great video, can you explain how to do you do this using the PowerApps V2 trigger? Thanks!

[@PitakYT]

Thank you.

[@afrozzyan3248]

Great video! this is what am looking for. Can you please tell me how to send email of 4 different collections like this.?

[@youngwood5704]

wow, I was manually creating the HTML string ina forall loop in power apps, this is much easier. Probs a lil slower, but I will 100% be using this method in the future.

[@michaelalex2322]

lol can't imagine doing it with a HTML string in a forall

[@shivanihandore4738]

Thank you so much ❤

[@michaelalex2322]

You're welcome 😊

[@MiniFootball23]

Where did you get and how it connects the Collection Inputs?

[@khaledtellopalacios3072]

Great

[@juanjosenunezcarreno]

Thanks!!!

[@michaelalex2322]

No problem!

[@rajansingh6282]

can shared any one which type json giving in schema i have got an error

[@tomasborghi4566]

Great video, thanks! Is there a way to sort the html table the way i want? Will it alwats be sorted the same say the collection does?

[@michaelalex2322]

You have to sort it in the PowerApp before. In the code just include a Sort(mycollection, columnname)

[@swapnamoybhattacharjee1390]

Hi! Can you please make a video on how to add SharePoint data to a collection in power apps using power automate...

[@michaelalex2322]

You should just have to send the data from SharePoint to a Power Apps collection. No Power Automate is needed for that. ClearCollect()

[@mr5bassman]

This is a great video! Unfortunately, I'm not able to get it to work. I keep getting an error when I run the flow. Any help would be appreciated. "message": "Invalid type. Expected Object but got Array.", "lineNumber": 0, "linePosition": 0, "path": "", "schemaId": "#", "errorType": "type", "childErrors": []

[@michaelalex2322]

You may need to edit your JSON schema to look for an object. Would enclose the array in an object

[@deepadevi682]

Is there a way to send it as an excel file( and not CSV) instead of a HTML table ?

[@michaelalex2322]

Yeah it's possible but it's a way more complicated Flow. That's why I usually stick to CSV's.

[@deepadevi682]

@@michaelalex2322 There is a business requirement of it for me. Could you please help me with how it can be done?

[@r.dwayne2067]

ᴘʀᴏᴍᴏsᴍ 😋