Answered

How to edit excel via checkboxes?

(0) Share

Report

Posted on by TCop93

Hi,

I am new to PowerApps. I have managed to add an excel source and dropdown panels to filter the content. I am now struggling to get 4 checkboxes which will perform edit option, saving selected data onto excel. Only 1 selection is possible. When selected, the data would be transferred to excel file automatically. There are many tutorials on how to do it in here, but I can't get a grip around it - could you kindly advise, step by step, how to achieve it?

The below screenshot shows my current progress:

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Ok... After you select the checkbox you want to add it to the excel, right?

If yes, use a patch function

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

For new Item:

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

For existing item:

Patch(DatSource,
LookUp(DataSource, ID = ThisItem.ID),
{
....
}
)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Was this reply helpful? Yes No
TCop93 42 on at

Like (1)

Report

Thank you 🙂 the patch function works perfectly!

Was this reply helpful? Yes No