Create Pivot Tables

[Bellian_otieno]

Are There some changes on the source selection criteria

[B_H_Akshatha_Pai]

Try using suppliers.sheet(“Input”).range(“A1:L1”)
try using round brackets

Regards

[mkankatala (Mahesh Kankatala)]

Hi @Bellian_otieno

Try like this Suppliers.Sheet(“Input”).Range(“A1:L1”)
If above not works try the below one,

In the use excel file activity, in reference as field the name is Excel or Suppliers.

If it is Excel then give like this, Excel.Sheet(“Input”).Range(“A1:L1”)

Hope it helps!!

[Bellian_otieno]

It’s C# syntax totally different with VB that’s why “A1:L1” only “A1:L49” would denote the range