Answered

Patch a new record to a list from a form

(0) Share

Report

Posted on by Techgallagher

Hi, so I have this form where people can go and create a new project, it works just as you'd expect. It lets users fill out the fields and then on submission it will reflect their inputs on a backend SharePoint list called Project Requests. However, there is another list called Project Tracker where I want to be able to track the status of projects and I'd like it so that when a user submits the project request form, I can patch a new record into the project tracker list as well. The record on the project tracker does not need all the fields to be filled in, mainly just the project ID field so that if a user were to look at that value they could go to the ID of the project request list and find the project that is being tracked.

Here is the request screen and the ID data card is there, it is just hidden b/c the user doesn't need to see that.

This is the formula for the submit button. I've tried a bunch of things, but I either get errors like title is required or I can't get the right data type, etc.

Here is the Project tracker list: Project name is the title field, project id is a number data type, progress is a choice field, priority is also a choice field, assigned to is a number field because I'm also connecting that to employee ids and notes is multi lines of text

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Techgallagher

First, consider moving anything except SubmitForm out of your Submit button OnSelect and move whatyou are trying to do into the OnSuccess action of the Edit form. This way your formula will only apply once the form submit is successful. With your formula currently, if there is an error in the submit, your patch would still happen...probably not what you want!

Then in the OnSuccess action - this formula:

Patch('Project Tracker', Defaults('Project Tracker'), { Title: Project_Req_Form.LastSubmit.'Project Name', ProjectID: Project_Req_Form.LastSubmit.ProjectID, ...and so forth for the remaining columns you want... } ); Navigate('Success Screen', Fade)

That should give you what you want.

I hope this is helpful for you.
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Techgallagher ,

Select the Form and Set OnSuccess Property.
Patch(SpList, Defaults(SpList), {Column1: Value, Column2: Value})

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay