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

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to capture and sto...
Power Apps
Unanswered

How to capture and store the value of lookup column into a text field.

(0) ShareShare
ReportReport
Posted on by CTJohnson 26

I need some help figuring out how to capture and store the value of lookup column into a text field.

 

*There are 2 Sharepoint Lists: EmployeeDirectory and EmployeeYearbook

*EmployeeYearbook is driven by the employee's name, and has 3 lookup columns to pull the info from EmployeeDirectory: Team, Supervisor, Position. 

 

I need to be able to store the outcome of each lookup column into a text field so that it can be used in an associated PowerApps.  

 

I have hit a wall after many hours trying to figure this out.  I tried a flow in Sharepoint but that only worked for one column.

 

Any ideas would be greatly appreciated

Categories:
Building Power Apps
I have the same question (0)
  • EddieE Profile Picture
    EddieE 4,641 Moderator on at

    @CTJohnson 

    There's no need to copy the LookUp values to a Text field just so they can be used in a PowerApp. PowerApps can read/display LookUp column values without issue.

     

    If you need that data as type Text then I think Power Automate is your best solution, and it should be able to do what you need for more than just 1 column.

  • WarrenBelz Profile Picture
    WarrenBelz 155,544 Most Valuable Professional on at

    Hi @CTJohnson ,

    It is good not to use Lookup columns at all and store the data in text columns, but that is another discussion. If you have a drop-down on your Form selecting the Lookup column value desired,

    then put the text column also on the Form (you can hide it if you want) and make the Default the DropdownName.Selected.Value.

     

    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

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 387

#2
timl Profile Picture

timl 340 Super User 2026 Season 1

#3
Vish WR Profile Picture

Vish WR 301

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans