Help with Collecting to a new Collection

(0) Share

Report

Posted on by Millwalluser

I'm using the following code and getting errors.

If(PictureColvar=1,Collect(PictureCol,{Image:UploadedImage2.Image},Question:1)

Errors Recieving with this formulas are as follows:

1. Unexpected characters, The formula contains 'ParenClose' where 'Colon' is expected

2. Name isn't valid. This identifier isn't recognized -

I believe the second error is due to the PictureCol and Question identifiers and I don't know why. PictureCol is a new collection and wouldn't yet be identified yet and Question is part of an existing collection. Please offer any help you can I'

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

Are you trying to create a collection with a record that has a value for both Image and Question when PictureColvar=1?

If so, then it would look like this:

If(PictureColvar=1,Collect(PictureCol,{Image:UploadedImage2.Image ,Question:1})

Was this reply helpful? Yes No
Millwalluser 8 on at

Like (0)

Report

I'll give it a try

Was this reply helpful? Yes No
Millwalluser 8 on at

Like (0)

Report

Yes, this is what I'm attempting to do but for a set of 8 separate distinct audit questions which I have already identified. I tried this solution and I'm still receiving the same errors.

Was this reply helpful? Yes No
Millwalluser 8 on at

Like (0)

Report

I went back and retyped the formula and it worked no errors. Thanks!!!!!!! I'm new to PowerApps and I've been working on this bug for days.

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

The closing squiggly bracket "}" needs to be after the question number.

If(PictureColvar=1,Collect(PictureCol,{Image:UploadedImage2.Image ,Question:1})

Was this reply helpful? Yes No