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 / Grab text from Sharepo...
Power Apps
Answered

Grab text from Sharepoint text column and add to power apps text field

(0) ShareShare
ReportReport
Posted on by 66

Not sure if this is possible but here is the scenario:

SharePoint list: FCTminutes
Column Name that I would like to pull data from: 'FCT Norms' 
Title: School Name (text Field)

PowerApps Fields:
dpSchool: School Name (dropdown)
txtFCTname: FCT Team name (text field)
txtFCTNorms: FCT Teams Norms (multi-line text field)

I would like to automatically pull the most recent entry from FCT Norms sharepoint field where Title (School Name) and Name in 'FCT Norms' Sharepoint field, equal the values in dpSchool and txtFCTname field on the canvas app. If there is a match in those two fields  then add the most recent data in the 'FCT Norms' Sharepoint list and add it to txtFCTNorms text field. 

 

any help would be most appreciated. 

Categories:
I have the same question (0)
  • Verified answer
    mmbr1606 Profile Picture
    14,615 Super User 2026 Season 1 on at

    hey @Raizo 

     

    can u try this:

    Items property of dropdown

    Distinct(FCTminutes, Title)
    

     default property:

    Default = LookUp(FCTminutes, Title = dpSchool.Selected.Result && 'FCT Team Name' = txtFCTname.Text, 'FCT Norms')
    

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Raizo Profile Picture
    66 on at

    mmbr1606,

    Worked like a charm! Thanks!

  • Raizo Profile Picture
    66 on at

    mmbr1606,

    Quick question, so there may be 20 entries that match the School and FCT name... The Norms may change however so I just want the most recent norms. Right now does this code pick up the first instance and/or is there I way I can pick up the most recent instance, e.g, the last entry by the School (Title) and FCT Name?

     

  • mmbr1606 Profile Picture
    14,615 Super User 2026 Season 1 on at

    you could try this for the default instead:

    If(
     CountRows(Sort(Filter(FCTminutes, Title = dpSchool.Selected.Result && 'FCT Team Name' = txtFCTname.Text), Modified, SortOrder.Descending)) = 0,
     "No matching records found",
     First(Sort(Filter(FCTminutes, Title = dpSchool.Selected.Result && 'FCT Team Name' = txtFCTname.Text), Modified, SortOrder.Descending)).'FCT Norms'
    )
    

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Raizo Profile Picture
    66 on at

    Thanks. This looks like it works but gets a deprecation error. This might be unavoidable, and I may not have more than 2000 records each year.

    screenshot 5.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard