Answered

Help: Creating Gallery based on Lookup field

(0) Share

Report

Posted on by shayhurst

Hi everyone, this one has really bugged me and I really would like someone to put me out of my misery. Scenario: I have two SharePoint lists, one called Client List and one called Client Deals. In Client Deals I have a look up column called 'Client Name:' and this field points to the single line of text field in Client List called 'Client Name:' . The issue I am having is I cannot return a gallery list in PowerApps using the data Client Deals, which I want to be able to do so deal status can be updated on the fly.

The following code should work, it does if I replace 'Client Deals' with 'Client List'. What am I doing wrong/ missed, please?

SortByColumns(Filter('Client Deals', StartsWith('Client Name:', TextSearchBox1_1.Text)), "ClientName", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Categories:

Using Apps Using Formulas

All responses (7)

Answers (1)

Verified answer

shayhurst on at

Like (0)

Report

Re: Help: Creating Gallery based on Lookup field

Ok, I have solved it with the help of a Shane Young YouTube video. The ClientName field needed to read, ThisItem.'ClientName:'.Value as it is a lookup field. 😅 🙌

https://www.youtube.com/watch?v=G4pWRzzCDAM
shayhurst on at

Like (0)

Report

Re: Help: Creating Gallery based on Lookup field

Ok, so I have read that spaces in a lookup field name are bad. When I removed the spaces I managed to get the gallary returning results, except for the lookup field 'ClientName:'. The error now reads,
shayhurst on at

Like (0)

Report

Re: Help: Creating Gallery based on Lookup field

Hi, appreciate the help but I am afraid not. Same error.
BoHamad 87 on at

Like (0)

Report
Re: Help: Creating Gallery based on Lookup field

Uset Sort insted of SortByColumns

Sort(Filter('Client Deals', StartsWith(ClientName.Value, TextSearchBox1_1.Text)), ClientName.Value, If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Hope This help
shayhurst on at

Like (0)

Report

Re: Help: Creating Gallery based on Lookup field

Help states..
shayhurst on at

Like (0)

Report

Re: Help: Creating Gallery based on Lookup field

Thanks for the advice. Still didn't work, I am afraid. Also changed the second column name to "Client Name:" as this is how it is set out in the SharePointList. The issue is the lookup column and I cannot find anything specific to help.
SortByColumns(Filter('Client Deals', StartsWith('Client Name:', TextSearchBox1_1.Text)), "Client Name:".Value, If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
BoHamad 87 on at

Like (0)

Report
Re: Help: Creating Gallery based on Lookup field

hi @shayhurst

i thought if you want to use a look up column you should use .value or .id after the name of the col For Ex.
SortByColumns(Filter('Client Deals', StartsWith('Client Name:', TextSearchBox1_1.Text)), "ClientName".Value, If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

hope this help
Best Regards,