Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to check if an Array contains  values in excel?

(0) ShareShare
ReportReport
Posted on by 389

 

Dear all,

 

How to check if an Array contains  values in excel?

I use the Condition ,entering the output of the Filter Array and entering the filed in Excel.But it doesn't work

GUOGUO_0-1662695883642.png

 

  • AbdulWahab Profile Picture
    AbdulWahab 517 on at
    Re: How to check if an Array contains  values in excel?

    Hi GUOGUO,

     

    then Use the filter array action. For more details, read it out: Use data operations in Power Automate (contains video) - Power Automate | Microsoft Docs

     

    If I answer your question then please mark it as verified.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

     

  • GUOGUO Profile Picture
    GUOGUO 389 on at
    Re: How to check if an Array contains  values in excel?

    Hi AbdulWahab,

    Thanks for your feedback.

    Actually,i want to use Condition to check if the values in Excel is in the Array.

  • AbdulWahab Profile Picture
    AbdulWahab 517 on at
    Re: How to check if an Array contains  values in excel?

    Hi GUOGUO,

     

    You have an array. right?

    Before adding the value to an excel you need to check whether it exists in excel or not. Is this what you are looking for?

    If Yes, then You can use below:

    1. Get a row
    2. List rows present in a table

       Updating Media

      If the action returns a row or rows this means the record exists

      if the action does not return a value that means the record does not exist.

      To check the existence of a record. You need to use condition control after the list or get.

       

      If I answer your question then please mark it as verified.

       

      Let me know if I can provide you with more details.

      Thanks
      Regards,

      Abdul Wahab
      Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
      Direct/WhatsApp:+923323281237
      E-mail: abdulwahabubit@outlook.com
      Skype: abdul.wahabubit
      Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a

       

      For more details read the link.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard