Dynamic Array Index in Condition

(0) Share

Report

Posted on by stuckonafeeling

Morning!

Just started so I am trying to wrap my head around this issue:

->get string from email subject

->get worksheet (static)

->get tables (dynamic based on worksheet)

->check if any table's name is in the subject

->if yes, get first empty row

->populate first empty row with dynamic values from email

The issue that seems to be making the flow fail is dynamically passing the first empty row to update a row. I tried setting null as a value, following steps for indexing all empty rows and returning the first, and a few other things. Thoughts?

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Update a row action should be inside a loop, since you are referencing an item from the action above.

Are you able to post a screenshot with your Update item action expanded?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @stuckonafeeling

still confused on what you meant by - I tried setting null as a value, following steps for indexing all empty rows and returning the first, and a few other things.

as @SudeepGhatakNZ said, kindly expand the update row action to get more idea. Also i feel that since you referencing empty row in your mentioned steps- does the row with empty row (means no data in any columns) was added earlier ? if not- it was better to use add a row action to add a row with details making things simple 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
stuckonafeeling 10 on at

Like (0)

Report

@Nived_Nambiar @SudeepGhatakNZ

I am happy to use a simpler method. I tried just add a row but it seemed that because I used a dynamic reference for the table to look at, it would not allow me to use null.

Get a row:
Update a row:
Happy to explain anything further or provide more screen shots.

Thanks!

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @stuckonafeeling

one thing to ask, if from column is empty/null , does it mean that other column values/all columns are also empty ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
stuckonafeeling 10 on at

Like (0)

Report

@Nived_Nambiar Yes. The table is blank unless it is populated by this Flow.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @stuckonafeeling

Then what i did not understand is what is problem which you are facing with add row to table ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
stuckonafeeling 10 on at

Like (0)

Report

@Nived_Nambiar
The issue is that everything that I have tried to put in for row has given me an error when I try to add a row. I am probably missing something simple, but I just want it to add data from the email to the first empty row in the table. What goes in the row entry below?

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @stuckonafeeling

coming to row field- you have to add the json object which i see you have added in update a row.

Now also i would recommend to use table id instead of name dynamic content in table field.

See whether that helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
stuckonafeeling 10 on at

Like (0)

Report

Table ID seems to have done the trick. Thanks!

Was this reply helpful? Yes No