Auto-Update Excel Null Error

(1) Share

Report

Posted on by BW145

Hi, I get the following Error when trying to update an excel file. I get the following Error at the Update a row step.

Error Message.png

This is what my flow looks like. The Excel Script is to create a table which it successfully does and the variable created is the name of the table created.

Flow 1.png

Flow 2.png

I have tried these options available as well as just value by removing body.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Looks like your "List rows" isn't returning any data and you are trying to reference a value in the array.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @BW145

Body/Value is right but its probably empty.

Change the Mode of Power Automate back to Classic (top right corner) from New

Then go to Details of the Flow

Pick a flow that failed

Pick the List Rows Action

Look at the Raw Output and Output (its all together)

Its probably [] meaning empty

So you should place a Condition before that checks the length(Dynamics Value output of List Rows)

then say is greater than

0

Then in the Yes side add your code.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
BW145 17 on at

Like (1)

Report
Copy link

Link copied!

I have the following settings on for the list rows actions. Is this not correct?

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

@BW145

We won't know if what you are pointing at has a Table or its the right table etc.

That's why i want you to look at the Run itself (per my other response)

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Table actually expects an ID not name. Try this approach

Was this reply helpful? Yes No
BW145 17 on at

Like (1)

Report
Copy link

Link copied!

I've tried this by setting the variable to be the Table ID, still does not work

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

What error do you get? Can you a post a screenshot of the flow?

Was this reply helpful? Yes No
BW145 17 on at

Like (1)

Report
Copy link

Link copied!

I get the following error message.
Below is a screenshot of my flow

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Your Apply to each loop must not be referring the correct field. The following field is the one you should be referring to

outputs('List_rows_present_in_a_table')?['body/value']

Was this reply helpful? Yes No
Verified answer

BW145 17 on at

Like (1)

Report
Copy link

Link copied!

I managed to fix the issue by using add a row instead. This isn't exactly what I wanted but was the closest solution I could find

Was this reply helpful? Yes No