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
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
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
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
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
Hi @Scarygary,
I noticed that "is equal to" used in your Condition, which should be "Contains".
Please try again.
Regards,
Barry
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.
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