Power Platform Community Forum Thread Details

Hello,

I'm attempting to run a PA flow that is triggered from a MS form. The form will ideally pull the requested data from an existing excel sheet. The excel sheet is currently setup to auto-update with live data via PIDataLink. However, when this data writes through, it yields "#NAME?" as the formula, rather than the displayed value.

What is the most efficient work around for this? I've attempted to reference the cell in another column with "=C8" for example, however I think since it's still basically a formula, it's rendering this all the same. "#NAME?"

How can I turn this dynamic data into readable cells that PA can work with? I've seen other potential solutions but hard to tell if it directly applies to this issue.

Thanks in advance!