Answered

Form input via a combo box. Need option to select the looked-up item from combo box item or do a fill in value

(0) Share

Report

Posted on by RoAz1

I have a form inputting values to a first sharepoint list. For one of the fields, I'd like to give the user the ability to:

Either select the looked-up value from a second sharepoint list (from the dropdown)

have the ability to do a fill in value like a text input

And of course, for these values to save on my first sharepoint list.

When I set up the combo box with the looked up item, it does not allow "fill-in". If I use a dropbox, I can do a "fill-in" choice, but then I can not look up my items from the 2nd sharepoint list. Appreciate any insight or work around please.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RoAz1 ,

Using a Combo Box, the Items will be your second list field (or a filter on this if needed)

Sort( SecondListName.SecondListFieldName, SecondListFieldName )

The DefaultSelectedItems will be (assuming the first list field is a Text field)

{SecondListFieldName: ThisItem.YourFirstListFieldName}

The Update of the Data Card (this is the bit you are asking) - if the user types in Text (ensure Allow Searching is switched on) without selecting an item, it will save this.

Coalesce( ComboBoxName.Selected.SecondListFieldName, ComboBoxName.SearchText )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RoAz1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for your response,
I'm not sure I'm doing the correct thing, I can do a "Fill-in" entry in the dropdown now thank you; but it's still not saving anything on my first sharepoint list. I'm attaching 2 screenshots: one for the datacard and one for the dropdown. I don't think my coalesce is correct?
Also when editing an existing entry (I'm using the same form for new and edit), how can I have the dropdown to show what's currently saved in the sharepoint list (even if it was a fill-in entry/searchText that was saved on sharepoint)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RoAz1 ,

Dangers of engaging keyboard before brain is properly in gear . . . now corrected. Your Data Card Update should be

Coalesce( ComboBox3.Selected.ProjectAddress, ComboBox3.SearchText )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RoAz1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz it worked 😉

Was this reply helpful? Yes No