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

Is there alternative to create a table?

 
8 REPLIES 8
Highlighted
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

 

 

 

Highlighted
Helper IV
Helper IV

Re: Is there alternative to create a table?

 
Highlighted
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

Highlighted
Helper IV
Helper IV

Re: Is there alternative to create a table?

 
Highlighted
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']

Highlighted
Helper IV
Helper IV

Re: Is there alternative to create a table?

 
Highlighted
Community Support
Community Support

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.

Highlighted
Helper IV
Helper IV

Re: Is there alternative to create a table?

 

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,736)