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

Sort SQL table and convert to pdf

I have my powerapp working fine.
User inputs choices clicks create report and flow takes over
Users input taken and sent to sql query which is then sent to response to get the resultsets.table1
After that the user is sent to another screen that displays the table
This raw table is a mess and need to be cleaned up (adding alt row colors, changing columns etc) but for now works

What I would like to do next allow user to sort by certain columns and then open the table as a pdf that can be saved or printed.

How would I do this with premium account?

would also like to know if there's a way to do this without premium account.
Any help appreciated. Thanks
Thanks
 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @CrashWave ,

 

I'm afraid that it is difficult to sort the table in Microsoft flow.

You could sort the table in the PowerApps and send the table to flow, then you could create a file from the table, convert the file to pdf.

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
Super User II
Super User II

hi @CrashWave  if you want to create a pdf from your final result you can follow this awesome video.

https://www.youtube.com/watch?time_continue=641&v=bfXV_GXc_JM&feature=emb_title

 

See he is using OneDrive that is no premium action.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Community Support
Community Support

Hi @CrashWave ,

 

I'm afraid that it is difficult to sort the table in Microsoft flow.

You could sort the table in the PowerApps and send the table to flow, then you could create a file from the table, convert the file to pdf.

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,914)