title: Check Stored procedure has retured a value
body: <p>I am a newbie to Datafctory. As part of my pipeline, I execute an sp to fetch the next record to process using Lookup and then use the returned value in a Set Variable. </p>
  
  <p>If the SP returns noting then the Set Variable fails with the following error </p>
  
  <p>Activity SetBatchId failed: The expression 'activity('usp_get_next_archive_batch').output.firstRow.id' cannot be evaluated because property 'firstRow' doesn't exist, available properties are 'effectiveIntegrationRuntime'.</p>
  
  <p>Is there a way in DF to check the property exists before using it</p>
  
  <p>thanks</p>