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
Solved! Go to Solution.
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:
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.
I guess you can create a View with Pending State filter and send a link in the email to that view
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:
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.
User | Count |
---|---|
97 | |
40 | |
27 | |
23 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
24 |