cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAppNoob
Helper I
Helper I

Create an excel table using updates coming from Power Apps

Hi Experts,

 

I have created a flow triggered by Power Apps where it sends an email summary to the power app user (responder) who submitted the form. The summary is in table form and is included in the body of the email.

 

Is it possible to create a excel file based on this table and make it as an attachment in the email to be sent to the responder?

 

I tried including 'Create CSV table' action in the flow but all the information are lumped in one cell instead of having separate columns.

 

Any help would be greatly appreciated.

7 REPLIES 7
chrissahagun
Resolver II
Resolver II

Checking this docu:

Understand data operations - Power Automate | Microsoft Docs

 

it says create CSV takes a JSON array input format.

chrissahagun_0-1616232270255.png

Pardon this next question as it will sound like an IT Support guy asking if you plugged in the power... 😇

 

Can we confirm first that the input to your Create CSV table was in a form of a JSON Array?

Hi @chrissahagun ,

 

Thanks for replying. Here's the flow that i have.

 

PowerAppNoob_0-1616254354501.png

 

I am getting a CSV file as attachment to my email but the Column headers are all in one cell. Same as the items that are supposed to be separated into different columns.

Jronash
Solution Supplier
Solution Supplier

In your "Create CSV table" action, what do you have in the From field?  I see that it says Output, but I can't tell which output it is using.

 

Also, in your "Send an email" action, what do you have in the Attachements Content field?

Hi @Jronash ,

 

This is what i have in the From field in the Create CSV table.

 

PowerAppNoob_0-1616289644698.png

 

And the Email attachment is the Output from Create CSV table.

Jronash
Solution Supplier
Solution Supplier

Hmm, I'm not able to replicate this problem.

 

I guess the next step would be to go to the run history of the flow and examine the outputs of your Select action and your Create CSV Table action, to see if you can tell where the problem is happening.

 

I'm also not sure I understand why you are using a Select action to map the columns you want, and then mapping the same columns in your Create CSV Table action.  Couldn't you just set the Create CSV Table action to get its data directly from Filter Array?  Though you may have reasons for structuring it this way, and in theory it shouldn't be the reason why your csv file isn't being created properly.

@Jronash , I used the Select action because i don't need all the columns from the source data. I removed the mapping of columns in the Create CSV table. The CSV file still just have 1 column where all the headers are mixed together, separated by comma.

Jronash
Solution Supplier
Solution Supplier

Have you gone into your run history and examined the output from the Select action and the Create CSV action?

 

If there is no confidential information, are you able to post the outputs here?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,453)