Answered

ComboBox and input of individual values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi @,

I have a ComboBox in my PowerApps where it is possible to select values from a SharePoint list.

But I also want to be able to enter a new, individual value.
This works also so far, only with the update I have now problems.

The individual value is not recognized and therefore nothing is written into the SharePoint list.
I have stored the following values in the ComboBox:

Default = null
DefaultSelectedItems = null
DisplayFields = ["Result"]
Items = Sort(Distinct(mySPList; Title); Result; Ascending)
SearchFields = ["Result"]
Update = 
If(
 IsBlank(ComboBox1.SearchText); 
 ComboBox1.Selected.Result;
 If(
 IsBlank(ComboBox1.Selected.Result); 
 ComboBox1.SearchText;
 ComboBox1.Selected.Result
 )
)

ComboBox1.SearchText, however, unfortunately returns me nothing when I enter an individual text.
Can someone tell me what I am doing wrong here ?
Thanks a lot

Regards

Herb

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

Your Data card update statement should be only this (Not sure why we need 2 if condition)
If( !IsBlank(ComboBox1.Selected.Result); ComboBox1.Selected.Result; ComboBox1.SearchText )

Thanks,
Stalin - Learn To Illuminate
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy,
Thanks for your quick feedback.
It worked for a while with my previous IF loop when updating.
Why it suddenly stopped working is a mystery to me.
I have now used your loop and it works.
Thanks a lot for your help.

Regards
Herb