{"id":23516,"date":"2020-05-13T12:52:24","date_gmt":"2020-05-13T12:52:24","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=23516"},"modified":"2022-06-14T14:38:02","modified_gmt":"2022-06-14T09:08:02","slug":"how-to-pass-power-apps-collection-in-power-automate-using-json-function","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/05\/how-to-pass-power-apps-collection-in-power-automate-using-json-function\/","title":{"rendered":"How to pass Power Apps Collection in Power Automate using Json Function"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

Earlier, we have seen how to pass parameter from Power Apps to Power Automate. In today\u2019s blog, we will explore how to pass the Collection from Power Apps (Canvas App) to Power Automate. A collection in Power Apps is used to store data. You can explore more about Collection in Power Apps here<\/a>. \u00a0Now, consider that you want to update a large amount of records using Patch and ForAll functions in background asynchronously, so user has no need to wait for completion of request. To process this we need to create Power Automate where a collection from Power Apps will be passed and the flow will process the collection and do the operation as per our requirement since if we use Patch and ForAll functions and user exits the app the operation may stop. Below we have shown an example to pass the collection from Power Apps to Power Automate.<\/p>\n

Now let\u2019s consider a scenario where Manager wants to send a mail to other users in system to follow up the task.<\/p>\n

1<\/strong>. We created a sample user app and design as shown in below screenshot:<\/p>\n

\"Power<\/p>\n

2<\/strong>. Now on ‘onCheck’ property of the Checkbox lets create a user collection with below formula:<\/p>\n

Collect(UserColle,{userEmail:ThisItem.’Primary Email’,fullName:ThisItem.’Full Name’,userId:ThisItem.User})<\/strong><\/p>\n

\"Power<\/a><\/p>\n

3<\/strong>. Now on ‘onUnCheck’ property of the Checkbox lets remove the user from user collection with below formula:<\/p>\n

If(LookUp(UserColle,userId=ThisItem.User, true ),Remove(UserColle,First(Filter(UserColle,userId=ThisItem.User))))<\/strong><\/p>\n

\"Power<\/a><\/p>\n

4<\/strong>. Now let\u2019s create a Power Automate which run on click of \"Power icon and sends email to the selected users in the app. Login to https:\/\/flow.microsoft.com<\/a>\/<\/a> and create a new flow using the ‘Power App Button’ Template as shown in below screenshot:<\/p>\n

\"Power<\/p>\n

5<\/strong>. Now add an action as ‘Parse Json’ and add content ‘Ask in PowerApps’ as shown in below screenshot:<\/p>\n

\"5.<\/p>\n

6<\/strong>. Now add \u2018Apply to each loop\u2019 to send email for the each selected user as shown in below screenshot:<\/p>\n

\"Power<\/p>\n

7<\/strong>. Now back in the Power Apps on ‘On Select’ property of the\u00a0 \"Power icon add the MS flow by selecting Action -> Power Automate ->’MS flow’:<\/p>\n

\"Power<\/p>\n

\"Power<\/p>\n

8<\/strong>. As soon as the Power Automate is added on the ‘On Select’ property pass the User collection in JSON format as shown below:<\/p>\n

SendEmail.Run(JSON(UserColle,JSONFormat.Compact))<\/strong><\/p>\n

\"Power<\/p>\n

9<\/strong>. Now run the app, select users, click on icon and see the collection is passed to Power Automate.<\/p>\n

\"Power<\/p>\n

10<\/strong>. Now as shown in below screenshot the flow has run successfully and the entire collection is passed in flow.<\/p>\n

\"Power<\/p>\n

You can refer more on JSON function in Power Apps here<\/a>.<\/p>\n

Conclusion<\/strong><\/p>\n

Thus, as illustrated above you can now easily pass the entire Power Apps collection in Power Automate by using JSON function.<\/p>\n

Free 70% of storage space in CRM with Attachment Management Apps!<\/div><\/div><\/h2>\n

Attach2Dynamics<\/a> – Store and manage documents\/attachments in cloud storage of your choice – SharePoint, Dropbox or Azure Blob Storage from within Dynamics 365 CRM.<\/strong><\/em>
\nSharePoint Security Sync<\/a><\/strong> \u2013 Robust and secure solution to integrate Dynamics 365 CRM and SharePoint Security Sync thereby ensuring secure access to confidential documents stored in SharePoint.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Earlier, we have seen how to pass parameter from Power Apps to Power Automate. In today\u2019s blog, we will explore how to pass the Collection from Power Apps (Canvas App) to Power Automate. A collection in Power Apps is used to store data. You can explore more about Collection in Power Apps here. \u00a0Now,\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":23537,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[44,1985],"tags":[],"class_list":["post-23516","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-apps","category-power-automate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/23516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=23516"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/23516\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/23537"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=23516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=23516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=23516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}