What is needed to find the first row in an Excel with an empty value in a specific column?

(0) Share

Report

Posted on by FB-21100732-0

I am sorry for the very basic question, but I have been spending way too many hours trying to solve this.

I have an excel file with a table in which I have a column "Campaign owner" that has values up to a certain point, while another column "Form URL" has always values.

I would like to get the Form URL from the first row in the table that has an empty Campaign owner cell and send it to Teams.

This is what my intended flow looks like.

The failing action is Compose, but the problem lies with Filter Array where the condition is set as:

or as:

This returns always an empty array, which is of course not readable by the Compose.
I have tried putting 'null' and null after the comma, to no avail.

The only outside factor I can imagine is the amount of rows to be considered, which is over 1000 by now, but I don't believe that should be a factor.

Asking both Copilot AND ChatGPT have been as efficient as clapping with one hand in this regard.

Can you please guide me through it and please bear with someone who doesn't know the syntax?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI @FB-21100732-0

Here is what you need

In your Filter

In my example i have a table with 2 columns

Column1 has nulls (blanks) aka empty and Column2 always has data

Now one thing you are missing is explaining your Sort, to make sure that the first row actually IS the first row and they are in the order you need them in

Now in my Filter array I have to use the empty check NOT null etc.

so in mine it is exactly this

empty(item()?['Column1'])

So you would need to use item()?['YourColumnNameHere']

Now, remember you have multiple rows so now I have to grab the correct one is either using first or [0] as the index

so in my filter I would get 2 rows back

To get the first Column2 value I put in

body('Filter_array')?[0]?['Column2']

where 0 is the index of the first row

And bingo I get row 1 of the 2 I was filtered

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No
FB-21100732-0 2 on at

Like (0)

Report
Copy link

Link copied!

That runs, but the output of the Filter array block is an empty body array.

The block is set up in the following way:

Also, sorry about the Sort detail missing: you can consider the table sorted by the 'Campaign owner' field.

Was this reply helpful? Yes No