Power Platform Community Forum Thread Details

Hello!

My Custom Form has two lookup fields (lookup happens in SharePoint List, not in Power Apps). The user selects the Formal_Role(s) and once the form is submitted, the related Points of Contact appear. The problem is that some Roles have the same Point of Contact. While the list shows up perfectly in the SharePoint List, Power Apps is filtering out the duplicated contact when viewed in the form. I can't see any reason for it doing so. Any ideas on how to get all the contacts to show up even if they are duplicated?

What you see in the SharePoint List:

Employee	Formal Role	POC
Larry	Role1 Role2 Role3	Mary Bob Bob
Sally	Role4 Role5	George George

What you see in the Custom Form:

Formal Role	POC
Role1, Role2, Role3	Mary, Bob
Role4, Role5	George

Formal Role - editable field
Items:

Choices([@Employees].Formal_Roles

POC - view only
Items:

Choices([@Employees].'Formal_Roles:POC')

Thanks for any guidance for this beginner! And thanks to WarrenBelz for the blog guidance on how to post! I think I got it right this time even if I still can't figure out how to tag someone. :)

Categories:

Using Apps Using Formulas

General Questions

Hi Jukiejan

The issue you have I believe is that Lookup "Secondary" fields Choices([@Employees].'Formal_Roles:POC') are not really compatible and generally do not behave in the manner you expect as SharePoint is not a relational database and the Power Apps connector does not support the query. You would be better getting the drop-down choices directly from the second list.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee