Answered

toggle update Excel file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a toggle that I want to connect to my Excel file. When the toggle is on I want to update my excel file with Yes or something.

I have also problem with that the toggle is connected to all my work items. So when the toggle is on it is on for all work items. Please see the last picture.

toggle oncheck.jpg meeting booked.jpg

toggle on workitems:

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you show me your error message?

I've made a similar test but not met the same problem like your description.

Here's my test:

OnCheck: Patch(Table1,Defaults(Table1),{'Meeting booked':true})

OnUncheck: Patch(Table1,Defaults(Table1),{'Meeting booked':false})

Both of them worked.

About your secord question, please try to set the toggle's Default: ThisItem.'Meeting booked'.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft
So my code should be like below?

OnCheck: Patch(Tickets,Defaults(Table1),{'Meeting booked':true})
OnUncheck: Patch(Tickets,Defaults(Table1),{'Meeting booked':false})

What should I write instead in the red marked text?
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The red part is decided by whether you want to create a new record or edit an existing record.

If you want to create new record, you need to use this formula:

Patch(tablename,Defaults(tablename),{....})

If you want to edit an existing record, you need to use this formula;

Patch(tablename,the item that you want to edit,{....}) // you could use many formulas to represent the item that you want to edit, for example: LookUp,First(Filter()),gallery.selected.

And the formula that you use "ThisItem" is ok too.

Here's a doc about Patch function for your reference: (I think maybe you do not kown a lot about this function)

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

So could you tell me your error message?

Best regards,