cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlosN
Helper IV
Helper IV

save drop down list

I have a drop down list with these values 500; 1000; 1500; 2000; 5000 and can also be entered values, now I want to save those values ​​in a sharepoint list and then show it in another window. But only the last selected record saves me

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @CarlosN ,

Have you solved your problem?

Could you please share a bit more about the 'CantidadCotizar' field in your SP List? Is it a Text type column?

Further, do you want to save selected multiple options from your CBoxCantCotizar_1 ComboBox/Dropdown box?

 

Based on the formula that you mentioned, I think there is something wrong with it. On your side, you should modify your formula as below:

Patch(
      'Solicitudes Expres';
      Defaults('Solicitudes Expres');
      {
         CantidadCotizar: Left(
                               Concat(CBoxCantCotizar_1.SelectedItems; Value & " - "),
                               Len(Concat(CBoxCantCotizar_1.SelectedItems; Value & " - ")) - 3
                          ),
         ...
      }
)

Note: It is not necessary to create multiple Text Input boxes to collect the number value option, I think your CBoxCantCotizar_1 Dropdown box is OK.

 

Please try above solution, check if the issue is solved. If you have solved your problem or the solution I provided above is helpful in your scenario, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
jlindstrom
Super User
Super User

so you are saying that you want to select multiple values and then save them all to a list?

 

instead of a dropdown you should use a combo box. 

Then you can use ForAll when you Patch

 

Like

List: ForAll(ComboBox1.SelectedItems, {
                '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                Id: Id,
                Value: Value
            })
CarlosN
Helper IV
Helper IV

I don't understand your code

If you want to save multiple items you have to use For all

This can loop through multiple records and save each of them, like how you say


@CarlosN wrote:

 I want to save those values ​​in a sharepoint list


I'm suggesting you ditch the dropdown and replace it with a combo box, then user ForAll to loop through the selected items and create records for all of them.

 

Dropdowns only support single selections--that is whay you are only getting one value.

Thank you,
I couldn't with combo box, I used tex box and other code.

v-xida-msft
Community Support
Community Support

Hi @CarlosN ,

Have you solved your problem?

Could you please share a bit more about the 'CantidadCotizar' field in your SP List? Is it a Text type column?

Further, do you want to save selected multiple options from your CBoxCantCotizar_1 ComboBox/Dropdown box?

 

Based on the formula that you mentioned, I think there is something wrong with it. On your side, you should modify your formula as below:

Patch(
      'Solicitudes Expres';
      Defaults('Solicitudes Expres');
      {
         CantidadCotizar: Left(
                               Concat(CBoxCantCotizar_1.SelectedItems; Value & " - "),
                               Len(Concat(CBoxCantCotizar_1.SelectedItems; Value & " - ")) - 3
                          ),
         ...
      }
)

Note: It is not necessary to create multiple Text Input boxes to collect the number value option, I think your CBoxCantCotizar_1 Dropdown box is OK.

 

Please try above solution, check if the issue is solved. If you have solved your problem or the solution I provided above is helpful in your scenario, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (58,449)