Hi
I am looking to create a collection using the below
ClearCollect(PN,GroupBy('Tbl Part Num','SEARCH REF',"Other")
It is coming up with an error, in the Group by function. I am assuming that it can not find the Column 'SEARCH REF', which is a column name in the sharepoint list.
Thanks in Advance
I have changed the ' to " and is still the same. It seems that the Groupby function cant find the column. I have checked and the column is there and is a text column
Hello,
In the code you posted, it misses a ')' at the end 😄
You can try to put " instead of ' for your SEARCH REF