Unanswered

Remove Null in Table

(0) Share

Report

Posted on by mglemser

Hello,

I have a Power Automate flow where I create a table and then add rows to the table. It is adding the data in the second row. Is there a way I can get this data to populate in the first row instead?

Output:

I was thinking to add another step to delete rows where Source Language is null but can't figure out the logic.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@mglemser ,

I would just add an if condition above Add a row into Table action to check if the Source language is null.

Was this reply helpful? Yes No
Drakewilson 17 on at

Like (0)

Report

    Connect the data set.
    Drop any measure or dimension which contains the NULL values.
    Right-click on the NULL value. Select "Exclude."
    Drop the Column on the Filter Shelf.
    Deselect the "Null" from the options.

Regards,
Drake

Was this reply helpful? Yes No
mglemser 82 on at

Like (0)

Report

Thank you for your suggestion, however, there actually aren't any nulls in the data set. When I add rows, it's adding them in the second row. As you can see in the below example, it added 3 new rows but still had a blank row first.

Output:

Was this reply helpful? Yes No
mglemser 82 on at

Like (0)

Report

Thank you for your suggestion, however, there actually aren't any nulls in the data set. When I add rows, it's adding them in the second row. As you can see in the below example, it added 3 new rows but still had a blank row first.

Output:

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

I see that your loop runs three times which leads me to think if there is something wrong with your excel file.
When you created a Table in your excel did you leave an empty row there?

Was this reply helpful? Yes No
mglemser 82 on at

Like (0)

Report

Hi Sudeep. You are correct. I left an empty row when I created the table. I fixed it and it worked correctly. Thank you!!

Was this reply helpful? Yes No