Answered

multi checkbox data not saving to SharePoint

(0) Share

Report

Posted on by CU06021343-1

I'm trying to save the data from my collection (colItems123) in my sharepoint list (Patterns_5S) but my function has an error in the item 'Non-compliant sense'.
Error generated: The type of this argument 'Non-compliant sense' does not match the expected type 'Table'. Found type 'Record

can you help me?

Function I'm using:
ForAll(
colItems123,
Patch(
Standards_5S,
Defaults(Standards_5S),
{
Point: colItems123[@Point],
'Non-conforming sense': { Value:
if(
Checkbox1.Value && Checkbox1_1.Value && Checkbox1_4.Value && Checkbox1_2.Value && Checkbox1_3.Value,
"Selection Organization Self-Discipline Cleaning Conservation",
If(Checkbox1.Value, "Selection" & Char(10), "") &
If(Checkbox1_1.Value, "Organization" & Char(10), "") &
If(Checkbox1_4.Value, "Self-Discipline" & Char(10), "") &
If(Checkbox1_2.Value, "Cleanup" & Char(10), "") &
If(Checkbox1_3.Value, "Conservation" & Char(10), "")
)
},
Status: { Value: colItems123[@Status] },
'Non-compliant Desc': colItems123[@Comment],
AuditID: colItems123[@AuditID],
'Audit Data': colItens123[@'Audit Data'],
Area: colItems123[@Area],
Factory: colItens123[@Fabrica],
Item: colItems123[@'Item 1'],
NumberOfImage: colItems123[@NumberOfImage],
Auditor: colItems123[@Auditor],
Collaborator: colItens123[@Collaborator]
}
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jcnascime1 ,

I am assuming 'Non-compliant sense' is a multi-value Choice field. You need to put it back to single value choice as you are pasting in a string value.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CU06021343-1 on at

Like
a
(0)

Report
Copy link

Link copied!

My SharePoint column is configured as options and allows multiple selections.
Should I change the property of my SharePoint column?

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jcnascime1 ,

Yes if you want to patch a single string to it

Was this reply helpful? Yes No
CU06021343-1 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to come up with this formula where I can save all my data using the choice column which allows multiple selections for the "Senso não-conforme" column

ForAll(
colItens123,
Patch(
Padrões_5S,
Defaults(Padrões_5S),
{
Ponto: colItens123[@Ponto],
'Senso não-conforme': Table({Value: 'Senso não-conforme'}),
Status: {Value: colItens123[@Status]},
'Desc não-conforme': colItens123[@Comentario],
AuditID: colItens123[@AuditID],
'Data Auditoria': colItens123[@'Data Auditoria'],
Area: colItens123[@Area],
Fabrica: colItens123[@Fabrica],
Item: colItens123[@'Item 1'],
NumberOfImage: colItens123[@NumberOfImage],
Auditor: colItens123[@Auditor],
Colaborador: colItens123[@Colaborador]
}
)
)
but the data is saved in this format:

Is there a way to save in this format?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@jcnascime1 ,

Maybe this

'Senso não-conforme': {Value: colItens123[@'Senso não-conforme'.Value]},

Was this reply helpful? Yes No