I have two lists of sharepoint.
I want to get the data of specific colum name using Lookup().
below is the list of originalFC named.
I want to get the data the value of "Jan-23" column.
as you can see the code above,
when I put the column name directly in ' ', it's working
Set(this_jan_actual,LookUp(OriginalFC, Project_Name = test11,'Jan-23')); ==> working
but, with variable, it's not working.
//Set(this_feb_actual, LookUp(OriginalFC, Project_Name = test11, columnname_jan)); ==> not working
Do you konw the solution to clear the issue?
two characters of Year is dynamical variable.
ex) Jan-23, Jan-24, Jan-25..

Report
All responses (
Answers (