Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Check if value in excel exist

(0) ShareShare
ReportReport
Posted on by 10

Hi, 

 

I am gathering IP adresses in a form. 

 

I want to validate the response "IP-Address"  and save the new IP in an excel with a comment OK or NOT OK. The IP is OK if it already exist in an another excel table with 800 ip addresses.

 

When I test this (Se picture) My IP is checked against the excel with 800 IP (the get rows (table name IPcheck)). For each IP in the table IPcheck I get an output that writes OK or not OK.  I only want to get one output         

Skärmklipp.JPG

 

      

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Check if value in excel exist

    Hi @Scarygary,

     

    Variables and array are used in many development languages and scenarios. For the Flow section, you can refer to this Link:

    https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

     

    Best Regards,

    Barry

  • Scarygary Profile Picture
    Scarygary 10 on at
    Re: Check if value in excel exist

    Many thanks Bary, it works 

     

    Can you recommend some sites with tutorial that cover variabel, arrays etc. need more deep knowledge than the basic stuff

    BR Daniel  

  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Check if value in excel exist

    Hi @Scarygary,

     

    In this case, you could use variables to store all the IP in an array, and then determine whether the submitted IP is included in the array.

    Image reference:

    35.PNG

    36.PNG

    Please take a try again.

     

    Best Regards,

    Barry

  • Scarygary Profile Picture
    Scarygary 10 on at
    Re: Check if value in excel exist

    Dear @v-bacao-msft

     

    The condition still return false on everything.

    I am wondering (out of my competence) if the datatypes from the form can be compared with the data from an excel whitout changing them.

     

    I am attaching a new picture from the latest change. The compose is the output from the form    

      Skärmklipp4.JPG

     

        

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Check if value in excel exist

    Hi @Scarygary,

     

    I noticed that "is equal to" used in your Condition, which should be "Contains".

    Please try again.

     

    Regards,

    Barry

  • Scarygary Profile Picture
    Scarygary 10 on at
    Re: Check if value in excel exist

    Hi the second suggestion runs more quickly than the first one. 

     

    Time for execution nr1, 2 minutes.

    Time for  excution nr2, 5 seconds

     

    However the condition returns false in the condition for every scenario,  both example 1 and 2.

     

    example scen2

    The IP from the FORM is 10.1.1.2 and the select give me an output för the correct IP however the condition returns false when it should be true. 

     

    Skärmklipp2.JPGSkärmklipp3.JPG

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Check if value in excel exist

    Hi @Scarygary,

     

    You could use the following two methods to achieve your needs.

    Method1:

    First configure Add a row in a table action directly under Get response details action, and replace the action in If yes/If no with Update a row action. It is better to have key column in Table.

    19.PNG20.PNG

    Method2:

    You could use Get rows-Select to get all the IP addresses in the IPcheck table, and then check if the output contains the submitted IP address.

    21.PNG22.PNG

     

    Best Regards,

    Barry

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics