Answered

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

(0) Share

Report

Posted on by Raizo

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Raizo 66 on at

Like (1)

Report
Copy link

Link copied!

mmbr1606,
Worked like a charm! Thanks!

Was this reply helpful? Yes No
Raizo 66 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Raizo 66 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No