cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jgarciac
Helper II
Helper II

create report from sharepoint list by state

good day...

Please your help, I need ideas, I need to create an email that is sent for periods of time, the information it must contain is data to be obtained from a sharepoint list (cases) that are in a pending state, I cannot find how to search for these cases in the list and take them to the mail.

example:

 

list
case name state
1      Juan ok
2      Peter Pending
3      Frame ok
4      Ana Pending

mail:

The pending cases of the week are:

case name 
2      Peter 

4      Ana

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @jgarciac,

 

What's the state column type?

If it is a single text, it is easy to do it, you could use ODATA syntax put in filter query field of Get items.

Then use Create HTML table action to generate an HTML table only contains columns Case and name.

Here are screenshots you could refer to:

Annotation 2020-08-06 101414.jpg

 

Annotation 2020-08-06 101415.jpg

 

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.

View solution in original post

4 REPLIES 4
PrasadAthalye
Community Champion
Community Champion

I guess you can create a View with Pending State filter and send a link in the email to that view

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

That was the first idea, but the big boss wants the information in the body of the mail!

Hi @jgarciac,

 

What's the state column type?

If it is a single text, it is easy to do it, you could use ODATA syntax put in filter query field of Get items.

Then use Create HTML table action to generate an HTML table only contains columns Case and name.

Here are screenshots you could refer to:

Annotation 2020-08-06 101414.jpg

 

Annotation 2020-08-06 101415.jpg

 

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.

EXCELLENT THANK YOU VERY MUCH!!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

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