cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fher97
New Member

Combobox not saving my selected item in Sharepoint List

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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.

View solution in original post

7 REPLIES 7
v-xiaochen-msft
Community Support
Community Support

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.

v-xiaochen-msft_0-1617851615911.png

 

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.

Hi @v-xiaochen-msft 

 

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

 

This is the form:

fher97_0-1617919510586.png

 

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.

 

fher97_1-1617919633216.png

 

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
Community Support
Community Support

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

Hi @v-xiaochen-msft 

 

The update property for each datacard is:

fher97_0-1618008287763.pngfher97_1-1618008312494.pngfher97_2-1618008332723.png

fher97_3-1618008348731.png

 

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

fher97_4-1618008626028.png

 

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.

 

fher97_5-1618008764993.png

 

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:

fher97_6-1618008979325.png

 

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
Community Support
Community Support

Hi @fher97 ,

 

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

v-xiaochen-msft_0-1618198460709.png

Are they 'Single line of text' columns?

 

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

v-xiaochen-msft_1-1618198552833.png

v-xiaochen-msft_2-1618198581727.png

 

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.

 

Hi @v-xiaochen-msft 

 

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

 

fher97_0-1618332972215.png

 

 

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:

 

fher97_1-1618333139062.png

fher97_2-1618333174122.png

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
Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,318)