Answered

SharePoint Lookup Column Default Combo Box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all

I am having issues with a Combo Box using a SharePoint List as the Items value and looking at another SharePoint List to populate the Default Values. Although it pulls through the values, it does not appear selected and does not pull into Power Automate.

Below is a screenshot of a Combo Box using a Static list of values i.e. ["1","2","3"] which pulls through the values correctly (highlighted above the list and the values are highlighted in the list):

Annotation 2020-05-14 161125.png

Below is the Combo Box which uses SharePoint List data and the default value is populated via a Lookup Column, the value is pulling through however the selected items are not appearing as above:

Annotation 2020-05-14 161211.png

Any ideas as to how this can be resolved?

Thanks

Bradley

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the formula you typed within the Items property of the ComboBox?
Could you please show more details about the LookUp formula within the DefaultSelectedItems property of the ComboBox?

Do you want to pull values from another SP List to populate the Default values within the ComboBox?

I have a collection table to populate a ComboBox, the data structure as below:

The ComboBox populated with the following options:

I have another collection table consists of different Products chosen by the customer, the data structure as below:

I want to filter records from above ProductOrders table where CustomerName is "Kris", then populate the corresponding Product value as Default value within above ComboBox. So set the DefaultSelectedItems property of the ComboBox to following:

ForAll( Filter(ProductOrders, CustomerName = "Kris"), // Filter these records meet the specific criteria { ProductName: Product // Product is the column from my ProductOrders table } )

Note: The 'ProductName' represents the display column value within the ComboBox, on your side, you should replace it with the actual column name in your ComboBox.

Please consider take a try referencing above solution, then apply it to your own scenario, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @v-xida-msft

Thanks for getting back to me.

I tried your solution however, it didn't like.

I have two SharePoint Lists, one covers our Support Tickets and another being a master list for all locations we deal with.

This PowerApp is a nicer interface for our Support Tickets and uses a lookup column to the locations list so that we can note the locations impacted by any issues.

On the page, I have a gallery with all of our tickets which when a ticket is selected, it populates the data within the Ticket Info section:

The Responsible Depot/Port/EDI Vendor Combo Box has the below within the Items section:
SortByColumns('Logistics Locations',"Title",Ascending)

Within the DefaultSelectedItems I have the below:
Gallery1.Selected.'Responsible Depot/Port/EDI Vendor'

Which half works, it does pull through the value within the list - however, it does not pull through to the Selected Items as you can see below with the value not showing as selected (allocated numbers so they can be identified)

I have also checked using a label for both one that does work (R_AffectedDept1 is static values i.e. ["1","2","3"]) against the one that doesn't and using as example above (R_ResponsibleVendor1 is SharePoint List Lookup Column)

Hope this clears up any confusion, if not please let me know.

Thanks

Bradley

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the "Responsible Depot/Port/EDI Vendor" field? Is it a LookUp type column in your SP List (Support Tickets)?

Based on the formula that you mentioned, I think there is something wrong with it. I assume that the "Responsible Depot/Port/EDI Vendor" field is a LookUp type column, which references values from the Title column in your 'Logistics Locations', is it true?

Please set the DefaultSelectedItems property of the "Responsible Depot/Port/EDI Vendor" ComboBox to following:

ForAll( Gallery1.Selected.'Responsible Depot/Port/EDI Vendor', { Title: Value } )

or

ForAll( Gallery1.Selected.'Responsible Depot/Port/EDI Vendor', LookUp('Logistics Locations', Title = Value) )

Note: I assume that you use Title column as Display column value within the "Responsible Depot/Port/EDI Vendor" ComboBox

Set the Update property of the "Responsible Depot/Port/EDI Vendor" field data card to following:

R_ResponsibleVendor1.SelectedItems

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
JHS2019 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

It does not work her, it is not selected in list

Was this reply helpful? Yes No