Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Function not working i...
Power Automate - Building Flows
Answered

Function not working in filter array

(0) ShareShare
ReportReport
Posted on by LB-20090315-0 66
Hello!
 
Now, I'm sure this is just my coding and function ignorance but my filter array keeps failing. 
 
Here is my flow:
 
 
It was running exactly how I wanted it too except for one snag. In my sharepoint list I have attached different documents to each of the list rows. I want the emails to send to each individual with their specific documents but it was sending with all the documents. It seemed filter array could fix this, to filter the attachments array before I send the emails. However, it keeps saying field_1 is Null. I've checked, field_1 does correspond to sharepoint list and there is data in there. I'm sure I must have just written the function incorrectly or something simple, can anyone advise?
 
 
thank you. 
 
Categories:
Business Process Flows
  • Verified answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,559 on at
    Function not working in filter array
    Hi,
     
    should have looked into attachments array contents earlier- i could see your attachment array - each object has 2 properties- Name and Content, while field_1 property is not found in that. so are you reference field_1 from loop (for each ) if yes , then you should have use items('For_each')?['field_1'] instead.
     
     
  • LB-20090315-0 Profile Picture
    LB-20090315-0 66 on at
    Function not working in filter array
    Hi Nived,
     
    thanks for the suggestion. I've just checked, yes the internal column name is field_1. What do I do next?
     
    Kind Regards,
    Lauren
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,559 on at
    Function not working in filter array
    Hi,
     
    if the field_1 has value present in it, and still shown as null, then one possibility i could think of is internal column name corresponding to field_1 is wrong, could you check what is correct internal column name to be used for the sharepoint list ?
     
    refer below to find the internal column of sharepoint column and use that same in the expression ?
     
     
    Hope it helps !
     
    Thanks & Regards,
    Nived N
     

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

News and Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans