cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raks3
Helper IV
Helper IV

Send collection as email

Hi,

I need to send my complete collection list as a table to the user, please help me. Each time collection will have new data.

image.png

 

Please help me

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks for the clarification 😀


Do you need the Table columns - Label2,3,4,5 in your Email as well?

If not, can you please try as below - change column names and collection name as applicable:

 

ClearCollect(
colTemp,
ShowColumns(
YOUR_COLLECTION,
"Additional_Guidance","Principle","Category"
)
);
flowName.Run(JSON(colTemp,JSONFormat.IndentFour))

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up

View solution in original post

7 REPLIES 7
happyume
Solution Sage
Solution Sage

1 - Create a PowerAutomate Flow with trigger as PowerApps

2 - Initialize a String variable with value = Ask in PowerApps

3 - Now in PowerApps, OnSelect of your button call the Flow as:

 

flowName.Run(JSON(YOUR_COLLECTION))

 

4 - Test your PowerApp to have the collection sent to Flow as JSON string.

5 - Within your Flow, add an Action called Parse JSON, and pass the variable value from Step2.. For the schema, use value from Test run in Step 4

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up

@happyume ,

As my gallery is a nested, here is the error.image.png

happyume
Solution Sage
Solution Sage

What I posted earlier has worked for me in the past, however they were single column collections.

In your situation, try below:

 

flowName.Run(JSON(YOUR_COLLECTION,JSONFormat.IndentFour))

 


Please click
 Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up

@happyume ,

It still says the same.

image.png

 

happyume
Solution Sage
Solution Sage

Are you passing Gallery or a Collection to the Flow? In my formula, I have said YOUR_COLLECTION.

You must be using Collection as the Items property for Gallery

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up

I am passing my collection

image.png

Her is my collection formula.

image.png

 

Thanks for the clarification 😀


Do you need the Table columns - Label2,3,4,5 in your Email as well?

If not, can you please try as below - change column names and collection name as applicable:

 

ClearCollect(
colTemp,
ShowColumns(
YOUR_COLLECTION,
"Additional_Guidance","Principle","Category"
)
);
flowName.Run(JSON(colTemp,JSONFormat.IndentFour))

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,920)