How to save dropdown value in the sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have two SP List:

SPList1 = this is where I'm going to save my data from the form

SPList2 = I'm using this list to populate the value to my dropdown

Now, I add a button for me to save the details in my SPList1 including the value in my dropdown. My problem is, the value in my dropdown which is from SPList2 is not saving in SPList1. Here below is the code I'm using.

Patch(
 'QC Inspection Report',
 Defaults('QC Inspection Report'),
 {
 'Control No.': txtIControlNo.Text,
 'Prepared By': drpEmployeeName.Selected,
 'Business Unit': drpBusinessUnit.SelectedText.Value,
 'Material Type': drpMaterialType.SelectedText.Value
 },
 frmAdd.Updates
);

Note: the column type of my column for dropdown in SPList1 is Single Line of Text.

Hope you can help me on this as I was stuck on this problem.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Anonymous , It should be dropdown.Selected.Value. Please try below:

Patch( 'QC Inspection Report', Defaults('QC Inspection Report'), { 'Control No.': txtIControlNo.Text, 'Prepared By': drpEmployeeName.Selected, 'Business Unit': drpBusinessUnit.Selected.Value, 'Material Type': drpMaterialType.Selected.Value }, frmAdd.Updates );

------------------------------------------------------------------------------------------------------------------------------
I hope this helps.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.
Thanks,
ANB

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @ANB ,

Thanks for your reply.

I tried your solutions above but I encountered an error. See image below.

Thank you

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi,

I tried this one, it's now saving the dropdown field however, my attachments is not saving in the list.

Set( newList, Patch( 'QC Inspection Report', Defaults('QC Inspection Report'), { 'Control No.': txtIControlNo.Text, 'Prepared By': drpEmployeeName.Selected, 'Business Unit': drpBusinessUnit.SelectedText.Value, 'Material Type': drpMaterialType.SelectedText.Value } ); frmAdd.Updates; )

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous , For attachment, please check https://www.youtube.com/watch?v=PqVkYofL6xs
https://www.youtube.com/watch?v=ECwRwjyPAQE

------------------------------------------------------------------------------------------------------------------------------
I hope this helps.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.
Thanks,
ANB

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @ANB , same column name in my SP1, am I going to have a problem on this if the column name of my dropdown field are exactly the same in both of my sharepoint list?

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous , I dont think that would be problem. Thanks, ANB

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @ANB , thanks for the idea. It now resolved my issue. Thanks!

Was this reply helpful? Yes No