cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HelloHello
Level: Powered On

Is there alternative to create a table?

 
8 REPLIES 8
Dual Super User
Dual Super User

Re: Is there alternative to create a table?

Hi @HelloHello 

 

When query sharepoint using getitems you can perform query ins ame action

Using filter query option

 

example: Status eq 'Pending'

 

Next instaed of creating array, use Select a (data operation) action and choose the field you need

Next create html table and send in email

 

in the email body, you can define css as well to format your table

example : https://davidlozzi.com/2018/11/01/sending-a-beautifully-formatted-email-from-microsoft-flow/

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

HelloHello
Level: Powered On

Re: Is there alternative to create a table?

 
Dual Super User
Dual Super User

Re: Is there alternative to create a table?

Hi @HelloHello 

 

on which step did the flow fail

and what is the error message

 

if flow fails on get items

check odata query syntax (may be statis is a choice field in your case)

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

HelloHello
Level: Powered On

Re: Is there alternative to create a table?

 
Dual Super User
Dual Super User

Re: Is there alternative to create a table?

Hi @HelloHello 

 

error states Mailroom Name has field is not correctly names

 

check the exact name returned by the getitems action (when u run the flow you can see the details)

 

then try item()?['correctnameofmailroomfield']

HelloHello
Level: Powered On

Re: Is there alternative to create a table?

 
Community Support Team
Community Support Team

Re: Is there alternative to create a table?

Hi @HelloHello,

 

The body of Send an email (V2) you need to input is Html format, so if you need to send it as an Html, you should obey the rule of Html. Please refer to this post:  Send-an-email-v2

Or you could use the Send an email action, then set the Is Html as Yes:Annotation 2019-08-26 144854.png

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

HelloHello
Level: Powered On

Re: Is there alternative to create a table?

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,447)