Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Stuart Marshall]

I am trying to get dropdowns working in the edit screen. I have inputed them manually from the menu and changed the setup of the originals. I can make them locate the relevant data in Excel to populate the drop down lists in both cases but I can not get the to save the data to excel no matter what I do.

[Warren Belz]

Hi Stuart,

Without seeing all the code, this is a guess, but you might start with the Update properties of the card containing the drop-down. It should be YourDropDownName.Selected.

——————————
Warren Belz
Ventia Utility Services Pty Ltd
Rockhampton Qld Australia
+61 409 315 509
——————————
——————————————-

[Stuart Marshall]

OK, Thank you for this. Still not working. How is the best way to show the code? Thanks Again.

——————————
Stuart Marshall
N0M2E0
——————————
——————————————-

[Warren Belz]

What are the value of the “items” of the drop-down and the “update” of the card it is in?

——————————
Warren Belz
Ventia Utility Services Pty Ltd
Rockhampton Qld Australia
+61 409 315 509
——————————
——————————————-

[Stuart Marshall]

——————————
Stuart Marshall
N0M2E0
——————————
——————————————-

[Warren Belz]

A Distinct formula – the update properties of the card will be VacuumDropdown.Result

——————————
Warren Belz
Ventia Utility Services Pty Ltd
Rockhampton Qld Australia
+61 409 315 509
——————————
——————————————-

[Stuart Marshall]

Thank you sir.

——————————
Stuart Marshall
N0M2E0
——————————
——————————————-

[Stuart Marshall]

Ok, so it works mostly. If I leave one of the original text labels on the edit sheet it will save whatever data I have selected on the drop down menu if I make a change to the text label however if I remove all the text label inputs it no longer saves anything. It behaves like it never recognized a change at all. I have all the Updates formulas set to their respective drop down menus.

——————————
Stuart Marshall
N0M2E0
——————————
——————————————-

[Warren Belz]

I am no authority on Excel backends (I only use them for static reference tables), but if you are referring to the Excel headings “Text Labels”, these are what I believe Excel uses as data column names. I know every time I change anything in the structure of mine (including added columns), I have to disconnect and reconnect to the file.

——————————
Warren Belz
Ventia Utility Services Pty Ltd
Rockhampton Qld Australia
+61 409 315 509
——————————
——————————————-

[Brian Scott]

When you say “make a change to the text label” are you meaning in the Excel sheet? It is rarely a good idea to make changes to an excel sheet that you are using in PowerApps. If you need to make changes to the table I would suggest making the changes you need and then saving it as a different sheet and using that new sheet in the PowerApp – you will need to reset the calls to the sheet.
Since PowerApps adds data a column to the sheet if you manually edit you can mess with the sync.

——————————
Brian Scott
Chief Creative Officer
Concord NC
——————————
——————————————-