Create a Dropdown in EditForm with source data from other Sharepoint list

[Anonymous]

Hi,

In PowerApps, I would like to have a Dropdown which has values for users to select. The values should be taken distinctly from a Sharepoint list named "Hierarchy", column "HierarchyGroup".

The selected value of the Dropdown should be updated to field "Group" of Sharepoint list named "Test".

How can I do those?

Thanks!

[PowerAddict]

Hi,

The dropdown's Items property can be set to:
Distinct(Hierarchy,HierarrchyGroup)

To set that value to the other list, use Patch
Patch(Test, Defaults(Test), {Group: Dropdown1.Selected})

You might have to tweak Dropdown1.Selected to something like Dropdown1.Selected.Value or Dropdown1.Selected.Result or Dropdown1.Selected.HierarchyGroup.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[Anonymous]

@PowerAddict : Thanks for your reply. Where should I put this formula: "Patch(Test, Defaults(Test), {Group: Dropdown1.Selected})"?

[PowerAddict]

If you want to add a button that the user needs to click to patch this, then on the OnSelect property of that button.

It all depends in how di you want this Patch to get triggered.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[Anonymous]

@PowerAddict : I use the default Submit button for the whole form where On select = SubmitForm(EditForm1).  How should I change the On select property to have the Patch function?

[PowerAddict · Accepted solution]

You can replace your OnSelect with the Patch function. I am not sure what you are using the SubmitForm for but if you need to keep that you can add the Patch after the SubmitForm with something like this:
SubmitForm(Form1); Patch(...)

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[PowerAddict]

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com