Excel get a row if key value is blank

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I'm wondering if there's a way to get a row if the key value is blank.

I've tried just leaving key value as blank but this doesn't work.

All help appreciated

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Use compose action and supply expression-
if(empty(items('Apply_to_each')?['Column Name']),1,items('Apply_to_each')?['Column Name'])
here i am setting compose output 1 when excel column has blank value.
Once you do that use condition action like- (Output of compose) is equal to 1 and put required action in Yes block.
Thanks
Hardesh

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

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

Create a filter query action with key column equals to blank under the List rows present in a table action could filter out rows which key value is blank, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Like (0)

Report
Copy link

Link copied!

@Hardesh15, I tried inputting your expression and this is the error message I'm getting.
Any help would be appreciated.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

See my screen, in Compose 3 i have used Apply to each because i used action- List row present is a table. You are using Get a row action. this action give you only one row. I would suggest use List row present in a table so that you can get all empty rows.

Thanks
Hardesh

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

Like (0)

Report
Copy link

Link copied!

Hi @Hardesh15 ,
I appreciate your help, however it doesn't seem to be working.
Any suggestions as to how I could go about fixing this.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Requesting you please share whole flow screens and each expression(write in comment like i did ) so that i could see what is wrong in your flow.

Thanks
Hardesh

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

Like (0)

Report
Copy link

Link copied!

I really appreciate your help @Hardesh15
formula is: if(empty(items('Apply_to_each')?['Invoice Received']),1,items('Apply_to_each')?['Invoice Received'])
It won't let me run or save the flow because of this error message:

'The template validation failed: 'The inputs of template action 'Compose_2' at line '1 and column '1686' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Compose_2' to be referenced by 'repeatItems' or 'items' functions.

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Put compose 2 action inside Apply to each action. your compose 2 is outside the Apply to each Loop.

Thanks
Hardesh

Was this reply helpful? Yes No