cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicojum
Regular Visitor

Form dropdown not submitting

Hello,

 

There's plenty of topics regarding the matter but I couldn't work out a solution, so here comes my support request; 

 

I  have an app that uses sharepoint as a database. App is used to write hours for work done to the customers. Picture attached (form).

nicojum_0-1634035074317.png

 

Form's datacards are columns from this sharepoint. (Name, Date, Customer, Workdone, Project, TotalHours).

 

I use submit button to submit reported hours back to sharepoint. Submit button - ''OnSelect'' SubmitForm(Form2).

 

I've deleted original Customer datacard from form and added manually a dropdown so that Customer can be selected from sharepoint column options (hundreds of customers).

Customer dropdown linked to sharepoint via Items - Distinct('Time tracking', Customer) code.

 

Problem:

However, when I submit the form - everything else is saved to the sharepoint but this dropdown data is not transferred. I read many articles on this and watched videos but can't understand how this should be coded. 

 

As I've deleted original datacard, should there be a code that says ''if original datacard value is empty, use selected dropdown2 value etc.). And if this would be the solution, Could somebody be helpful and advice how to write this.

 

Appreciate the support as I've hit a brick wall.

 

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @nicojum ,

Assuming this is a Text field you are writing back to, the Update of the Data Card containing the drop-down would be

Dropdown2.Selected.Result

 

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

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @nicojum ,

Assuming this is a Text field you are writing back to, the Update of the Data Card containing the drop-down would be

Dropdown2.Selected.Result

 

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.

 

I have a similar issue. I have a dropdown field that pulls from a list that when selecting the dropdown item and save it the selected item in the field disappear. I'm assuming that i have to put something in the default area or DatasearchItem area. Please help.

 

Kojack1976
New Member

I have this one in the default area..

Value(Choices([@vac].'6-1')

 

 

I have this is the Default search Item section..

If(And(IsBlank(Parent.Default),

IsMatch(ThisItem.'4.3',Value,"Incorrect",Contains)),

{Value;"Unable to Test"),

Parent.Default

)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,902)