cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ACD0236
Level: Power Up

Writing in Excel from a dropdown in PowerApps

Hi guys, just a quick question for which I haven't found the answer elsewhere...

 

I've got a PowerApp which is based on a Excel table stored in ODFB. It works well: when I write something in a field in the app, it gets written in the corresponding cell in the table.

 

But how do I do this with, say, a dropdown list or a radio button? For example, I have a "gender" field. Instead to have the user to type in "man" or "woman" or whatever (which is open to spelling errors, interpretations, different abbreviations) I would like to propose a dropdown list (or a radio button) from which to choose. But how do I get this choice to be written in the corresponding cell?

 

I'm new to this platform and until now I've only written some little, simple programs in Java, so I'm sorry if this is an obvious question but I really can't get this solved.

 

Thank you in advance, regards!

1 ACCEPTED SOLUTION

Accepted Solutions
Hoffmanrat
Level: Powered On

Re: Writing in Excel from a dropdown in PowerApps

I'm new to this also so I can't offer an in depth explanation nor guarantee that the way I have done it is the best but maybe I can set you down the right path.

 

 In my App I have an allowed value form type and although I previously had multiple selections available which worked fine the requirement I have is better addressed as a single option.

Image and video hosting by TinyPic

 

Before you customise your form you change it to an allowed values list on the options screen. I'm showing you on a second item as the option is removed from ApprovedStatus now that it has been customised.

 Image and video hosting by TinyPic

In the advanced settings I have linked to a table in the excel, also stored in ODFB, for Allowed Values and this is where you would have your drop down options.

Image and video hosting by TinyPic

 

As I said, I'm new too, and can understand how difficult somethings are to get to work that are probably very simple for the more experienced users. I have rarely found a direct answer or instruction for any of the things I wanted to do but I have almost always found something that sends me down a path of trial and error, hopefully this might do that for you.

4 REPLIES 4
Hoffmanrat
Level: Powered On

Re: Writing in Excel from a dropdown in PowerApps

I'm new to this also so I can't offer an in depth explanation nor guarantee that the way I have done it is the best but maybe I can set you down the right path.

 

 In my App I have an allowed value form type and although I previously had multiple selections available which worked fine the requirement I have is better addressed as a single option.

Image and video hosting by TinyPic

 

Before you customise your form you change it to an allowed values list on the options screen. I'm showing you on a second item as the option is removed from ApprovedStatus now that it has been customised.

 Image and video hosting by TinyPic

In the advanced settings I have linked to a table in the excel, also stored in ODFB, for Allowed Values and this is where you would have your drop down options.

Image and video hosting by TinyPic

 

As I said, I'm new too, and can understand how difficult somethings are to get to work that are probably very simple for the more experienced users. I have rarely found a direct answer or instruction for any of the things I wanted to do but I have almost always found something that sends me down a path of trial and error, hopefully this might do that for you.

ACD0236
Level: Power Up

Re: Writing in Excel from a dropdown in PowerApps

Thank you very much for your answer.

 

Following your proposed pathway I set up a secondary table in another Excel datasheet (same file as the main data table, just different sheet) which lists the items for the dropdown menu.

 

I have set the AllowedValues property of the card which holds the dropdown menu as follows.

 

DataSourceInfo(GenderTable;DataSourceInfo.AllowedValues;"Gender")

Where GenderTable is the name of the table and Gender is the name of the column of this table which contains the options for the dropdown list.

 

When I try it out, though, nothing shows up. Am I doing something wrong?

 

Thanks again, have a nice day.

ACD0236
Level: Power Up

Re: Writing in Excel from a dropdown in PowerApps

Nevermind, I got it to work with items from inside the app (I realized I did not really need a specific table and could just input the dropdown list items from PowerApps Studio).

 

Thanks anyway, I'll mark this as solved!

akmiecik1
Level: Powered On

Re: Writing in Excel from a dropdown in PowerApps

What was solution?

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 113 members 4,250 guests
Please welcome our newest community members: