Power Platform Community Forum Thread Details

I'm running 'List rows present in a table' on an small (16 row, 8 column) Excel Table stored in SharePoint.
When examining the resultant array via OUTPUTS, I see "#VALUE!" in a number of rows, for one variable which should contain a text string.
The text string for the problem variable is generated in Excel using a formula [=IF(INT([@[Last Status Update]])=TODAY(),XLOOKUP([@Worker],Table1[Your name],Table1[Daily Status],"ERROR",0,-1),"Not out today")].
This formula produces the correct result when viewed via the Excel App, Excel Online or even when embedded on a SharePoint page, but not when viewed in the Power Automate array.
Outputs which result in "Not out today" appear in the array correctly, but any results which came from the XLOOKUP do not, and just give "#VALUE!".
The XLOOKUP strings are only short (OUT, SAFE & OVERDUE).
I have tried changing the Excel Number Format to Text from General.
I have tried waiting for several hours before running the Scheduled Flow, to ensure that updates have occurred.

Categories:

General topics