Combobox not saving my selected item in Sharepoint List

[fher97]

Hi,

I have 4 comboboxes, Combobox1 have a dependent list to Combobox2 and Combobox3 have a dependent list to Combobox4.

I am using 3 lists in sharepoint to get the dropdown list for each combobox.

Combobox1 item formula is the next:

Distinct(tiendasnew;CADENA)

Combobox2 item formula is:

Distinct(
    Filter(
        tiendasnew;
        CADENA=DataCardValue12.Selected.Result
    );
    tiendaname
)

Combobox3 item formula is:

Distinct(SKUSN;Tipo)

Combobox4 item formula is:

Distinct(
    Filter(
        SKUSN;

        Tipo=DataCardValue14.Selected.Result
    );
    DescriptionMaterial
)

all 4 dropdown list works perfectly but when I submit the form, in my sharepoint list the values for my columns (Cadena, Tienda, Tipo and DescriptionMaterial) are empty, could you please help me out?

I am a little bit new in Powerapps and I've been searching for a solution but it still don't work.

Thank you all.

[v-xiaochen-msft]

Hi @fher97 ,

So, most importantly, what is your submission formula?

Are there any errors in your app? What is the error message?

Did you use the SubmitForm() function? 

If so , please check the Update property of your datacard.

Please provide more information, these formulas alone cannot help to determine where the problem is.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[fher97]

Hi @v-xiaochen-msft 

Thanks for your answer, I'll give you out the context,

This is the form:

There isn't any kind of errors in the powerapp just when I push the submit button the columns for CADENA,Tienda, Tipo, Producto doesn't show anything in my sharepoint list, it only shows up blank values.

that is the formula for the submit button.

I don't what can it be.

If you can help me out it would be great, thanks

[v-xiaochen-msft]

Hi @fher97 ,

What's your update property of each datacard?

What's your DataSource property of edif form control?

What's CADENA,Tienda,Tipo,Producto columns' data type in sharepoint list?

Are you adding a new record or modifying a record?

Please provide more information.

Best Regards,
Wearsky

[fher97]

Hi @v-xiaochen-msft 

The update property for each datacard is:

Each datacard has the update property of the DatacardValue located in each field, which will be the dropdown list.

The datasource for my edit forms comes from two sharepoint list named tiendasnew and SKUSN

for Tiendasnew list the title is a code and the other columns are just short text lines, I extract values from columns tiendasname and CADENA for the dropdown list in the form with the formulas I exposed before.

For SKUSN list the title is a code, and I extract the list from Tipo and DescriptionMaterial Colunm for my dropdown list, all columns are short line text too.

Data type for each one of the columns are short line text.

I am adding new records to the sharepoint list I linked to submit repeatedly this form, 

when I fulfilled every combobox in the form and i press submit button the list doesn't get my Cadena, Tienda, Tipo, Producto values, it shows up like this:

I don't really know what I am doing wrong.

Please help me, I tried to give you all the information that you asked for. if you need another one please let me know. Hope you can help me out.

Thanks

[v-xiaochen-msft]

Hi @fher97 ,

So, what's the data type of these columns in picture?

Are they 'Single line of text' columns?

If so , there should be an error in the formula of the update property of your datacard.

You could see that I reported an error here.

If you have the same error, please modify the formula as follows:

Your datacardvalue name .Selected.Result

instead of 

Your datacardvalue name .Selected

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[fher97]

Hi @v-xiaochen-msft 

I thought they were Single line of text, but it results that the 3 columns are choice or option type.

In this case how can I fix these columns to get the value I choose from my powerapp for the 3 comboboxes?

Because if I use this formula my datacards gets an error:

Your datacardvalue name .Selected.Result

I get this type of error:

name isn't valid, it doesn't recognized the type of identifier.

Hope you can help me out.

Thanks for your time.

[v-xiaochen-msft]

Hi @fher97 ,

Now, I know where the problem is.

Please try this formula:

{Value:Your datacardvalue name.Selected.Result}

instead of 

Your datacardvalue name .Selected.Result

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.