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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / filter array can't han...
Power Automate
Answered

filter array can't handle select output

(0) ShareShare
ReportReport
Posted on by 23

Hello all,

 

thanks in advance for your time! 🙂

I have a select output which "changes" within the output from array form (// status) to string form (// uPN) and I do not know how to handle that.

 

 

 

 

 {
 "__________________Item": "shared-approvals-48efaa2d-91c1-49b5-80f5-e8f321bc5194",
 "// status": [
 {
 "status": "Connected"
 }
 ],
 "// displayname": null,
 "// uPN": "user.name"
 },

 

 

 

 

The next step is an array filter, which works fine if I use the // status.

Unfortunately it doesn't if I want to filter for // uPN, since it is stored as string.

 

The end goal is to filter for both with an and connection.

 

How can I handle this?

sto_teac_0-1712148433504.png

 

 

 

Categories:
I have the same question (0)
  • sto_teac Profile Picture
    23 on at

    Really? That simple 😳

    Thank you so much for the quick help!

  • Verified answer
    v-mengmli-msft Profile Picture
    on at

    Hi @sto_teac ,

     

    Please don't use 'first' when filter // uPN column, because 'first' is used for an array.

    vmengmlimsft_0-1712148737388.png

    So, the expression should be this.

    item()?['// uPN']

     

     

    Best regards,

    Rimmon

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 190 Super User 2025 Season 2

Last 30 days Overall leaderboard