web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter true values fro...
Power Automate
Answered

Filter true values from select from filter array

(0) ShareShare
ReportReport
Posted on by 95

Hi all,

Pardon me. I am trying to filter out true values from the select section (i.e. show field 1 values that only have pink, field 2 values that only have red, and field 3 values that only have blue). 

What I'm doing now is I append the select output to all the fields in the array and the results show true/null for the 3 different colours. I would like to omit null values. How do I achieve this? I believe it has got to do with formula expressions within the 'Append to array variable' section. Could it be using the keys to get the mapped values?

Alois_0-1606982721559.png

Appreciate any help!

Regards,
Alois

 

Categories:
I have the same question (0)
  • Alois Profile Picture
    95 on at

    Anyone able to advice? Basically the color values are labels from MS planner tasks. They are boolean variables. When I visualize them on a html table, the results show true and false.

     

    All i require is an expression that can help to fetch only TRUE values so that I can do length() and count the total. 

  • Verified answer
    v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @Alois,

     

    The output of Select action is an array, if you want to remap it like the format you shows in the Append to array variable action, you should put it into an Apply to each action to loop them, then use expression to return the current item corresponding field in the array during the action's current iteration, for example:

    item()?['Pink'], item()?['Red'], item()?['Blue']Screenshot 2020-12-04 104034.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard