Unanswered

Check the value in the excel table

(0) Share

Report

Posted on by deerzzxdell

Hello community, I've been stuck with my flow for a while now.

The flow I've created has to get and read through an excel files => Validate if file is empty => Check each data cells in the table if there's any empty cell => (yes) send email or (no empty) update a Dataverse with data within excel file.

The problem is how I write my code in the second picture after checking a row in excel with apply to each, it will work fine if there's no empty cell in that file. But if there's an empty cell for example in row 20, the first 19 rows would already been added to Dataverse which I don't want that. It needs to be checking all the rows first, then add to Dataverse later if there's no empty.

How should I modify this code.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @deerzzxdell

The true should be passed in the form of expression not as plain text in condition action. Expression needs to be entered in the expression box as shown below:

true

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

cchannon 4,702 Moderator on at

Like (1)

Report

Initialize a new variable near the top of the flow and call it isValid (or whatever you want). Make it a True/False type, and set it to True.

Now, just above your Apply to Each 2, add another loop over your excel items, but this time, one row at a time, check to see if the value is null. If any ever comes back null, then update isValid to false.

Now, just add a condition check: If isValid = true and put Apply to Each 2 inside the If Yes branch.

Was this reply helpful? Yes No