Announcements
Hello, I have problem in referencing the columns from sharepoint list to PowerApp. I am using the exact same column names, and even tried using the logical names by following the methods in this link: https://www.sharepointdiary.com/2021/01/get-field-internal-name-in-sharepoint-online-using-powershell.html . I kept refreshing my data sauce as well, still it's not working.
My data rows stay within 100, so I guess it's not a problem related to large data set/delegation.
I tried switching to StartsWith function using the same column name I'm trying to reference, it works perfectly. Could anyone please help on this? Thanks in advance!!
@Banana_Pancake
SOME of the function in PowerApps will honor the name change, and some will require the "real/original" name. Those that honor the changed name will also honor the real name.
To determine a column's real name, you can click on the column in the List Settings of your list and then in the address bar of your browser, look at the end of the URL - it will show the real name. You don't need to go through an elaborate PowerShell script to do it!
Find your column names and use them in your formula. If you still run into problems then post back with the actual formula, not just the tool-tip error you are showing.
I hope this is helpful for you.
Search() only works on text type columns. To use it with a complex column like choice, you can use AddColumns() add the value of the choice column to the table and then search on that.
Something like
Search(AddColumns(splist,"choiceval",Choicecolumn.Value),TextInput1.Text,"choiceval") if the choice column allows multiple selectione: Search( AddColumns( splist,"choiceval", Concat( Choicecolumn,Value,", " ) ),TextInput1.Text,"choiceval" )
A
Thank you for your prompt reply! I actually tried with the real name but it's still in error. Below posted the actual formula, URL from the list setting & data type for your reference.
Formula:
Search('Course List',TextInput1.Text,'field_5'))
URL (replace some parts with xxx to avoid company info disclosure):
https://xxxxxxxxxxx/_layouts/15/FldEdit.aspx?List=%7BBBFA752A%2DA45B%2D4E5B%2D902E%2D4BC63C203024%7D&Field=field%5
Many thanks for your help!
@Banana_Pancake ,
Note pattern from @Drrickryp - you need
Search( 'Course List', TextInput1.Text, "field_5" )
Hi @RandyHayes ,I am facing similar issue that my SharePoint choice column is not showing up so I did check the column name in List settings and it is the same.I have posted my query on Forum as well could you please have a look at it Query Regards,Sidhant.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
