Check if value in excel exist

(0) Share

Report

Posted on 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

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Scarygary 10 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Scarygary,

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

Please try again.

Regards,

Barry

Was this reply helpful? Yes No
Scarygary 10 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Scarygary 10 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No