I have problem to search and display an item's value (string) in SharePoint
Attached the screen capture
The column's name is "ML reference number", and I use the "ML_x0020_reference_x0020_number".
But it said The specified column 'ML_x0020_reference_x0020_number' does not exist.
A similar script works fine when data course is an excel file in OneDrive
Text(Value(Right(First(SortByColumns(Search(Table2,Text("DC-")&Text(Today(),"[$-en-US]yyymmdd"),"ML_x0020_reference_x0020_number"),"ML_x0020_reference_x0020_number",Descending)).'ML reference number',2)+1),"[$-en-US]00")
However, if the script runs with SharePoint, it failed.
Thanks in advance
Solved! Go to Solution.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.