web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SharePoint list isn't ...

Power Apps

Answered

SharePoint list isn't being updated when using Filter in a ComboBox

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have 2 different lists, ListA has a LookUp column to 'Vendor ID' (Single Text Column) column in ListB. I've created a form for ListA which will be filtering as we fill it out. Once we have selected a 'Vendor Name' in our form, the 'Vendor ID' ComboBox Items should be filtered by looking that person's name on ListB.

Filter(
 ListB,
 'Vendor Name' = DataCardValue11.Selected.Value
).'Vendor ID'

I've tried this and I do get the filtered options correctly. However, when I submit the form, the cell in the SharePoint list is empty. If I use the default option the SharePoint list works, but I am not able to implement the filter functionality.

Choices([@'ListA'].'Vendor ID')

Any help would be appreciated, thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Is this just to find the vendor ID that's associated with the vendor name (1 to 1 relationship) or is there a possibility of multiple vendor IDs per vendor name (many to 1)?

In case of a 1 to 1 realtionship, it's easier to add an additional column from the source list in SharePoint:

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,966 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Firstly, my view is that using SharePoint Lookup columns in Power Apps is generally a pointless inconvenience/impediment unless you want to use the column also directly in SharePoint Edit in Grid View, however that does not solve your immediate issue. The Update of the Data Card should work with

{ Value: ComboBoxName.Selected.'Vendor ID', Id: LookUp( ListB, 'Vendor ID' = ComboBoxName.Selected.'Vendor ID' ).ID }

and the DefaultSelectedItems of the Combo Box

{'Vendor ID': ThisItem.LookupCOlumnName.Value}

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

Join the conversation