Hey @Pita098
No worries, I can tell you are stressed. A few carriage returns go a long way in night breaking my eyes lol. It's hard to follow stuff when it's just a giant paragraph 🙂 just for future reference.
Don't worry about convincing us its goofy or anything, it just distracts us from focusing on helping you 🙂 hehe.
I am assuming that you want a Table, based on data from Filter2, except that you want only certain Columns, not necessarily all.
Here is what we will do
1. don't use an append to an array and lets get rid of the loop, just take out the Apply to each and leave in your Filter.
We want to use a Select, so that we can pull out only the Columns you want from the Filter2, and so that the output works in a Create HTML Table action.
2. Add a Select Action right under your filter
-in the From, use the Body (Dynamic property) from the Filter2
3. Now we want to add the columns we want and this is where it can make you go "um say what Michael, are you nuts". Well yes I am but this is still how it works.
-A filter is like an internally hidden Apply to each.
-So in your Map you will do this and here is my personal example for people who do this .
--You can see in the Map, I put the String (Key) for whatever I want to call the column.
--In the Value (this is where it gets goofy) you are going to put
item()?['Whatever_Your_Column_Name_Is_In_Filter2_Regardless_Of_What_You_Called_It_In_The_Select_Key_Column']
So in my case for Title I have
item()?['Title']
And because Filter is an internal "loop" if you will, you use item just as if you literally had an Apply to each, but since your From points to a Filter body, it knows to OH grab it from that Body, without the need of a loop.
After that, in your Create HTML Table, simply add the Dynamic Output property of the Select and instant table
If this helps I'd love if you marked my answer as an answer (Resolved) and maybe also a kudo thumbs up.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
