cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAppMichael
Frequent Visitor

New Form Insert Error -- Secondary Data Source Issue

I am having an issue with secondary SharePoint lists as data sources. I want to populate a dropdown based on metadata (e.g. an "active" option flag making an old option unavailable for instance.)

 

Green Form in Screenshot below [Working]: When I create a form and do not change the "Channel" dropdown/DataCard control to the secondary data source [Channels] the SubmitForm command works. There are many fields but the fields in the example screenshot are the only two required fields as I intend set conditional requirements within the form itself.

 

Red Form in Screenshot below [Error]: When I create the form and unlock the Channels datacard and insert a dropdown to replace the default dropdown (which is a "Lookup" control from what the UI appears to say), and I change the Update property on the Channel datacard to "Channeldropdown.Selected" it doesn't appear to work. I don't know if it's tryin to insert the text versus the ID?

 

It's important for me to conditionally filter on metadata for the secondary data source, otherwise I'd just leave it all tied to the original List and call it done.

 

Example of the Channels Table

ID | Title | Active

1 | CRI | Yes

2 | Pet | False

 

The actual error displayed by PowerApps as a whole is "The requested operation is invalid.Server Response: A value must be provided for item." It doesn't specifically show this as an error on that datacard, which I find odd, but I know it's a problem with that field because of my two test forms and that being the only change.

 

If anyone could help that'd be great. My team and I are having a hard time figuring this one out. Thanks!

 

Test Forms.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @PowerAppMichael,

 

Changing data source property of the Form control is not supported, as the ciorresponding field would need to re-assign once the data source changed.

 

If you would like to submit data based on the dropdown selection, you may switch to Patch function instead of the Form control:

Patch function in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
PowerAppMichael
Frequent Visitor

I did look into using the LookUp function for my data source instead of using the Filter function, or linking to my source directly, but it seems LookUp isn't the proper way to go about this. Still looking for a solution. If anyone has any ideas, they'd be greatly appreciated.

 

Thanks!

Hi @PowerAppMichael,

 

Changing data source property of the Form control is not supported, as the ciorresponding field would need to re-assign once the data source changed.

 

If you would like to submit data based on the dropdown selection, you may switch to Patch function instead of the Form control:

Patch function in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,331)