Saving selections to a new SP list

[CDBrown1]

Hi everyone 

I have seen the opportunities offered by Power Apps and finally have an opportunity to build one.

I have in mind the app I want to build but need to understand if I can populate a dropdown list with content from a SP List then save the selection to another SP List.

Is this possible? The search for 8nformation I did yesterday gave me some good results but did not work in practice, I got an error saying the code did not recognize the field I was trying to write the selection to.

Thanks in advance for any help, sorry if this seems like a simple question but you have to start somewhere.

Regards

Craig

[WarrenBelz]

Hi @CDBrown1 ,

A very broad question, but yes it is certainly possible - you need to link both lists to the app and use the Patch Function

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[CDBrown]

Hi WarrenBelz,

Thanks for the reply. I went through to the link to the Patch function. there must be something wrong with the coding I have created as I doesn't want to work. I have summarised the items I have created below and the code, hopefully the error will stand out for you.

I have two SP lists called Locations and Staff. The third list is the list I want to write to called Onsite Test. The first two lists have a single column of site names and staff names. The Onsite Test list has four columns Who (Text), Where (Text), Day (Short Date).

The app has two dropdowns, one for the Site Names and the other for the Staff Names. There is a label with the current date. I want the dropdown selections and the date written as a new record to the OnsiteTest list as a new record. Reviewing the Patch function, I wrote the following code on a button "OnSelect" function:

Patch( OnsiteTest, Defaults( OnsiteTest ), {Where: Dropdown1.SelectedItems} {Who: Dropdown2.SelectedItems} {Day: DatePicker2.Value})

Thanks again for the assist, I know once I get this going I should be able to get the rest of the functionality sorted easily.

[WarrenBelz]

Hi @CDBrown ,

The xxxx below is the valid output  of the dropdown (Value/Result/FieldName)

Patch(
   OnsiteTest, 
   Defaults(OnsiteTest), 
   {
      Where: Dropdown1.Selected.xxxx,
      Who: Dropdown2.Selected.xxxx,
      Day: DatePicker2.SelectedDate
   }
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[rampprakash]

Hi @CDBrown1,

Why can't you try Microsoft flows

When a record is created in Sharepoint List try creating record in another sharepoint List

[WarrenBelz]

@rampprakash ,

You should only really use Flows when you cannot do it directly in Power Apps.

[rampprakash]

Hello @WarrenBelz, 

Obviously, I just provided the suggession 🙂 A devloper a can easily write Code by surfing, but a non technical can easily understand Flow.

Anyway both was provided by Microsoft.

[CDBrown]

Hi WarrenBelz

Sorry it takes me a few days to reply, I have to switch between work and home computers.

The patch code looks great, and it looks like it will work however I am still getting an error and the button click does not write to the SP List. The error on the button code says that "Where" column in the SP List does not exist. When I look at the list, it is there. Have I used the wrong tool for the app to write to? Should it be an Excel spreadsheet on SP. I can see how the code should work I just haven't set something up correctly, sorry, a bit frustrating for  first go, hope you don't  mind the newbie issues.

[WarrenBelz]

Hi @CDBrown ,

I was using your code values and assumed the column name was valid. Go to your SP list, click on the Where column and you will see the actual name at the end of the URL at the top.

[CDBrown]

Hi WarrenBelz

Success!! I didn't have the value option in the argument, it works perfectly now, thank you for all your help.

How do I mark this as resolved?