web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Checkbox input to excel

Power Apps

Answered

Checkbox input to excel

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, i really wanted to know how to input a text "C" if the checkbox is checked into my excel database. Because right now it only can input true or false. I want it to, if it checked then "C" if no then " ".

I didnt use form, because i cant freely put it anywhere i want. I have almost 30ish of checkbox and i want to link it to my excel at the same time using button.

Please help 😞 i'm new to power apps

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

The following will patch the column 'ColumnName' to the text 'C' if the checkbox control 'CheckBoxControlName' is selected. Is that what you mean?

Patch( DataSource, Defaults(DataSource), {ColumnName: If(CheckBoxControlName.Value = true, "C", " ")} )
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Omg yes! Thank you so much 🥹 you just save my project ☺️

Join the conversation