Unanswered

Apply to Each Repeating

(0) Share

Report

Posted on by RHamm

I am attempting to create a flow that checks to see if a specific value exists in an excel doc, and if not, adds a row with that value. I have the flow working, however it repeats the add row function multiple times.

For example, imagine my spreadsheet is blank and I want to check to see if the name "Joe" exists. When the flow runs and finds that "Joe" does not exist, I want to add a row with "Joe" in the name column. What I end up with currently is multiple rows with "Joe" in the name column. See below image.

Here is how I have my condition block set up:

Once I get "If no" figured out, I intend to set "If yes" to update the row. One step at a time though...

Thanks for any help!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Ellis Karim 12,026 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RHamm ,

You can use the filter array action to find all the rows that contain a specific value in a column:

You can then use the length function to see how many records were found by the Filter array action. A value of zero means no rows were found that matched the filter query:

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
RHamm 13 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response. I found a solution to this particular problem by using "configure run after" settings. I could still use some help in understanding the update a row function. I have been trying to get it working for a while but no luck.

What I would like is to determine what cell should be updated in my excel doc based on answers to Survey123 survey questions.

The first question would determine which row:

The second question would determine the column:

And the data to be entered into the cell would be determined by answering a date question:

For reference, here's how my excel doc is set up:

Thanks again for any help!

Was this reply helpful? Yes No