Unanswered

Flow to look up numbers on an excel file

(0) Share

Report

Posted on by roberts

Hi all,

I have a flow that takes responses from Microsoft Forms, then does a lookup on an excel sheet to pull some percentage data, then updates a different spreadsheet. The issue i find is, the excel lookup sheet sometimes has two numbers together , example 123456, 654321 . so in this case my lookup of "123456" finds nothing. but if the number "123456" is by itself in the column then it wokrks. Is there a way to do a lookup that will find "123456" no matter if it is by itself "123456" or in a colum with other numbers "123456, 654321" ?

make sense?

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (0)

ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@roberts

You might try a condition as in my example below. I don't believe that contains is supported in an OData filter, so you are left with a condition. I use the string() expression because the contains in an expression works only with strings.

Was this reply helpful? Yes No
roberts 73 on at

Like (0)

Report
Copy link

Link copied!

I thank you for your reply, you helped me over the weekend to with another Flow. I do apologize as i'm still learning this, i don't quite understand where to put that condition? after my "Get a Row" ?

Was this reply helpful? Yes No
ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@roberts

Yes - after the Get row action.

Was this reply helpful? Yes No
roberts 73 on at

Like (0)

Report
Copy link

Link copied!

I get the expression is invalid when i enter "string(...)"

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@roberts

Your expression should look like my screen shot below. Replace 123 with the number series that you are looking for.

Was this reply helpful? Yes No
roberts 73 on at

Like (0)

Report
Copy link

Link copied!

I don't have a number series, example we have areas names as numbers, lets say this

NY = 2043455
TOR = 731234
LON = 145765
and so on and os on, random 6 digit numbers

Was this reply helpful? Yes No
ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@roberts

You'll need to repcae my hard coded number(123) woth a reference to the number for which you are searching. This could come from Dynamic properties, etc..

Was this reply helpful? Yes No
roberts 73 on at

Like (0)

Report
Copy link

Link copied!

the number in question is being entered in the Form and i am retrieving those responses prior. I am calling those "Node#" so is thta what i would enter in the string? As i have that entered in the

Was this reply helpful? Yes No
ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@roberts

You'll want to enter a reference from Dynamic properties to the question from Forms that may contain the string that you're looking for.

Was this reply helpful? Yes No