Patch and SubmitForm to the same Sharepoint List

(0) Share

Report

Posted on by niklasjegg

539

Hello.

I want to Patch my text Inputs to a Sharepoint List and after that i want to attach a file to the recently created list entry.

I have made a custom form with text inputs/dropdown/datepickers/choices for company needs.

I am useing Patch to write all the text inputs. And i have a Single Form for the Attachments that i want to submit too.

As far as i can get it to work the formula is creating 2 records 1 with the data and 1 empty with just the attachment.

How can i solve this or do i need to use a edit form control? My Formula..

Patch(
'Training Request',
{
Title: Title_Input.Text,
Costcenter: Costcenter_input.Text,
Organizer: Organizer_Input.Text,
From_Date: From_Date_Input.SelectedDate,
Till_Date: Till_Date_Input.SelectedDate,
Employee: Employee_Input.Text,
Location: Location_Input.Text,
Costs_Choice: Costs_Choice_Input.Selected,
Costs: Costs_text_Input.Text,
Purpose: Purpose_Input.Text

}

);

SubmitForm(Attachments_Form);

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @niklasjegg

You can patch a record along with attachment from a separate form by including YourFormName.Updates in your patch function.

Try this:
Patch( 'Training Request', { Title: Title_Input.Text, Costcenter: Costcenter_input.Text, Organizer: Organizer_Input.Text, From_Date: From_Date_Input.SelectedDate, Till_Date: Till_Date_Input.SelectedDate, Employee: Employee_Input.Text, Location: Location_Input.Text, Costs_Choice: Costs_Choice_Input.Selected, Costs: Costs_text_Input.Text, Purpose: Purpose_Input.Text } ,Attachments_Form.Updates );
niklasjegg 539 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Adrian_Celis i have edited my Formula but now i am only getting a Blank record in my SPList with just the attachment even though i entered every single field.
Verified answer

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @niklasjegg

I just noticed something missing with the patch formula. Are you creating a new item or just updating?
If you are creating a new item, then you should add Defaults (ListName) to your patch.

Patch( 'Training Request', Defaults('Training Request'), { Title: Title_Input.Text, Costcenter: Costcenter_input.Text, Organizer: Organizer_Input.Text, From_Date: From_Date_Input.SelectedDate, Till_Date: Till_Date_Input.SelectedDate, Employee: Employee_Input.Text, Location: Location_Input.Text, Costs_Choice: Costs_Choice_Input.Selected, Costs: Costs_text_Input.Text, Purpose: Purpose_Input.Text } ,Attachments_Form.Updates );
niklasjegg 539 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Adrian_Celis thank you so much. couldnt sleep last night figuring out a solution 🙂
Adrian_Celis 1,652 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@niklasjegg Glad I could help 🙂