Populate Combo Box items with SharePoint IDs

(1) Share

Report

Posted on by Ami K

15,679 Super User 2024 Season 1

Hi everyone,

I want to set the source column for a combo box with SharePoint IDs. However, when I open the Primary text list via the Data pane, I notice that SharePoint ID is not a selectable option:

As a workaround, I duplicated the column in a collection and set the data source for the combo box to the collection:

ClearCollect(
 collection_name,
 AddColumns(
 sharepoint_list_name,
 "ID_Text",
 ID
 )
);

However, the column (ID_Text) is still not visible in the Primary text list.

Could anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

Heya @Amik

Have you tried setting the datasource for your dropdown to DataSourceName.ID instead of DataSourceName ?

This should leave it no other option than to display the only field it has access to in the dropdown,

Cheers,

Sancho

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

Thanks for the quick response @iAm_ManCat . Unfortunately the combo box returns Null when I attempt to do this on either the Collection or the data source name.

From Collection:

From data source:

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

Ah, so they changed that again - just had a quick look, after changing it to DataSourceName.ID you can then edit the advanced properties of DisplayFields and SearchFields to allow the ID to show:

Hope that helps!

Cheers,

Sancho

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

Brilliant this is working - thank you very much @iAm_ManCat

Was this reply helpful? Yes No