Patch all items of gallery to a different source

(0) Share

Report

Posted on by asafweis

181

Hi,

I have a gallery called GalleryQuestions with source of SurveyQuestions that has a number of items. The gallery has a radio control in each record for the user to choose an answer. A little like a likert scale.
I'd like to patch a related table called QuestionResponses for each record in the gallery GalleryQuestions.

I thought I could do something like this:

ForAll(GalleryQuestions.AllItems, Patch(QuestionResponses, Defaults(QuestionResponses),{Answer: ....}))

However, the field Answer from table QuestionResponses is not recognised as only fields in SurveyQuestions are available.

Any ideas?

asaf

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@asafweis

Your code should work fine. I just tested something similar and your structure worked for me. Not sure what's going on?

Some things you could check:

- The column 'Answer' hasn't had it's name changed or is a complex column type, etc.

- Is there any other code before/after this code that maybe affecting it?

- Have you included all required fields in your record to be Patched?

Was this reply helpful? Yes No
asafweis 181 on at

Like (0)

Report
Copy link

Link copied!

Thanks for giving this a go.

Did you have a different datasource for the gallery items than the patching destination?

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@asafweis

Yes.

Gallery data source = List1, Patch data source = List 2.

I even added a Radio control to the gallery and referenced that in my Patch

Was this reply helpful? Yes No