Power Platform Community Forum Thread Details

Hello Power Apps Community,

I have an auditing app that I have created. There are 18 questions that can be answered Pass, Fail, Failed but remediated, N/A. When selecting either fail options a text box appears for notes and a camera icon to take a photo. I am able to create a image collection and associate the question number to the image.

At the end of the audit, I have a collection of Audit questions that were responded with a failure and this uploads fine into SharePoint. It is however finding a way to upload the pictures as attachments either during the ForAll patch.

ForAll(
 AuditQuestions As AuditQ,
 If(
 Or(
 AuditQ.QuestVal = "Fail",
 AuditQ.QuestVal = "Fail but resolved immediately"
 ),
 If(
 CountRows(QuestionPics) > 0,
 RemoveIf(
 QuestionPics,
 (Int(AuditQ.QNum) - 1) = Int(QuestionNum)
 );
 );
 
 Collect(
 QuestionPics,
 Filter(
 AuditPics,
 QuestionNum = AuditQ.QNum
 )
 );
 Patch(
 'EHS Audit Findings',
 Defaults('EHS Audit Findings'),
 {
 'Audit Area': AuditArea,
 Auditor: Auditor,
 Question: AuditQ.QNum & ": " & AuditQ.Quest,
 'Auditor Comments': AuditQ.QuestComments,
 'Finding Criticality': {Value: AuditQ.QuCrit},
 'Audit ID': AuditID,
 'Finding Type': {Value: AuditQ.QuestVal},
 'Audit Date': Today()
 }
 );
 Patch(
 'EHS Audit Findings',
 LookUp(
 'EHS Audit Findings',
 And(
 'Audit Date' = Today(),
 'Audit ID' = AuditID,
 Question = AuditQ.QNum & ": " & AuditQ.Quest
 )
 )
 
 )
 )
);

Audit Question (AuditQ) collection

Audit Pics Collection

I have a Form with an attachment Data Card that I use QuestionPics (Filtered copy of AuditPics based on the current question item from the ForAll loop) set on the Update Attribute.

Any direction or support would be greatly appreciated!

Categories:

Building Power Apps