Unanswered

If Excel value is blank, do nothing

Like (0) Share

Report

Posted on 2 Dec 2020 18:50:34 by Community Power Pla...

Hello all...

I have a Flow with a Condition (to append or replace data in a SharePoint list) based on the value in an "ETL Action" column of an Excel spreadsheet. It either creates or updates rows in that SharePoint list depending on what value has been populated in that ETL Action column. If the value is "New," it creates a new row. If it's anything other than new, it updates existing rows. I want to add a condition where if the value in the ETL Action cell of an Excel row is blank, then do nothing, or terminate the Flow. Considering how I have it set up below, does anyone know how to accomplish this?

All responses (9)

Answers (0)

jaanihsm 300 on 12 Mar 2024 at 22:14:58

Like (0)

Report

Re: If Excel value is blank, do nothing

Hi! Did you get this resolved? I am also having the same result. Blank and non-blank values are ignored.
Community Power Pla... on 07 Dec 2020 at 15:23:52

Like (0)

Report

Re: If Excel value is blank, do nothing

@krootz OK, thank you. I added the filter and it works in that if a cell in the ETL Action column is blank, that row is ignored, but the Flow is also ignoring rows where there is a non-blank value in a cell within the ETL Action column.
krootz 458 on 04 Dec 2020 at 20:33:02

Like (0)

Report

Re: If Excel value is blank, do nothing

@Anonymous those '' are two single quotes (')
Community Power Pla... on 04 Dec 2020 at 14:32:49

Like (0)

Report

Re: If Excel value is blank, do nothing

@krootz Thank you. I'm getting a syntax error though. To confirm; you used this style end quote (") as opposed to 2 of these (') ?

"message": "Syntax error at position 10 in 'ETL Action (New or Update) ne \"'.\r\n
abm abm 32,506 Most Valuable Professional on 02 Dec 2020 at 22:30:32

Like (1)

Report

Re: If Excel value is blank, do nothing

Hi @Anonymous

Couple of ways you could do this.

1. Add a filter query . See below here Name is my column name and checking not equal to blank.

This will filter only the records where Name is not null.

2. If you want to iterate the full record and make a decision then add another condition under your current IF condition where the else part is. Here you need to check Name is equal to blank. Do not set any values

Here under the else you can have your Get Items actions and other logic.

Thanks
krootz 458 on 02 Dec 2020 at 22:28:04

Like (1)

Report

Re: If Excel value is blank, do nothing

@Anonymous Example below works against an excel file I have and excludes where the DRIVER is blank using DRIVER ne ''
Paulie78 8,416 Moderator on 02 Dec 2020 at 22:21:23

Like (0)

Report

Re: If Excel value is blank, do nothing

Unless I misunderstand the question, I agree with @krootz - but it's hard to say as your question comes across slightly differently in each of your comments:
I want to add a condition where if the value in the ETL Action cell of an Excel row is blank, then do nothing, or terminate the Flow.
You do not need a condition if the blanks have been removed with a filter. Your existing condition will continue to work as before, you simply won't hit any blanks and therefore you would have no need to create a condition.
Community Power Pla... on 02 Dec 2020 at 21:49:17

Like (0)

Report

Re: If Excel value is blank, do nothing

@krootz Thanks for your response. It's an end user request. Instead of deleting rows from the source file that aren't ultimately included in this business process, they want to just clear the ETL value for those rows.

Any hints on how one would use dynamic content or write that expression in the filter query?
krootz 458 on 02 Dec 2020 at 19:50:32

Like (1)

Report

Re: If Excel value is blank, do nothing

@Anonymous if you're not doing anything when the value is blank, why include them in the first place?
You can use the filter query on your list rows action to not include blank.