Power Platform Community Forum Thread Details

I am getting the below error when I am running Power Automate flow.

Unable to process template language expressions in action 'Check_Trigger_Value' inputs at line '0' and column '0': 'The template language function 'first' expects its parameter be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#first for usage details.'.

This is the expression I have used:

first(outputs('Execute_a_SQL_query_(V2)')?['body/resultsets']?['Table1'])?['TriggerReport']

This is the SQL query, I am using. It will return the result as NULL.
SELECT TriggerReport
FROM abc
where absID = 'SHA'

These two blocks I am using in Power Automate.