Last week, I tried entering Microsoft 365 group names into the Power Apps dropdown control. After doing so, I must submit the selected group name in the Power Apps dropdown to the SharePoint list. I achieved this with the help of the Patch() function in Power Apps.
In this article, I will show you how to save Power Apps dropdown selected value to SharePoint list.
Save Power Apps Dropdown Selected Value to SharePoint List
We can save the Power Apps dropdown selected value to the SharePoint list in two different ways. They are,
- Using the Patch() function [When the dropdown is not in Power Apps form].
- Using dropdown.Selected.Value [When dropdown is present in Power Apps form].
In the examples below, I will explain the two ways of saving the Power Apps dropdown selected value to the SharePoint list.
Saving Power Apps Dropdown Selected Value to SharePoint List Using Patch() Function
I have a SharePoint list here that stores the details of projects assigned to the office groups.
| Column Name | Data Type |
|---|---|
| Project Name | Title(Single line of text) |
| Office 365 Group Name | Single line of text |
| Assigned Date | Date and time |
I took a dropdown control in Power Apps in the SharePoint list for the Office 365 Group Name field. The dropdown selected value will be stored in this SharePoint list for this group field.
To achieve this, follow the steps below!
1. Add the following controls to the Power Apps screen.
- Text input control: For project name.
- Dropdown control: For group name.
- Date Picker control: For an assigned date.
2. I need to get all Microsoft 365 group names in the dropdown control. So, use the formula below for the Items property of the dropdown control.
Distinct(Office365Groups.ListGroups().value,displayName)
3. Add one button control to submit the data to the SharePoint list. And provide the formula below in the submit button’s OnSelect property.
Patch(
'Projects For Office 365 Groups',
Defaults('Projects For Office 365 Groups'),
{
Title: txt_projectName.Text,
'Office 365 Group Name': drp_grpnames.Selected.Value,
'Assigned Date': DatePicker_A.SelectedDate
}
)The Patch() function will submit the details to the SharePoint list. Here,
- Projects For Office 365 Groups is the sharePoint list name.
- Title, ‘Office 365 Group Name, and Assigned Date are the field names.
- drp_grpnames is the dropdown name.
4. Save and publish the app. Then, preview it. As shown above, the dropdown selected value is saved in the SharePoint list.
This way, we use it if we submit details to a SharePoint list from Power Apps without Form control.
Save Power Apps Dropdown Selected Value to SharePoint List [When Dropdown within Forms]
I created a Power Apps form to submit the details of the SharePoint list I explained above. Now, in the form, we need to use dropdown control instead of text input for the Office 365 Group Name field. So, the selected value in the dropdown must be stored in the SharePoint list.
Follow the steps below!
1. In Power Apps, add Edit form control and connect it with the SharePoint list. The image below shows the Office 365 Group Name field in text box control.
2. Add a Dropdown control in place of the Office 365 Group Name field Data card value. Then, you’ll get some errors like the one below.
3. Provide the below formula in the Update property of the Office 365 Group Name_DataCard1.
Dropdown.Selected.ValueBy using this formula, the selected value in the dropdown will be saved to the SharePoint list.
4. Still, another error is present, so provide the dropdown name instead of the previous data card value. Now, use the Distinct function in the Items property of the dropdown to get the Office 365 group names.
Distinct(Office365Groups.ListGroups().value,displayName)5. Provide the below formula in the OnSelect property of the submit button.
SubmitForm(Form1)The SubmitForm() function will submit the details to the SharePoint list.
This way, we can save the selected details in the Power Apps dropdown to the SharePoint list.
I hope you understand how to save the Power Apps dropdown selected value to the SharePoint list from this article.
Follow this article while you’re trying to do the same. You may also like:
- Power Apps modern dropdown control
- Power Apps Radio Button Control
- Filter Power Apps Collection
- Power Apps check box control
- Power Apps cascading dropdown
- Check if the Power Apps dropdown is empty
Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.
