Submit form to a separate sharepoint list

[Anonymous]

Hi 

I am new to power apps and working on a sharepoint as the backbone of the app. Is it possible when a form is edited from a certain list (lets say "Fresh") in sharepoint and then you hit a button to submit, the edited record will go to a separate list in sharepoint ("Expired")?

Thanks!

[Anonymous]

Hi #Chrom3d,

If you need to work with existing data, and you're new to PowerApps, I would suggest taking the time to create a new list or library (source and target) to work out the core logic, collection management and Flows to ensure you're not manipulating production data. 

Just for clarification, it sounds like you are trying to bring SharePoint list data into PowerApps, manipulate the information and push the manipulated data back to another SharePoint list called Expired? Would the Fresh list data be changed too or stay as orig? Is that correct? 

Please advise.

J

[v-micsh-msft]

Hi @Anonymous,

Yes, we could take use of a button to submit changes or new records into a seperate SharePoint list, on the condition that this SharePoint list is also connected within PowerApps.

You may take the following guided learning as a reference:

Explore the generated app (SharePoint List)

Under the EditScreen, for the save Icon, we could take use of Patch function to add additional updates to a seperate SharePoint List, using semicolon to seperate the Patch formual with the submitform, example:

Submitform();Patch()

Function reference:

Patch function in PowerApps

If you have any further question on this, please post back.

Regards,

Michael

[Anonymous]

hi J

To be honest I am working on a sign in and sign out app from a sharepoint list, it's a test and non production but it came into my mind that saving the record on a different list would be helpful as well as if I get to learn Powerapps and get the sign in for visitors working. I might get to apply my knowledge on a new app that I will be working on which is a bee keeping app.

Glad that offline mode is now somewhat supported hence was thinking of pushing the new record on a new list once the form is edited so it can be cross-referenced to the old record on the bee keeping app. The old record would be kept original I think but will have to look into the flow if it is really whats needed. Thanks 

[Anonymous]

Hi Michael 

This is great, I am just learning and trying out things in Powerapps. It is marketed as no coding needed but there is still a bit needed if you want to be flexible. Coming from a no coding background I find it a bit to wrap my head around and I am just in the process of exploring the Patch command too. Your advise makes sense and thanks for the link! 

I copied a tutorial and it's codes/syntaxes and whenever i hit submit with a patch command on a button it doesn't register my changes altough there is no exclamation mark that says something is broken. What are the possible things that could cause this? 

[v-micsh-msft]

Hi @Anonymous,

What is your current situation?

Could you please share more information about the formula you used here?

We could take use of the errors function to check the error message:

Errors function in PowerApps

Regards,

Michael

[Anonymous]

Hi Michael 

I'm kinda stuck, sorry my explanation is a bit unclear but here we go to make it clearer. For starters I am making a visitor app and I got 3 major hurdle to go through before I can go towards the function of sending an email to the one being visited. 

1.) How to I submit a form to two Lists in sharepoint?

code to the submit button is: 

SubmitForm(Form2);Navigate(Screen1,ScreenTransition.Fade)

which  submits to the list called SignIn - but I want it to submit to SignedOut as well

2.) Second is when I hit the Check Out button, I want it to patch the SignOut list and delete the selected ID in the SignIn list so it will refresh the Gallery and not show the person who signed out already, 

Code to the checkout button is: 

UpdateContext ( { isLoading : true } );UpdateContext({EditREcord:Patch(SignIn,LookUp(SignIn,ID=Gallery1.Selected.ID), {SignOutDateTime : Now()+7/24})}); UpdateContext ({isLoading : false }); Navigate(Screen1,None)

Which only updates the Time and Date of the selected ID. But the the person who signed out still shows in the gallery. (reason I want to have another record on a separate list called SignedOut is for record)

3,) Third issue I have is is there a way to customise a card in a Gallery linked to a List in sharepoint to call up Office365 users?

I would like to make it so it autofills with the name of the people/person in the company so that I can pull out his email address and have an email sent to the person if someone is visiting him.

I am quite new and got zero xp in this kind of this but I am quite keen on learning this

Regards

Andy

[v-micsh-msft]

Thanks for the update.

To your first question, submit records to two lists.

For the list which has been configured as the Data Source of the Editform, we use Submitform function to add records.

For the second list, we could take use of the patch function, for example, to add new records:

Patch(List2, Defaults(List2), {FieldsName:FieldValue[,FieldName:FieldValue.....]})

Thing should be noticecd is, form has two mode, Editing mode and New mode.

To add new record, we could use the formula above, but for editing record, we should use the patch function in another way, here we could identify the corresponding record in List2, then use the corresponding Value to 'Update it':

Patch(List2, first(filter(List2, condition)), {} )

Question2, to remove the list from Gallery.

Things you should know is that the Data displayed under Gallery is queried directly from datasource(here should be the sign-in list), if you would like the ID be removed from Gallery, we need to delete the corresponding item under Sign-in list.

Function which could be used to delete the item is Remove.

Question 3, to custom the DataCard, we need first un-lock the corresponding Data Card, for more details, please check:

Understand data forms in Microsoft PowerApps

Edit form and Display form controls in PowerApps

Regards,

Michael

[Anonymous]

Hi Michael

Thanks for following up! You have to put in though that I am a noob on this and has zero knowledge on scripting and such. I tried using Flow to submit to the other list but it's not working well. I constructed it as if an existing item was edited - copy it to a new list, but even newly created ones are being copied. Moving forward with your reply. 

1)

For the list which has been configured as the Data Source of the Editform, we use Submitform function to add records.

For the second list, we could take use of the patch function, for example, to add new records:

Patch(List2, Defaults(List2), {FieldsName:FieldValue[,FieldName:FieldValue.....]}

how will I write the command down like your example- Patch(List2, Defaults(List2), {FieldsName:FieldValue[,FieldName:FieldValue.....]} in a way that it will input the same data when a Submitform is triggered for List 1? List1 and List2 on my test has the same Field Names.

2) 

 to remove the list from Gallery.

Things you should know is that the Data displayed under Gallery is queried directly from datasource(here should be the sign-in list), if you would like the ID be removed from Gallery, we need to delete the corresponding item under Sign-in list.

Function which could be used to delete the item is Remove.

I think if I solve the 1st problem I can fix this with just the Remove function, my only problem is the I won't be able to patch the sign out date and time if the record is removed hence I would like to patch List2 instead of List1.

3)

I will have a go on these, I just want to pull the O365 users for just one card - which the whole Form is connected to List1

Kind regards

Andy