Unanswered

Information from excel is not retrieved.

(0) Share

Report

Posted on by Uladzislau Mironau

Hello,

I've created a scheduled cloud flow in PA sending automatic emails which should retrieve variables (dates, address list, etc.) from MS Excel table. In Excel there are various complex formulas to create such variable dynamic.

Until morning October 22, 2024 everything was working great: Power Automate retrieved all necessary information easily.

But starting today even though MS Excel has data in the cell PA retrieves only #Value

Can somebody help to understand what is the issue?

It is also worth mentioning that other information from other cells with formulas as well is retrieved with no problem.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

#N/A represent when there is issue with formula. Could you confirm- whether you are seeing #N/A in excel cell as well ?

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
Uladzislau Mironau 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello! Little update: I went with a kind of "debug" and found reason of such Power Automate error.

Turns out that PA can't understand when you use function "INDIRECT" in MS Excel table and returns "#VALUE!" error.

Or another case is that in INDIRECT I used ref with "Filename", maybe it fully broke the logic, I didn't check to this step.

Either way managed to make the flow run.

Was this reply helpful? Yes No