Unanswered

Sub filter in Sharepoint List to reflect in HTML table

(0) Share

Report

Posted on by vsvsardo

Hi there,

I've created a flow in Power Automate that is working, but I need to apply another filter in the content of the Sharepoint List.

These are the columns in the HTML table that come from my Sharepoint List:

Owner

Date

Description of the Task

Product Type

I've added the "Date" as the current filter in "Get Items", as I want to have the reference of the deadline date.

However, I need to send separate emails depending on different Product Types instead of having one HTML table in the body of the email with the same list of people and product types.

Can you please have a look into the below flow and let me know how can I accomplish the following:

Send separate emails filtered by product type
The HTML table in the body of those emails to be also filtered by product type

Any help is much appreciated.

Flow 2.PNG Get Items.png

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @vsvsardo ,

Based on your description, I have made a simple test for your reference.

SharePoint list for test:

This is flow:
I put the create HTML table last because it becomes difficult to filter after becoming an HTML table.

Result:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
vsvsardo 62 on at

Like (0)

Report

Hiya,

Thank you for your working on a solution for me.
What was the filter query you've used in "Get Items"? This flow that I've created should send the email when it's 30 days before the due data (deadline date)

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

Like (0)

Report

Hi @vsvsardo ,

I didn't use filter query in my flow.
If the format of due date is date without time, you could refer to the follow method:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
vsvsardo 62 on at

Like (0)

Report

Hiya,
Now, i get the following error message:

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

Like (0)

Report

Hi @vsvsardo ,

It is strange that there are two "Apply to each" with the same name in the picture.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
vsvsardo 62 on at

Like (0)

Report

Hi @v-zhoqian-msft ,

I managed to fix that issue but now it's showing me a different error message about the "filter query" in "Get Items" from Sharepoint List (snips attached for reference). As you can see, "Date" is a column in my Sharepoint List so I don't understand why the query says there isn't a column with that name.
Would you be able to help on this?

Thank you in advance.

filter query.PNG

get items express...

sharepoint list.PNG

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

Like (0)

Report

Hi @vsvsardo ,

There is no error in my test. According to the error message, it is the lack of quotation marks outside first(), but I noticed that the formula in the picture seems to have already added quotation marks.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
vsvsardo 62 on at

Like (0)

Report

Hi Habsburg,
I've made some changes and now I have a different error message (snip below for reference):

Was this reply helpful? Yes No