{"id":330,"date":"2021-09-16T08:27:43","date_gmt":"2021-09-16T08:27:43","guid":{"rendered":"http:\/\/4us2use.at\/?p=330"},"modified":"2021-09-16T08:27:43","modified_gmt":"2021-09-16T08:27:43","slug":"make-power-apps-sharepoint-dropdown-lookup-field-searchable-for-contains","status":"publish","type":"post","link":"http:\/\/4us2use.at\/?p=330","title":{"rendered":"Make Power Apps SharePoint Dropdown (Lookup Field) searchable for “contains”"},"content":{"rendered":"\n

Problem:<\/strong><\/p>\n\n\n\n

If you use SharePoint as data source in Power Apps and you have dropdown fields for lookup fields, they’re only searchable as “begins with” but not for “contains”.
This is caused by SharePoint, if you use the default Items value Choices(). <\/p>\n\n\n\n

Solution:<\/strong><\/p>\n\n\n\n

You can get around this problem by building a collection.
The only trick, that also the update to SharePoint works, is that the collection may only consist of the columns “Id” and “Value”. You can achive this with the following formula:<\/p>\n\n\n\n

ClearCollect(colMyCollection ,
ShowColumns(
RenameColumns(ListWithLookupValues,”ID”,”Id”,”Title”,”Value”)
,”Id”,”Value”
)
);<\/p>\n\n\n\n

Now use the collection in the dropdown Items property.
That’s it…<\/p>\n\n\n\n\"1\"2\"3\"4\"5 (No Ratings Yet)
<\/span><\/span>Loading...<\/span>\n","protected":false},"excerpt":{"rendered":"

Problem: If you use SharePoint as data source in Power Apps and you have dropdown fields for lookup fields, they’re only searchable as “begins with” but not for “contains”. This is caused by SharePoint, if you use the default Items value Choices(). Solution: You can get around this problem by building a collection. The only … <\/p>\n

Continue reading “Make Power Apps SharePoint Dropdown (Lookup Field) searchable for “contains””<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11,6],"tags":[18,17,14,16,15],"_links":{"self":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/330"}],"collection":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=330"}],"version-history":[{"count":1,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/330\/revisions"}],"predecessor-version":[{"id":331,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/330\/revisions\/331"}],"wp:attachment":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=330"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}