absolutely positive that N/A is an option, however it's numerically assigned to 0
just to make sure I change the value selected and ran through it again on the check sheet
wrapping it in Text() and Value () both get this
Appending .Text and .Value changes it to an error
I'm unsure how to use your
'Rating Score': ThisRecord.RatingScore,
lines would work - the collection that the ForAll is working from is different to the one where the ratings are stored so I don't think "ThisRecord" would work. The ForAll uses all in col_actionRequired; all these ratings are being taken specifically from col_combined. I have tried your "'Rating Score': col_combined[@RatingScore]" line but that didn't do much; which lead me down the LookUp path. I feel there is something obvious I'm missing but I've been staring at this problem for so long now I can't make heads or tails of it 😂
I'll append code again at the end of this message- but here's the gist of what I am trying to do just incase it helps you understand my problem a bit more 😅
col_actionRequired stores the name of a problem that received a rating of 1 or 2, as well as whatever the user has written in the app which would serve as a means to mitigate the issues. Each row will repost the same data except for the col_actionRequired parts; which means I have added a toggle just to tick off when the changes have been made.
In the end, my PowerApps table will look (very very abstractly) like this:
| PrimaryKey | Problem title | Problem Fix | Ratings 1-49 |
| key1 | PPE | blah blah blah | x x x x x x x |
| key1 | Access/Egress | blah blah blah | x x x x x x x |
| key2 | First Aid | blah blah blah | x x x x x x x |
| key2 | Fire Precautions | blah blah blah | x x x x x x x |
| key2 | PPE | blah blah blah | x x x x x x x |
| key3 | Tidiness | blah blah blah | x x x x x x x |
Here's the code again; if you have any more questions please do ask as I am at my wits end with this and I am so close to using my laptop as a sled to go down the stairs 😅
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",
'Rest Room / Canteen': LookUp(col_combined, RatingTitle="Rest Room / Canteen").RatingScore,
'Changing Facilities': LookUp(col_combined, RatingTitle="Changing Facilities").RatingScore,
'General Cleanliness': LookUp(col_combined, RatingTitle="General Cleanliness").RatingScore,
'Site offices and welfare electrical cert in date': LookUp(col_combined, RatingTitle="Site offices & welfare electrical cert in date").RatingScore,
'First aid facilities / first aider': LookUp(col_combined, RatingTitle="First Aid Facilities/ First Aider").RatingScore,
Washing: LookUp(col_combined, RatingTitle="Washing").RatingScore,
Sanitation: LookUp(col_combined, RatingTitle="Sanitation").RatingScore,
PPE: LookUp(col_combined, RatingTitle="PPE").RatingScore,
'Fire extinguisher checked & in date - welfare': LookUp(col_combined, RatingTitle="Fire extinguisher in date & checked").RatingScore,
'Environmental Factors': LookUp(col_combined, RatingTitle="Environmental Factors").RatingScore,
'Accident Records': LookUp(col_combined, RatingTitle="Accident Records").RatingScore,
'Statutory forms / registers etc. ': LookUp(col_combined, RatingTitle="Statutory forms / Registers etc.").RatingScore,
'Access / Egress': LookUp(col_combined, RatingTitle="Access / Egress").RatingScore.Value, //line with the current issue
'Signs & Notices': LookUp(col_combined, RatingTitle="Signs & Notices").RatingScore,
'Tidiness - Storage Areas': LookUp(col_combined, RatingTitle="Tidiness").RatingScore,
Flammables: LookUp(col_combined, RatingTitle="Flammables").RatingScore,
Gases: LookUp(col_combined, RatingTitle="Gases").RatingScore,
'Fuels & Lubricants': LookUp(col_combined, RatingTitle="Fuels / Lubricants").RatingScore,
'Fire precautions - Storage Areas': LookUp(col_combined, RatingTitle="Fire Precautions").RatingScore,
'Tools & Equipment': LookUp(col_combined, RatingTitle="Tools & Equipment").RatingScore,
'Spillage kits': LookUp(col_combined, RatingTitle="Spillage Kits").RatingScore,
'Access Equipment': LookUp(col_combined, RatingTitle="Access Equipment").RatingScore,
'Dangerous Materials (COSHH)': LookUp(col_combined, RatingTitle="Dangerous Materials (COSHH)").RatingScore,
'PAT Testing in date': LookUp(col_combined, RatingTitle="PAT Testing in date").RatingScore,
'Quarantine Area': LookUp(col_combined, RatingTitle="Quarantine Area in place & used").RatingScore,
'COSHH - SDS assessments': LookUp(col_combined, RatingTitle="COSHH - SDS Assessments in place").RatingScore,
'LOLER in date': LookUp(col_combined, RatingTitle="LOLER in date").RatingScore,
Scaffolding: LookUp(col_combined, RatingTitle="Scaffolding").RatingScore,
'Ladders & Trestles': LookUp(col_combined, RatingTitle="Ladders / Trestles").RatingScore,
'Working Platforms': LookUp(col_combined, RatingTitle="Working Platforms").RatingScore,
Services: LookUp(col_combined, RatingTitle="Services").RatingScore,
Security: LookUp(col_combined, RatingTitle="Security").RatingScore,
'Extinguisher checked + in date - ConsAct': LookUp(col_combined, RatingTitle="Extinguisher in date").RatingScore,
'Call points checked': LookUp(col_combined, RatingTitle="Call points checked").RatingScore,
Electrical: LookUp(col_combined, RatingTitle="Electrical").RatingScore,
Hoists: LookUp(col_combined, RatingTitle="Hoists").RatingScore,
'Mobile Crane': LookUp(col_combined, RatingTitle="Mobile Crane").RatingScore,
'Lifting Gear': LookUp(col_combined, RatingTitle="Lifting Gear").RatingScore,
Excavations: LookUp(col_combined, RatingTitle="Excavations").RatingScore,
Transport: LookUp(col_combined, RatingTitle="Transport").RatingScore,
'Other Plant': LookUp(col_combined, RatingTitle="Other Plant").RatingScore,
Machinery: LookUp(col_combined, RatingTitle="Machinery").RatingScore,
'Power Tools': LookUp(col_combined, RatingTitle="Power Tools").RatingScore,
'Hand Tools': LookUp(col_combined, RatingTitle="Hand Tools").RatingScore,
'Tidiness - Construction Activities': LookUp(col_combined, RatingTitle="Tidiness").RatingScore,
'Noise Levels': LookUp(col_combined, RatingTitle="Noise Levels").RatingScore,
'Traffic Management': LookUp(col_combined, RatingTitle="Traffic Management").RatingScore,
'Restricted Area': LookUp(col_combined, RatingTitle="Restricted Area").RatingScore
}
)
);
