How to do if any Column missing error

Help Studio
3

Hello @Ram_Gurav1
Try the following Steps

  1. Download the excel sheet from the mail.
  2. Read the Excel sheet
  3. Use Flow decision or IF conditions
    3.1 If you Know column count, use it for example 5 columns “DT.Columns.Count=5”, if 5 columns are present it will process the next step, Else you can send the mail to sender with specific messages
    3.2. Otherwise use the lookup data table and search for desired value in DT, if the value presents it shows the index number else, it will results “-1”, Based on it you can frame condition like Not LookuValue=-1, same an above flow for then and else.
    image