Patch and SubmitForm to the same Sharepoint List

(0) Share

Report

Posted on by niklasjegg

505

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

I have the same question (0)

All responses (5)

Answers (1)

Adrian_Celis 1,652 Moderator on at

Like (0)

Report
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 );

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Adrian_Celis 1,652 Moderator on at

Like (0)

Report
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 );

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (1)

Report

Hi @Adrian_Celis thank you so much. couldnt sleep last night figuring out a solution 🙂

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (1)

Report

@niklasjegg Glad I could help 🙂

Was this reply helpful? Yes No