Unanswered

How to save values from cascading dropdowns back to parent list of the form?

(0) Share

Report

Posted on by TrayH

383

I have a small form with only 7 fields. The primary SharePoint list is called "Change Request." 5 of the fields presented in the form are coming from this Change Request list.

One of the requirements is to have 2 of the fields be cascading, meaning the values presented in the 2nd column are dependent on the choice from the 1st. The names of those columns are "System" and "Limit Type." Based on what a user selects in the System field, Limit Type will show different results. I followed this article to setup a new list called "Change Request_Cascading", created single line of text columns, and the cascading function is working as expected - Create Cascading (Dependent) Dropdowns In Power Apps (matthewdevaney.com)

The problem now is that after submitting a new form, the values from System and Limit Type are not visible in the Change Request list. I tried creating lookup columns on Change Request that point to those columns on Change Request_Cascading, but they are still showing up as blank.

I suspect what I need to do is set the On Select of my save button to both Submit the form and patch the Change Request list with the values from System and Limit Type, but I'm not sure how to construct that (I'm new to Power Apps). Currently the OnSelect property of my save button only has SubmitForm(Form1).

Another issue is that after submitting the form now, if I go to submit a 2nd one right after that, I get the dreaded "Getting your data" error. If I close the app and start over, it works. I suspect I need a reset somewhere to get around this.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TrayH ,

Does your screen contains an EditForm and two Dropdown controls?

Based on your description, I have made a simple test for your reference.

Here are my SharePoint lists:

Here is my app:

In my app, the form is linked to ‘Change Request’ list .

There are 7 fields in the ‘Change Request’ list in the beginning, including ‘System’ and ‘Limit Type’, so the form includes 7 DataCards.

I unlock and delete the ‘Text Input’ which is called ‘DataCardValue’ in ‘System’ and ‘Type’ DataCards.

Then I add two Dropdowns instead of them and set Update property of DataCards to DropdownName.Selected.Result.

The OnSelect property of save button can only has SubmitForm(Form1) by using this solution.

In conclusion, relace the Text Inputs with Dropdowns. There is no need to use patch.

Result Screenshots:

Best regards,
TrayH 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, Jeffer, I will try this out and report back. I think my mistake was I'm not using the System and Limit Type columns in the change request list at all. I created custom data cards, then added the dropdowns to those, pointing to the Cascading list.
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TrayH ,

There is no Update property in custom cards. As the result, using SubmitForm function will fail to save info in custom cards to your data source. You will need a Patch function instead in this case. Certainly, use system data cards will be an easier approach.

Best regards,