cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

question with saving dropdown data to sharepoint list

I am currently making a referral system and there is a section i created called area of interest for each area of interest it has it's own dropdown box that contains an AD group so each area of interest has different people in its dropdown. Everytime a user goes into this referral system they will only be saving 1 person's name from the dropdown box from only 1 area of interest. So basically I will be having about say 8 custom dropdowns but only 1 dropdown will technically be saving anything valueable to me at a time. Is there a way I can have all 8 of these dropdown point to 1 column in sharepoint? Say if  I make a seperate column for each field I will have 7 blank fields for each referral that comes in which I dont want. 

 

Ex:

person clicks on area of interest trust and selects in thedropdown that is located there the name alex that is located in the trust AD Group. I want alex to save in a column called refername in sharepoint list.

 

But now the next person goes to make a referral and goes to area of interest mortgage and selects the dropdown and picks the name ron who is located in the mortgage ad group. I want to still be able to save that into the same column called refername.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: question with saving dropdown data to sharepoint list

Hi @alex5p ,

Do you mean that you want to save data in 8 drop downs to the same field?

If so, I suggest you firstly save the data of 8 drop downs to a collection and filter the data that is not blank.

Try this:

set the save button's OnSelect:

ClearCollect(test,{value:dropdown1.Selected.Value},{value:dropdown2.Selected.Value},
{value:dropdown3.Selected.Value},{value:dropdown4.Selected.Value},
{value:dropdown5.Selected.Value},{value:dropdown6.Selected.Value},
{value:dropdown7.Selected.Value},{value:dropdown8.Selected.Value});
//save 8 drop downs' data to the same collection
Patch(tablename,Defaults(tablename),{fieldname:LookUp(test,!IsBlank(Value),Value})
//update with the value that is not blank

 

 

Best regards.

Community Support Team _ Phoebe Liu
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

1 REPLY 1
Highlighted
Community Support
Community Support

Re: question with saving dropdown data to sharepoint list

Hi @alex5p ,

Do you mean that you want to save data in 8 drop downs to the same field?

If so, I suggest you firstly save the data of 8 drop downs to a collection and filter the data that is not blank.

Try this:

set the save button's OnSelect:

ClearCollect(test,{value:dropdown1.Selected.Value},{value:dropdown2.Selected.Value},
{value:dropdown3.Selected.Value},{value:dropdown4.Selected.Value},
{value:dropdown5.Selected.Value},{value:dropdown6.Selected.Value},
{value:dropdown7.Selected.Value},{value:dropdown8.Selected.Value});
//save 8 drop downs' data to the same collection
Patch(tablename,Defaults(tablename),{fieldname:LookUp(test,!IsBlank(Value),Value})
//update with the value that is not blank

 

 

Best regards.

Community Support Team _ Phoebe Liu
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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,336)