So I have a collection named col_combined; there are nearly 50 rows in this, so for obvious reasons I will use the first row as an example of my issue.
col_combined
| RatingScore | RatingTitle |
| 1 | Access / Egress |
the collection itself is fine - but I have a rather big Patch expression at the end of my app - for tidiness sake I have only included the the line related to "Access / Egress"
ForAll(col_actionRequired,
Patch(
'Form - Site Inspection Reports',
Defaults('Form - Site Inspection Reports'),
{
'Primary Key': _formName,
Name: _uploaderName,
'Project Number': _projectNumber,
Signature: signatureOutput.Image,
'Problem Area': problemArea,
'Action Required': actionRequired,
'Have the changes been made?': "No",
'Access / Egress': LookUp(col_combined, RatingTitle="Access / Egress").RatingScore
}
)
);
The whole expression is underlined in red and gives two messages:
- "The type of this argument 'gg_pub'accessegress' does not match the expected type 'OptionSetValue (Site Inspection Rating)'. Found type 'Text'.
- "The function 'Patch' has some invalid arguments.
I kinda understand the message, but don't actually understand what needs to be changed; I have pasted an image of the choice options in the table below - as well as this I think it might be worth mentioning that the value itself is taken from a dropdown (I'm about 90% sure that isn't necessary though)
