cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdamS1
Frequent Visitor

Sending Collection to Automate using JSON

Hi Guys,

 

Any help with this would be amazing.

 

I have a Daily Inspection Form which the user fills out every day and the data is saved to a collection called "OfflineData" (this is offline as its in the middle of a quarry with no signal) They do one for every day then at the end of the week they click a weekly submit button which I then need to send it to Automate to be able to populate a word template which will be converted to a PDF and saved to SharePoint. I have attached a photo of the form so you can see the boxes that need to be sent to Automate.

 

Has anyone got any ideas on how to do this? And if so any help with the code for it and JSON would be amazing!!!!!

 

Thank you in advance for this.

 

Thank you!

Adam

1 ACCEPTED SOLUTION

Accepted Solutions
v-liwei-msft
Microsoft
Microsoft

Hi @AdamS1 ,

 

1.Connect to your PowerAutomate.

vliweimsft_0-1656322549536.png

 

2.Enter this formula in the button's OnSelect property:
FlowName.Run(JSON(CollectionName,JSONFormat.Compact))
 
3. The collection passed to flow by PowerApps is of string type, you can use the json function to convert it to an array:
vliweimsft_1-1656322549540.png

 

I think this link will help you a lot:
 

Best Regards,

Levi

 

View solution in original post

1 REPLY 1
v-liwei-msft
Microsoft
Microsoft

Hi @AdamS1 ,

 

1.Connect to your PowerAutomate.

vliweimsft_0-1656322549536.png

 

2.Enter this formula in the button's OnSelect property:
FlowName.Run(JSON(CollectionName,JSONFormat.Compact))
 
3. The collection passed to flow by PowerApps is of string type, you can use the json function to convert it to an array:
vliweimsft_1-1656322549540.png

 

I think this link will help you a lot:
 

Best Regards,

Levi

 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (3,176)