Check if value in excel exist

Like (0) Share

Report

Posted on 30 Oct 2018 14:43:27 by Scarygary

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

All responses (7)

Answers (1)

v-bacao-msft on 02 Nov 2018 at 00:39:54

Like (0)

Report

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 10 on 01 Nov 2018 at 09:36:08

Like (0)

Report

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 on 01 Nov 2018 at 09:22:11

Like (1)

Report

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:

Please take a try again.

Best Regards,

Barry
Scarygary 10 on 01 Nov 2018 at 08:55:58

Like (0)

Report

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
v-bacao-msft on 01 Nov 2018 at 00:21:56

Like (0)

Report

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 10 on 31 Oct 2018 at 11:57:43

Like (0)

Report

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.
v-bacao-msft on 31 Oct 2018 at 04:03:23

Like (0)

Report

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.

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.

Best Regards,

Barry