Hi All,
I'm trying to use power automate to email out holiday details. The flow keeps breaking as it retrieves the string, '#Value!', instead of the number resulting from a formula (256.0) in the example below.
Has anyone come across this issue before?
This was working previously, until combined two data sources, which meant updating the flow and the sheet. However, the formulae are much the same.
I can see the number in Excel, and it has had lots of time to sync with sharepoint.
It struggles to retrieve the values for the above fields, but the nearly identical fields for the current year's holiday is retrieved fine.

Report
All responses (
Answers (