Date/Time picker control & drop downs

[twarb]

Good morning,

I'm trying to build an app that writes to an Excel document so we can keep and print records of working hours on the fly.
My excel list has a column for "team leader" formatted into a drop-down with 3 choices under it- I was assuming that I could replicate this drop down menu in my powerapp as an input directly to the excel spreadsheet but on further inspection it seems as though the drop downs are only really used to filter and display data from a table, not as an input for said table. Is this correct? 

I was also trying to replicate the same thing with a date picker as an input but this seems to be the same case as before. 

Any help is appreciated!
Thanks
TW

[AmDev]

Hi @twarb 

You will be able to add these controls to your gallery and then set their 'Onchange' properties to patch directly to the data source when you select a new value:

Example for 'onchange' property patch of the drop down in your gallery:

Patch(YourData, ThisItem, {ChoiceField: DropDown1.Selected.Value})

[twarb]

Hi @AmDev 

Is there something wrong with this or am I just stupid? It's probably the latter.

Many thanks
TW

[AmDev]

Hi @twarb 

Try - 

Patch(Table3,ThisItem, {'Team Leader':Self.Selected.Value})

[twarb]

Hi @AmDev 

Really sorry, still getting the same error :S

Many thanks
TW

[AmDev]

Hi @twarb - Is the corresponding field in excel an excel dropdown? - if so can it be changed to normal text?

[twarb]

Hi @AmDev 
Yes it is an excel dropdown, I have changed this but it has made no change from what I can see initially. I'll take a closer look now just to make sure it's not my data source being disconnected because I updated it or something.

Many thanks 
TW

[AmDev]

Hi @twarb - yeah it does funny things when changing the backend and/or when testing with your excel open. Try closing down your excel and refresh the data in Power apps. You also may need to delete the last ')' of your patch statement and re add it to reset the error.

I just tried all of the above locally and it worked fine - Note this assumes you have hard coded your values into the Items property of your dropdown [1,2,3,4] or ["test", "test2" etc] for text

[twarb]

Morning @AmDev 
I'm so sorry but it's still throwing errors at me. I'm sure I'm missing something obvious 

Many thanks
TW

[AmDev]

Hi @twarb - sorry for the delay.

What is in the items property of your dropdown in Power Apps?

Also, can you confirm that the column you are trying to modify in excel is a standard cell with 'General' data format?