Patch dropdown values

[AOZ]

Good day,

I have my sharepoint list with the column Department being of type CHOICE.

In powerapps i am collecting the values (last line):

Collect(ColItemsToKeep, 
{
Order_No: DataCardValue5.Text,
Covid_choice: DataCardValue37.Value,
Je_Respecte: DataCardValue60.Value, 
EPI_ND: DataCardValue35.Text, 
Acces_cabine: DataCardValue61.Value,
Je_Realise: DataCardValue104.Value,
Autres_Commentaires: DataCardValue6.Text,
Department: DataCardValue13.SelectedItems
}
);

Then i am patching some values along with the Department value collected to the sharepoint list (still last line):

ForAll(ColItemsToKeep,Patch('Take5 V1',Defaults('Take5 V1'), 
{
Title: Order_No,
Covid_Choice: Covid_choice,
Je_Respecte_Les_Regles: Je_Respecte, 
EPI_ND: EPI_ND, 
Je_Dois_Acceder_a_la_Machine: Acces_cabine,
'Sanitize Cabin': Sanitize_cabin,
'Sanitize Keys': Sanitize_Keys,
'Autre(s) Risque(s)': Autres_risques,

'I Plan': Je_Planifie,
I_Plan_Comments: Je_Planifie_Comment,

SAFE: Je_Realise,
'General Comments': Autres_Commentaires,
Department:Department

 }
));

 I am however getting an error:

The type of this argument 'Department' does not match the expected type 'Record'. Found type 'Table'.

Help please...all other values are correctly being collected and patched.

Thanks.

[AOZ]

@RandyHayes 

>>> You are right - i had to amend another place where the collection was used. Works perfect now!

Thanks!

Pens Up!

If it does go away, then you need to look at EVERY other place that you are doing anything with that collection in your app to see if you are setting that column to a different type.

[RandyHayes]

@AOZ 

Yep...when you do those type of hand-made schema definitions, you have to make sure you are always matching the types or there will be issues.

Just to "pen" in one more plug for the future - when you capture the .Updates property of your form into a collection, it will have the complete schema of the record from your datasource already in it and thus, there is none of this type of hand-made schema needed.

Glad you are getting things rolling though.

[ivanortiz20220]

tengo un problema parecido tengo una 2 listas despegles en cascada es decir una depende de otra ( estas tienen su origen de datos en sp ) pero al momento de enviar la info a sp no me sale , quiero hacer el patch  ( tipo de columna en sp donde quiero que vaya la informacion es opcion )   y  cabe decir que la columna en sharepoint sta vacia porque le doy informacion en power apps  en la seccion item con esta formula

Distinct(Filter(TIPOMA_CENTRO;Categorias= Padrelist.Selected.Value);Title)