Formatting a Filter Array output(body)

[gazzo1967]

Hi all
I am triggering a flow from Powerapps and after extensive google/searching here etc i', lost 😞

I have my Power apps trigger

I have a 'Get Items which is filtered by date
I have a 'Filter array' which returns the information correctly

What i want to do is now take that information and turn it into a HTML document but i dont want to show all the returned information and i don't want to use 'Create HTML table' action.

What would be my next step?

Gary

[ChristianAbata]

hi @gazzo1967  dis you test with parse JSON?, see and example.

[gazzo1967]

HI @ChristianAbata 
this is all my flow has at the moment as i dont know what to do next

if i add a parse Json after Filter Array it asks me for content which one do i use?

Body or Items?
The it asks for a schema

if i put a compose after filter array and use output from Array the parse json still asks for scema

[ChristianAbata]

mmm @gazzo1967  when you use get items you are getting lot of values from a list, so when you use filter query I asume you are getting just specific values, I don't know if I'm understhand ding well but what you need to di is just select one of all values returned by filter query?

for example

Imagine that you have in your list this values

MyDaat	1	22-22-22
OterD	2	22-33-22
Example	2	22-22-33
More	2	44-33-11

So using get items you extract all of the data theb filter array allows you to get specific data like from all values just get the data with 2. So applying filter query you can get this

OterD	2	22-33-22
Example	2	22-22-33
More	2	44-33-11

then I'm asuming that you need to use just one of that filtered values like just convert into a table the row name Example?

[gazzo1967]

@ChristianAbata 
Again thank you for the response 🙂

I have added the Create HTML Table as my next action and found the Columns 'Custom' and added the fields i want 🙂 but the next step is to email that complete html table but it sends separate emails for each entry 😞

[ChristianAbata]

oh @gazzo1967  I understand, what you need to do is manage variables, pleasee see my example

see my compose could be your table, so you can use that output into an email after compose. 😉

[v-bacao-msft]

Hi @gazzo1967 ,

First method is to use Filter Query to filter items directly. In this way, you do not need to use Filter array to filter items, you can also easily configure Create HTML table action.

Please check this article to get more details about the usage of Filter Query:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

For the usage of Parse JSON action, please check this article:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

You could also refer to the following image to configure flow.

Hope this helps.

Best Regards,