You’re offline. This is a read only version of the page.
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
Hi @twarb - Great work, glad you got that working.
I would recommend kicking off another thread on the bulk patch operation
Also provide as much info as possible about exactly what it is you want to bulk patch i.e. assuming it's the same excel; is it just to create new items or to modify existing; is it all items in your table or is it just specific items that the user can select before hitting the button. Also, what info do you want to patch, is it dynamic based on user selection of another field or is it hard coded?
Many thanks
Hi @AmDev
I appear to have solved it with the following string:
Patch(Table3,Defaults(Table3),{'Team Leader': Dropdown2.SelectedText.Value})
Is there now a way to make the same button patch multiple sets of data into multiple columns?
Many thanks!
TW
Hi @twarb
Can you try this slight modification to your patch statement highlighted in red: .......Dropdown2.Selected.Value})
Hi @AmDev - apologies for the late reply, I have been wrapped up in a few things.
My items property for the dropdown is as follows:
The column I am modifying in Excel is formatted to general cells yes.
I have also tried again using the exact coding from the Microsoft website and it's still sending me errors for reasons beyond me (see below)
Any help is appreciated, I am totally lost!!!
Many thanks
TW
Edit: I've changed from "Client" to "Team Leader" as they're two different columns and I thought that swapping columns may help (it did not) and I've transferred the patch formula to a button for user friendliness.
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?
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
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
Hi @twarb - Is the corresponding field in excel an excel dropdown? - if so can it be changed to normal text?
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
