web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Names and email id is ...

Power Apps

Suggested Answer

Names and email id is not stored in Sharepoint

(0) Share

Report

Report

Posted on by srikant

6

Hi All,

I have create a data type of name and email field as single line of text, and connected to office 365 , But when data is inputed in combox box.

It is not saved in sharepoint. Can you please suggest what need to update so based on search on powerapps it will stored in sharepoint

Regards,

Sriku

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

LessCodePaths 100 on at

Like
a
(1)

Report
Copy link

Link copied!
Have you save them to the datasource?

Using Patch() or SubmitForm() functions?

Let's imagine,

You have a ComboBox named ComboBoxField that contains the records with Email and Name.

Your SharePoint list is named YourSharePointList.

The columns in the SharePoint list are also named Email and Name.

Here's the Patch formula to save new item:

Patch( YourSharePointList, Defaults(YourSharePointList), { Email: ComboBoxField.Selected.Email, Name: ComboBoxField.Selected.Name } )

Explanation

YourSharePointList: Name of your SharePoint list.

Defaults(YourSharePointList): This creates a new item in the list.

ComboBoxField.Selected.Email and ComboBoxField.Selected.Name: These fetch the Email and Name values from the selected item in the ComboBox.

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi srikant,

I have added a Combobox in my app with the following formula in the Items (assuming you have something similar) -

Combobox Items:

Office365Users.SearchUser({searchTerm:ComboBox1.SearchText})

In the fields, I have selected DisplayName and Mail

I then added a button on the screen to save the values in the email and name fields (both single line of text).

Patch formula on the button:

Patch( SPList, Defaults(SPList), { Email: ComboBox1.Selected.Mail, Name: ComboBox1.Selected.DisplayName } )

If you are using a form to save the details in SharePoint, use the following on the update property of the form datacards.

//For Email ComboBox1.Selected.Mail // For Name ComboBox1.Selected.DisplayName

If you are going to patch multiple selections in your Combobox, use the following on your button:

ForAll(Combobox1.SelectedItems As Item, Patch( SPList, Defaults(SPList), { Email: Item.Selected.Mail, Name: Item.Selected.DisplayName } ))

Hope this helps.

LessCodePaths - really like your response and the explanation. :) I think you will need to replace Email and Name with Mail and DisplayName cause I think Combobox is using Office365Users for Items.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No

Join the conversation