Patch issue from a dropdown that is connected from another list

[kharina]

Hello Microsoft Power Apps Community, 

I am a newbie and sorry if this question is easy for you. I just cannot find the answer. 

I have 2 sharepoint list:

A, which is the source of my dropdown 

B, is where my database is stored, where I can generate the data from the canvass that I am creating.

If I use the manual formula ["A","B","C"] -- > this can patch the information to the Sharepoint list B .

But if the source of my drop down input came from sharepoint list A ( because I have a hundred of items in my dropdown) - I cannot patch the result to the main main Sharepoint list.

I'm hoping for your patience with my explanation. Thank you in advance.

[PowerAddict]

Hi,

Please let me know a bit more about your scenario.
1. What is your Patch formula?
2. How are you populating the dropdown using the list A?
3. How are you populating the dropdown using the manual formula ["A", "B", "C"]?

---
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://www.thepoweraddict.com

[kharina]

Hello Mr. Hardit, 

My patch formula is this: Patch(SP1, Defaults(SP1),{Title: Dropdown1.Selected.Value, SaP1: Dropdown2.Selected, D1: TextInput1.Text}). 

I attached 2 pics: 1 is the "manual-type" of record in my dropdown and the 2nd pic is from Sharepoint List A.

If I use the "manual-type", my  app can record  the items from my canvass in my Sharepoint list B

But If I use the other one, which is the screen shot( picture2), it doesnt go to my sharepoint list B.

[PowerAddict · Accepted solution]

Patch(SP1, Defaults(SP1),{Title: Dropdown1.Selected.Value, SaP1: Dropdown2.Selected, D1: TextInput1.Text}).

In the above expression, is Dropdown1 or Dropdown2 the dropdown for which you are changing the source to list A?

---
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://www.thepoweraddict.com

[kharina]

Hello Hardit, 

I would like to use this for Dropdown1.

Thank you.

[PowerAddict]

Ok so if you try to patch "A" (using the manual dropdown as an example), it gets added to SAP1->TeamMembers?

One last question: how do you set the Items property of the dropdown using SP ListA?

I think the problem is in the .Value when you set your dropdown to be populated from the list rather than manual.

Can you try Dropdown1.Selected.TeamMember or check what options you get when you type Dropdown1.Selected. ?

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://www.thepoweraddict.com

[v-yutliu-msft]

Hi @kharina ,

Do you mean that you can not update Title field successfully?

Could you tell me

1)the data type of Title field?

2)the items of drop down1  (from list1)?
Do you mean that your problems is only about updating Title field, SaP1 and D1 field have no problem?

Best regards,

[kharina]

Hi Hardit, 

Noted with thanks!

I will try this and will inform you.  🙂

[kharina]

Hi Phoebe, 

Thank you.

The data type is text.

And the items - are the same. So, When I type manually: ["Rich Davis","Daniel Uy","Bida"] (etc..etc..) -- this will be patched in my Sharepoint when I click the submit button.

But, If I reference the dropdown from the list that I showed in the attached file, I cannot even submit the button because of the error. 

I'm tying to learn, sorry.

[v-yutliu-msft · Accepted solution]

Hi @kharina ,

Could you tell me the items of the drop down when you can not update successfully?

If you set the drop down's Items: ["A","B","C"]

Using this formula is ok: Patch(SP1, Defaults(SP1),{Title: Dropdown1.Selected.Value,....})

But if you set the drop down's Items to SP1 ,Value to Title   (for example)

Then you need to use this formula:

Patch(SP1, Defaults(SP1),{Title: Dropdown1.Selected.Title,....})

So please show me the settings of the drop down and tell me what data that you want to update Title field in details.

Best regards,