How to concat excel cell values if not empty?

Like (0) Share

Report

Posted on 11 Dec 2018 22:36:15 by Community Power Pla...

Hi there,

I am trying to generate a comma-separated list (string) with values out of an excel-table.

The table has 3 cols: Name, Position, MobileNumber.

I want to make a list of all mobile Numbers, that are not an empty string.

reading the excel rows is working fine, but I still dont understand how to work with the filter-array and select-functions.

I've tried to simply loop through all excel rows in the table while working with a condition (number not empty) and an "attach element to array"-function. Obviously Flow then really loops through ALL table rows, even if they're completely empty. The loop process took about 4 minutes every time I've tested the flow. So I would rather work with filter and select.

Can somebody help me out with this?

All responses (2)

Answers (1)

Community Power Pla... on 13 Dec 2018 at 06:30:41

Like (0)

Report

Re: How to concat excel cell values if not empty?

Awesome, exactly what I need! You made my day, thank you! 🙂
Verified answer

v-yuazh-msft on 13 Dec 2018 at 01:47:17

Like (0)

Report
Re: How to concat excel cell values if not empty?

Hi @Anonymous,

I have made a test on my side to create a excel table as below in my Onedrive for business:

You could refer to screenshot below to create the flow:

The expression in the Filter Array as below:

@not(empty(item()?['MobileNumber']))

The flow would run successfully as below:

Best regards,

Alice