cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Dropdown problem

Hi, I'm having this problem where I want to put a column on the update property, however it does not show up as an option and I do put it manually it has an error. 

dropdown.png

The current code inside is this: Dropdown1.Selected.'Assigned To'

 

Could be an important info, the

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Dropdown problem

Thanks @Neil82 ,

I was confirming it was Text. So stepping through it, I am fairly certain I know the issue - Your drop-down is based on a Collection

ClearCollect(
   colTreasuryTeam, 
   {Name: "Korone"},
   {Name: "Subaru"},
   {Name: "Rushia"}
)

So its output has to be Dropdown1.Selected.Name - there is no other possibility and that is the value you can see underneath as this is perfectly correct. However if this is causing an error in the Update property, there is only one reason - Name is a Reserved Word and the code is causing ambiguity, so you will have call it something else. To test the theory change the collection

ClearCollect(
   colTreasuryTeam, 
   {MyName: "Korone"},
   {MyName: "Subaru"},
   {MyName: "Rushia"}
)

and then in the card Update

Dropdown1.Selected.MyName

 and see if you get an error.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

9 REPLIES 9
Highlighted
Super User III
Super User III

Re: Dropdown problem

Hi @Neil82 ,

What is the Items property of the drop-down?

You also have a valid value of Name underneath - is this significant?

Also what type of field is the control based on?

Highlighted
Super User III
Super User III

Re: Dropdown problem

@Neil82 ,

I will be offline shortly due to time zone.

If your target field is anything other than plain Text, you will also need a different syntax on the update.

I will pick up your response in the morning.

Highlighted
Helper II
Helper II

Re: Dropdown problem

This is what's inside the item property of the dropdown: colTreasuryTeam.

 

I have colTreasuryTeam as on OnStart of the App: ClearCollect(colTreasuryTeam, {Name: "Korone"},{Name: "Subaru"},{Name: "Rushia"});

 

The Name value is significant, I will be using it as default value for the forms, as I want the forms to be opened and just be updated/edited rather than actually writing the info from scratch. The app is basically just click a ticket and editing the necessary info so I can forward that to the involved parties via email (I have yet to figure out how to do this). 

Highlighted
Super User III
Super User III

Re: Dropdown problem

Hi @Neil82 ,

Assuming that the target field is Text, your DataCard Update is 

Dropdown1.Selected.Name

If it is a Choices column it is

{Value:Dropdown1.Selected.Name}

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Highlighted
Helper II
Helper II

Re: Dropdown problem

Hi, doesn't seem to work. I am still getting errors sadly. I want to make the dropdown be able to update the sharepoint list. And the user can manually change who the ticket is assigned to.

Highlighted
Super User III
Super User III

Re: Dropdown problem

@Neil82 ,

What is the error and what type of column is the target field?

Highlighted
Helper II
Helper II

Re: Dropdown problem

Here's my Sharepoint list:

for.png

I want the dropdown to update the 'Assigned To' column. I've tried Dropdown1.Selected.'Assigned_x0020_To' but it doesn't seem to work.

Highlighted
Super User III
Super User III

Re: Dropdown problem

Thanks @Neil82 ,

I was confirming it was Text. So stepping through it, I am fairly certain I know the issue - Your drop-down is based on a Collection

ClearCollect(
   colTreasuryTeam, 
   {Name: "Korone"},
   {Name: "Subaru"},
   {Name: "Rushia"}
)

So its output has to be Dropdown1.Selected.Name - there is no other possibility and that is the value you can see underneath as this is perfectly correct. However if this is causing an error in the Update property, there is only one reason - Name is a Reserved Word and the code is causing ambiguity, so you will have call it something else. To test the theory change the collection

ClearCollect(
   colTreasuryTeam, 
   {MyName: "Korone"},
   {MyName: "Subaru"},
   {MyName: "Rushia"}
)

and then in the card Update

Dropdown1.Selected.MyName

 and see if you get an error.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Highlighted
Helper II
Helper II

Re: Dropdown problem

Thank you, that worked. I will post again when I hit another blocker, you have saved me a ton. Thank you again!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,789)