Unanswered

Form doesn't save changes to Sharepoint list

(0) Share

Report

Posted on by Tobi_oy

Hi all,

I'm new to PowerApps and encountered a problem while customizing a Sharepoint list/form with Power Apps. I converted three dropdown fields into cascading dropdown fields in PowerApps, and they work perfectly fine within PowerApps. However, when I try to use them in the Sharepoint list, the modified dropdown fields do not display or save any information.

I attempted to resolve this issue by implementing a Submit Button with the SubmitForm function, but it didn't fix the problem either.

Here are the functions I used for the three dropdown fields:

Distinct('Dependent Approval'; Title)
Filter('Dependent Approval'; Title = dropdown_Company.Selected.Value)
ForAll(Filter('Dependent Approval'; Title = dropdown_Company.Selected.Value).Team; Team.DisplayName)

These functions refer to an external table ('Dependent Approval') where I store the information for the cascading function. I only changed the Items properties of each dropdown.

Thank you in advance for your assistance!

Best regards,

Bildschirmfoto 2023-07-14 um 14.54.45.png

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Tobi_oy

You may need to update the Update property of each of the datacards, to point to the relevant dropdown box that you've inserted.
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Tobi_oy,

What do you mean by "when you try to use dropdown in the SharePoint list, the modified dropdown fields do not display or save any information"? If no elements are showing in the dropdown, you should update the formula of your second dropdown using the provided formula. However, it seems that the formulas for dropdown one and three are fine.

Filter('Dependent Approval'; Title = dropdown_Company.Selected.Value).fieldName

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sanshubh 512 on at

Like
a
(0)

Report
Copy link

Link copied!

What is Type of those three column?
Tobi_oy 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cdwhite
I think the update property points to the right dropdown boxes.
Thanks!!
Tobi_oy 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Talha_Dar ,
the elements are shown and i can also click on them and can choose from the dropdown. But when I try to save the form to the Sharepoint list it just simply doesn't show the information which i inserted.

Thanks!
Tobi_oy 18 on at

Like
a
(0)

Report
Copy link

Link copied!

The first 2 are Text and the third is Person column type.

Thanks!!
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tobi_oy,

To ensure compatibility with text columns, try adding `dropdownName.Selected.Value` to your update property. This is because `dropdownName.Selected` does not directly return a text value. Give it a try and see if it resolves the issue.
Tobi_oy 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Talha_Dar
I apologize for the misunderstanding. I provided you with incorrect information earlier. The first two columns in the SharePoint list are also dropdown columns, and the third one is of type "Person." However, I attempted to change it to type "Text" now, but it only resulted in the error message "Record Value expected."

Thank you very much!