Is there alternative to create a table?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

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:

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No