Patching into a gallery using ThisItem

(0) Share

Report

Posted on by Digital

1,207

I'm building a simple questionnaire. The questions are populated from a SharePoint list.

I make the following collection which I want to use to collect the responses and eventually patch to a different SharePoint list that stores completed questionnaires.

ClearCollect(
 colQuestionnaire,
 AddColumns(
 ShowColumns(
 'SharePointQuestions',
 "QuestionNumber",
 "QuestionText"
 ),
 "Answer",
 false
 )
)

colQuestionnaire is used in my gallery items

I've used a flexible height gallery contains a label for the question text and a toggle button.

I thought I could use the following formula in the OnCheck/OnUncheck

Patch(colQuestionnaire,ThisItem,{'Answer': true }) // OnCheck

Patch(colQuestionnaire,ThisItem,{'Answer': false}) // OnUncheck

The problem I'm getting is I need to click twice in order to get the radio to change.

I'd be grateful for help getting this working.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Digital ,
There is nothing wrong with your logic - your collection is three columns from SharePointQuestions with a Boolean addition Answer as false. You have mentioned a toggle button - I assume you mean a checkbox?
I use almost exactly the same methodology (checkbox) in a collection-based gallery I have for crew selection for jobs and just checked and they select first time. Please confirm this is a checkbox.

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz ,

I was using a the toggle control but have switched to a checkbox. The buggy behaviour may have been due to preview mode not rendering the flexible gallery. Clicking a control in one gallery row was changing controls in other rows.

It’s behaving much better in play mode, although still not perfect. Whenever I use flexible height galleries they always seem a bit glitchy but that’s another issue.

Was this reply helpful? Yes No
WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Digital ,
It must be a bug as your code should do exactly as you intend on the checkbox. I do not use this type of gallery much and have never done so in an editable item, so cannot relate much as far as experience in what you are doing.

Was this reply helpful? Yes No