cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nerfino80
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.

Hello 

 

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})

 

Nerfino80_0-1642074481979.png

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? 

 

 

0 REPLIES 0

Helpful resources

Announcements
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)