combo box defaultselecteditems value

(0) Share

Report

Posted on by Bingqiling

321

I have combo box control on the form.
This combo box should load the ticked data here and put this value in sharepoint.

Currently, if I submit the data by putting the checked data in the checkbox, the data will not go in. So I want to change the code in the DefaultSelectedItems attribute of this combo box. However, there is an error and I can't solve it, so please help me,,

Code to change:

If(
 Form1_11.Mode = FormMode.New,
 LookUp(
 Choices([@ITAM_application].reAsset),
 Value = checkvalue.product_name 
//Filter(myListGallery_4.AllItems, Checkbox1.Value) //checkvalue.product_name // Value 
 ), Parent.Default
)

error messege:

Uncomparable type.
Text or Table types are not comparable.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Bingqiling
Here’s a modified version of your formula, assuming both Value and checkvalue.product_name are text:
If(
Form1_11.Mode = FormMode.New,
LookUp(
Choices([@ITAM_application].reAsset),
Value = Text(checkvalue.product_name)
),
Parent.Default
)
In this modified formula, I’ve used the Text function to ensure that checkvalue.product_name is treated as text, which should match the data type of Value in your Choices function. If checkvalue.product_name is already a text, then Text function is not necessary.
If the types are different (e.g., one is a record and the other is text), you’ll need to adjust the formula to ensure you’re comparing like types.
It’s also important to understand the structure of your data and how the Choices function works with your data source. Sometimes, understanding the underlying data types and structures can help in formulating the correct formula.

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

@Jcook hi Thank you for your advice
An error has occurred again. error messege is~
Text or number is required.
Text or number is required at this point in the expression.
Function "Text" has some invalid arguments.

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Bingqiling

If you can provide more details about the checkvalue (such as where and how it’s set), the data source structure, and the specific requirements of your SharePoint list, I can assist more effectively in troubleshooting the issue.
In the meantime, you might try a simpler version of the expression to see if it works, and then build complexity from there:

If(
Form1_11.Mode = FormMode.New,
{ Value: checkvalue.product_name },
Parent.Default
)

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

hi @Jcook
That's what happened.

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Bingqiling

Here’s another attempt at modifying your formula, assuming checkvalue.product_name is a text and you need to match it with a text field in your Choices:

If(
Form1_11.Mode = FormMode.New,
LookUp(
Choices([@ITAM_application].reAsset),
YourTextFieldName = checkvalue.product_name
),
Parent.Default
)

In this formula, replace YourTextFieldName with the actual field name in [@ITAM_application].reAsset that you want to match against checkvalue.product_name.

If checkvalue.product_name is part of a more complex object, you might need to further drill down to extract the specific text value. Understanding the exact structure of checkvalue and how it’s being set in your app is crucial for a precise solution. If you can provide more details about the structure of checkvalue and your data source, it would be helpful in troubleshooting the issue.

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

@Jcook
table name ITAM_appli ITAM_asset
column name reAsset product_name
data type Search(ITAM_asset-product_name) Text

"checkvalue" is a variable, so it's a text type, right?

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Bingqiling

Looks like the variable
is referencing a table.

can you try this:
If(
Form1_11.Mode = FormMode.New,
checkvalue,
Parent.Default
)

if you get an error. Let me
know what the error is. Also can you tell me
what the Items property is for your Combobox

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

hi @Jcook
The error disappeared from the app.
However, it was not stored in sharepoint.
what the Items property is for your Combobox:

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Bingqiling

So the error is gone?
what’s the error now, what do you mean now stored in SharePoint?

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

hi @Jcook
Thank you for your hard work.
There is no error on the screen.
However, if i submit this form, it will not be saved to sharepoint.
It just shows it on the screen and the actual data is not delivered to the DB.
I need to store this data in sharepoint.

Was this reply helpful? Yes No