Patching Gallery Checkbox Back To OneDrive Excel

(0) Share

Report

Posted on by Oscar-W

Hello,

I can't work this one out:

So the current setup is a gallery recalling a Excel table. There is a hidden label (MTGTF) that recalls a text value from an Excel column Completed which is hidden. The text value is either True/False.

The check boxes then reads the hidden label and updates as:

If(MTGTF.Text = "True", true, false)

But I want this to be interactable and able to patch the tick as TRUE and a lack of tick as false as it's a task/timetable complete app.

My current OnSubmit code is:

Patch(Timetable,
 ForAll(Filter(Gallery2.AllItems, MTGCheck.Value),
{
 Completed: If(MTGCheck.Value = true, "TRUE", false, "False")
 }
 )
)

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Oscar-W 49 on at

Like
a
(0)

Report
Copy link

Link copied!
So I'm somewhere further with this topic but not there completely.

I changed the database to a Sharepoint List. and the OnSubmit code is now:
ForAll(Gallery2.AllItems, Patch('R2R Timetable', Gallery2.Selected, { Completed: ThisRecord.MTGCheck.Value } ) )

So this only updates the last selected value (last one ticked or unticked). I tried taking out the record selection of patch completely to just:
ForAll(Gallery2.AllItems, Patch('R2R Timetable', { Completed: ThisRecord.MTGCheck.Value } ) )
but then it doesn't do anything this way.

I suppose I just don't understand why the ForAll is not iterating how I would expect it to.

Was this reply helpful? Yes No
Verified answer

Oscar-W 49 on at

Like
a
(0)

Report
Copy link

Link copied!
This was the patch:

ForAll(Gallery2.AllItems, Patch('R2R Timetable', ThisRecord, { Completed: ThisRecord.MTGCheck.Value } ) )

Was this reply helpful? Yes No