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.

7 REPLIES 7
v-xiaochen-msft
Microsoft
Microsoft

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
Microsoft
Microsoft

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
Microsoft
Microsoft

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
Microsoft
Microsoft

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.

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 Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (46,056)