Flow run as intended, but shows as a failure

(0) Share

Report

Posted on by Xaviier

Hi all,

I have 2 excel files where

Excel1 = Compiled Microsoft Forms responses with IDs

Excel2 = Masterfile with matching IDs as Excel1

As mention in the title, the flow works as intended where Excel1 will match Excel2's ID and will populate Excel2's cells accordingly. Though I am able get the matching entries 1:1, flow indicates the run was a failure.

The failure occurred at row 75, 76 & 106 in Excel2. However, the data extracted from Excel1 was still able to populate itself in row 75,76 & 106 accordingly.. I observed that these 3 had Expression result as true

Would love to seek advise and suggestions on this matter.

Cheers

All responses (1)

Answers (1)

Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

Report

Re: Flow run as intended, but shows as a failure

Hi @Xaviier,
The point is the id field is empty or null.
You can use condition to make judgement.