Unanswered

Sharepoint dependent field: Internal name vs. Display name not displaying

(0) Share

Report

Posted on by bpansy4

I have a form populated from a sharepoint list: Vendor Arrangement Question Checklist where the user selects a vendor from a different sharepoint list, and the corresponding contact person gets filled in from the lookup capability when I first built the SP list.

for items in the contracting data card I have:

Filter(Choices([@'Vendor Arrangement Question Checklist'].'Vendor:Internal Contracting'), Id = DataCardValue1.Selected.Id)

No errors, but no data. Any thoughts here?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @bpansy4 ,

Firstly queries on "secondary" fields in a Lookup column (you have both 'Internal Contracting' and Id in there) are not supported with Delegation in SharePoint. Also the Choices(ListName.FieldName) only outputs one field (Value ), so 'Internal Contracting' is simply not available to be referenced. I suggest you reconsider your data structure without Lookup columns - they are not necessary and may cause you a lot more grief than this. I do not and probably never will use them.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
bpansy4 on at

Like (0)

Report

Thanks for the explanation. It's frustrating that the lookups work fine when using the sharepoint form. Oh well. I suppose I have just add the second SP list as another data source and do the lookup that way?

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @bpansy4 ,

You need simple text or numeric fields and do any looking up with Power Apps. Lookup columns only "work well" when you do not change any of the "default" settings that Power Apps creates and even then have restrictions such as you cannot sort by them nor use StartsWith in a Delegable manner.

Was this reply helpful? Yes No