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

All responses (8)

Answers (0)

vsvsardo 62 on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

Hi Habsburg,
I've made some changes and now I have a different error message (snip below for reference):
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

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.
vsvsardo 62 on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

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
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

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.
vsvsardo 62 on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

Hiya,
Now, i get the following error message:
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

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.
vsvsardo 62 on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

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)
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Sub filter in Sharepoint List to reflect in HTML table

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.