web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Update via ComboBox se...

Power Apps

Answered

Update via ComboBox selection, or TextSearch property of ComboBox if ComboBox is blank

(0) Share

Report

Report

Posted on by SBuchanan

8

I am using a SharePoint list as my data source. I have a choices column, which is set to allow manual input, and allow "Fill-in" choices.

I am trying to update this field via a ComboBox in PowerApps. If the ComboBox is blank, the field should be update with whatever the user has typed into the TextSearch field of the ComboBox (user can add choices manually if theirs isn't available).

I am using the following formula on the 'Update' property of the data card:

If(IsBlank(SubcategoryCB.Selected), SubcategoryCB.SearchText, SubcategoryCB.Selected)

This results in the error: "Expected record type". To my understanding, having the "Fill-in" option ticked in the SharePoint list should make this work.

Any help would be much appreciated!!!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @SBuchanan

Please try:
If(IsBlank(SubcategoryCB.Selected), {Value: SubcategoryCB.SearchText}, SubcategoryCB.Selected)

Because SubcategoryCB.SearchText is a type Text instead of a record.

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
SBuchanan 8 on at

Like (0)

Report
Copy link

Link copied!

@SpongYe That worked! Thank you so much!!!

Was this reply helpful? Yes No

Join the conversation