Unanswered

Power Apps Flows remove empty array item from collection coming at end

(1) Share

Report

Posted on by atif1455

Hi, ,

I have a flow in which i read data from excel sheet split item rows and creates an array containing row items from (excel sheet). Will insert this array iterativley in sql table further.

Issue is parsed array contains an empty row item at the end each time... Suppose I have 6 items rows in excel sheet , parsed splitted array contains those 6 items plus an empty row at the end.

Actual Excel Items:

Actual excel Items.png

Parsed Flow row items in array:

Parsed Array.png

Any idea how to the empty item from the parsed array ..

Regards

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(7)

Report
Copy link

Link copied!

@atif1455

Try this kind of Flow to Filter out blanks by using a Filter Array to filter on expression:

empty(item()) is equal to false

When I tested this it works well.

See if above helps.
nich3play3r 253 on at

Like
a
(2)

Report
Copy link

Link copied!
In case anyone else comes across this post like I did, this code can be extended to refer to a particular column in an array:

@equals(empty(item()?['Email']), false)

In my case, I have valid values for all rows in columns 1 and 2 of my array, but column 3 (Email, above) has some empty row values, which I want to drop from execution.
markota89 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Just an update from 2024 - this is still working perfectly! Thanks, I was struggling with that for too long 🙂