Answered

help.... how to save comb box in sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a combo box with office 365 users in power apps

I want to save the data in a sharepoint list, as I should do it since I use pacth and it gives me the following error

How else can I save the information?

Gracias

Atte,

Yuri Arciniegas Rodriguez

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the error you are receiving?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LRVinNC it does not save the data in the sharepoint list
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Just a quick observation, the first line of Patch() the Defaults() ends with ";;" and it should be ";" .
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Other than the extra semicolon, I would like to ask: what column type is that User column, Text or Person? Since I found that you are using a combo box to select a user name, but use TextInput.Text as the user name instead, which made me confused.

If the User column is a Text type column, then you could modify that "Usuario: TextInput.Text" part in the formula to " Usuario: Combo_usuarios.Selected.'Full Name' "

If the User column is a Person type column, then you will need to modify it to:
Usuario: {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Combo_usuarios.Selected.Email, Department: Combo_usuarios.Selected.Department, DisplayName: Combo_usuarios.Selected.DisplayName, Email: Combo_usuarios.Selected.Email, JobTitle: "", Picture: "" }

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hola @v-jefferni the column is a connection with the office 365 user in a combo box, How do I modify the person column
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

So user is a Person type column in SharePoint list?

If so, replace that "Usuario : TextInput1.Text" part in your patch formula with the whole sentence in my last reply.
Patch( BD_Prototipo; Defaults(BD_Prototipo); { Usuario: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Combo_usuarios.Selected.Email, Department: Combo_usuarios.Selected.Department, DisplayName: Combo_usuarios.Selected.DisplayName, Email: Combo_usuarios.Selected.Email, JobTitle: "", Picture: "" }; Fecha_TTurno: DatePicker1.SelectedDate; Hora_Inicio: Hora_Inicio.Text; Hora_Fin: Hora_Fin.Text } );;

Please have a try, if have any other questions please feel free to let us know.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni thank you very much,