web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to use the column ...
Power Apps
Unanswered

How to use the column name as variable with sharepoint list

(0) ShareShare
ReportReport
Posted on by 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.

Kylete33_1-1703139479063.png

 

Kylete33_4-1703140564735.png

 

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

Kylete33_2-1703140173985.png

 

but, with variable, it's not working.

//Set(this_feb_actual, LookUp(OriginalFC, Project_Name = test11, columnname_jan));  ==> not working

Kylete33_3-1703140395029.png

 

 

Do you konw the solution to clear the issue?

two characters of Year is dynamical variable.

ex) Jan-23, Jan-24, Jan-25.. 

 

Categories:
  • WarrenBelz Profile Picture
    156,732 Most Valuable Professional on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 330

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

Last 30 days Overall leaderboard