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 / Cannot access the valu...
Power Automate
Unanswered

Cannot access the values of an filtered Array properly

(0) ShareShare
ReportReport
Posted on by 29

Hi There. I have builded a flow for a list of publictaions. This flow should send an reminder email to an author of a publication, if the deadline for the Call for Paper(CfP) is 14 days ahead. So far so good. The problem appears at the very end of the flow, where i try to gather all the Informations to send those Mail, such as the publications title and the Authors name and Email. At the beginn of the flow, i had used the get items action to get all publictaions. After that im using a filter array, to filter those publictaions. the ones left are those with a CfP 14 days ahead from now on. This seems to work just fine. But at the end, where im trying to access these filtered array of all publications with a CfP in 14 days the problem appears:

 

I have two compose actions to the titels and the Authors name.

Screenshot (44).png

For the title im using the expression items('Apply_to_each')?['Title']. This works just fine.

Screenshot (45).png

But when i try to write an similar expression for the author name, the returned value is empty!!

Screenshot (46).png

When i write the same expression without /DisplayName, then the returned value is an author object. but i need the name value of those object, not the wohle object itself.

Screenshot (49).png

This is the out put of the filtered Array. As u can see, the "Autor_x002a_innen" contains several values as DisplayName, Email etc. I have tried to access the DisplayName value by using "Autor_x002a_innen/DisplayName". But as i said, when i do so the returned value is empty.

 

Does anyone have a clue?

 

THX 🙂

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @BonCurry Can you try the following?

    items('Apply_to_each')?['Autor_x002a_innen']['DisplayName']

    To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

     

    In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

    1️⃣ Cross-Referencing Data

    2️⃣ Filtering by Key

    3️⃣ Substring Matching

     

    Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

     

    IN THIS VIDEO:

     3 Ways to Use the Filter Array Action

    How to use the Scope Action to Group Actions

    How to Check the Number of Items returned from a Filter Array Action

    How to Cross-Reference Data in Excel with a SharePoint List

     How the Filter Array Action Works

     How to Access the Dynamic Content from a Filter Array Action

     How to Filter Items by a Key

    How to Filter Items by Matching a Substring

    How to Use Multiple Conditions in a Filter Array Action

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

     

  • VictorIvanidze Profile Picture
    13,073 on at

    Try to use this:

    items('Apply_to_each')?['Autor_x002a_innen'][0]?['DisplayName']

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard