Netwok Error with Patch Function

(0) Share

Report

Posted on by Cherryl

Hello,

I want to create rows in a Sharepoint List using the Patch function and this code :

Patch (Gestion;Defaults(GestionMembres);{Name: TextInput1_1;Surname: TextInput1_2}).

Gestion being the name of Sharepoint List
Name and Surrname being column names.

However, upon trying it, I land on a network error : My request is not valid.

I double checked the format of the columns of my list, they are all set to text.

Thanks in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sickle-Cell 600 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try replacing the semi colons with commas.

Patch (Gestion,Defaults(GestionMembres),{Name: TextInput1_1,Surname: TextInput1_2})

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Cherryl

Try this formula,

Put .Text after input controls name.

Patch(Gestion;
Defaults(GestionMembres);
{
Name: TextInput1_1.Text;
Surname: TextInput1_2.Text
}
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Cherryl 25 on at

Like (0)

Report
Copy link

Link copied!
Hi,

I replaced them by commas, and there is no more network issues, but :
The items on the code after 'Gestion' do not seem to be recognized
And the rows are not created
The monitor does not show error on its part though .🙂

Was this reply helpful? Yes No
Sickle-Cell 600 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

As Rajkumar mentioned, adding in the .Text after the text Inputs might solve this problem. In addition, you can try to put the collection name in single quotes.

Patch('Gestion',
Defaults(GestionMembres),
{
Name: TextInput1_1.Text,
Surname: TextInput1_2.Text
}
)

Was this reply helpful? Yes No
Cherryl 25 on at

Like (1)

Report
Copy link

Link copied!

Hi @Rajkumar_404 ,

Sorry, I didn't see your post TT
Yes, it does function now !

Thanks a lot 😁

Was this reply helpful? Yes No