ComboBox values with SharePoint Lookup column

(0) Share

Report

Posted on by lreyes

Howdy experts!

Working on an app for tracking Orders, so building the initial Order Table to track them.

I've got a SP List with a Lookup Column to the different Vendors we have. There are regular Vendors and Quick order Vendors. So, I'm trying to filter out the Quick ones.

I'd like use the Choices code since it helps simplify updates when using the SubmitForm. Is there a way to modify the code "Choices([@NPDpos].POvendor)" so that it doesn't show the Quick ones (Which is a boolean column)? So far, I've been unsuccessful.

I've tested going down the Filter path "ShowColumns(Filter(Vendors,QuickVendor = false),ID,Title)", and I'm able to get the right Vendors. But then I'm struggling to Update the SP column, not sure how/what to point to. From what I understand, I'll need to use Patch to push the different fields.

Any insight is much appreciated!

Thanks a bunch!

Lou

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
try below (Might be helpful)

Set Items Property of Dropdown

Use:

Filter(Vendors, QuickVendor = false)

Configure Dropdown Fields

Set:

DisplayFields: ["Title"]

SearchFields: ["Title"]

Was this reply helpful? Yes No
Suggested answer

PowerDeveloperTP 453 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello,

If you're using a submit form, set the DataCard’s Update property to:

{ Id: ComboBoxVendor.Selected.ID, Value: ComboBoxVendor.Selected.Title }

If using Patch instead of SubmitForm:

Patch(
NPDpos,
Defaults(NPDpos),
{
POvendor: {
Id: ComboBoxVendor.Selected.ID,
Value: ComboBoxVendor.Selected.Title
}
}
)

Please let me know how it goes. Thank you.

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
lreyes 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you PowerDeveloperTP!

It worked :-)

Was this reply helpful? Yes No