ERROR BC30451

Help Activities
, ,
1

I want to develop MonthlyReport.xaml to generate reports using Excel data. It’s supposed to read an excel table, and filter it by its status(if the invoice is unpaid). i use read range to read the table, but when i try to use a column name, I get this:
image
why does it happen?

2

Hi @tentatie,

Looks like this column is not even there in the output of read range activity.

Can you verify?

  1. if it’s actually in the data table variable?
  2. also if you are trying to use the right column name? Check for spaces

Regards
Sonali

3

Hi @tentatie ,
this issue can appear for more than one reason like below:

  1. Column Name Not Recognized
  2. Case-Sensitive Column Name
  3. Read Range Without Headers

so my recommendation is to check below cases:

  1. Open your Excel file and verify the exact column name, including any spaces or special characters.
  2. Ensure that the Add Headers checkbox is checked in the Read Range activity. This allows the first row of the Excel sheet to be treated as column names.
  3. Reference the Column Name Correctly in the DataTable

please make sure from above notes and if there is still issue please share with us screen for activity properties and debug section

1 Like
4

Share the snap how are you using ?