You’re offline. This is a read only version of the page.
Announcements
5
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..
Hi @Kylete33 ,
You cannot refer to Power Apps elements such as field or control names dynamically in Power Apps (except for a small number of exception not relevant in your case).
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Share
Report
All responses (
Answers (
