cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lchabut
Level: Powered On

connection to excel and checkbox, other controls

Hi,

I'm connecting an app to an excel spreadsheet. I don't want all the cards on my editform and displayform to be text input cards. Setting the cell format of the excel table to date, I was able to have a date card on my forms in the app. But I couldn't figure out how to get checkboxes or dropdown controls on my cards (for example, that the user can toggle the checkbox and that in the excel field it appears Yes or No according to the toggling).

Thanks

Loic

2 REPLIES 2
Community Support Team
Community Support Team

Re: connection to excel and checkbox, other controls

Hi @lchabut,

 

It would require changing the default controls within the datacard in form control when App generated from Excel Data directly.

Please first follow the article below first:

Understand data forms in Microsoft PowerApps

 

For the Check Box,we could change the Update property of the corresponding datacard with CheckBox.text,

then for CheckBox, change the text property with the code below:

If(Checkbox1.Value=true,"Yes","No")

Doing it in this way, would make the CheckBox change its text to Yes when checked, and show "No" if unchecked.

Hope the information above is helpful.

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lchabut
Level: Powered On

Re: connection to excel and checkbox, other controls

Hi @v-micsh-msft,

Thank you for the reply. Sorry, I don't really understand how I can change datacard default controls to form controls: since I am already in the editform screen generated directly by PowerApps, I think the cards' controls should be already form controls, no?

I tried changing the Update property of my datacard to CheckBox.text but it gives an error message.

Regards,

Loic

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,444)