tldnr: How to remove "columns" from an array?
Background:
I have made a simple (but beautiful) maintenance system-application in PowerApps with data in a Sharepoint list. To spare my colleagues from opening an app every day I would like a weekly Email with things to be done in the next 7 days.
Problem:
Everything works fine apart from that I do not want the ENTIRE list to be sent in the email, only the Title and some other information.
Current steps:
- Recurrence – The trigger works fine. Every Monday@7:00
- Get items –The "Filter Query" does not seem to work on calculated fields so I pull the entire list.
- Filter array – This is where I filter the "Get items"-result so that I only get the rows that I am interested in. This works fine on the calculated Boolean columns that tells me if a row is to be shown or not.
Now I only have 2 of 65 rows left which i am interested in right now.
- Create HTML table – Here I can choose from the “Filter array”-body or the “Get items”-value. I choose the “Filter array”-body to only get the 2 rows.
- Send an email (V2) – The email-function works fine but the array contains everything. I would like to narrow it down to two or three columns so i do not get that 3 meter wide email.
I guess that this is a really easy problem to solve but i am missing some steps. Probably before or after #4.
