Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to use submit form with three dropdown using a collection to update my SharePoint list and the app to keep the selected values in the box.



This is my app I created down below, it currently not displaying any information since I am using JSON data to pass over onto the next screen.  This works using this formula: 


OnSelect:EditForm(RotaForm);Navigate('Team Rota',ScreenTransition.None,{TeamChannelID:Mid(ThisItem.TeamChannel, Find("?",ThisItem.TeamChannel)+9,36),TeamID:ThisItem.ProductTeamID})



Once I am in this screen I am trying to get the update Rota button to update my SharePoint list with all the dropdown selected alongside the channel ID. 


The formula I use for each datacards to update are: 


Dropdown: "PrimDropdown.Selected.displayName"

same goes for the other two dropdown with those dropdown selected


The Item properties for the dropdown is my collection ColProdTeam


StartDateTime Datacard update is: DataCardvalue3.SelectedDate


ProductTeamIDSK update is: TeamID


I don't have an Item properties set for the Form


My Update Rota button OnSelect is: SubmitForm(RotaForm)


Is there anything I am missing which is why it is not updating? 




Helpful resources

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,018)