web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sharepoint List Lookup...

Power Apps

Unanswered

Sharepoint List Lookup Column in Powerapps

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a SharePoint list with column Job Number - and in the column the numbers are from another list which is looked up.

I am building an app , and I am stuck with Search box of the gallery - the formula to be used.

I want to change the formula to the below , but it isnt working

SortByColumns(Filter([@'Abraj Tower Snags'], StartsWith(JobNum, TextSearchBox1.Text)), "JobNum", If(SortDescending1, Descending, Ascending))

I feel this is because its a value in the sharepoint list is which is being lookedup.

I have put the below too :

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming JobNum is the Lookup column

SortByColumns( Filter( AddColumns( [@'Abraj Tower Snags'], "JobNo", JobNum.Value ), StartsWith( JobNo, TextSearchBox1.Text ) ), "JobNo", If( SortDescending1, Descending, Ascending ) )

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.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The issue now is with the detail screen and edit screen. The formula works fine.

Its something with the gallery.

Could you let me know what is being done above in the formula you have mentioned

Join the conversation