Answered

Patch variables to sharepoint

(0) Share

Report

Posted on by lmahmuti

I am struggling to get a patch to sharepoint to work. See code below

Patch(Mentors_2,Default(Mentors_2),{ScoreNew:ScoreNew.value,ScoreSpec:ScoreSpec.value,ScoreEx:ScoreEx.value, ScoreT:ScoreT.value, ScoreO:ScoreO.value, ScoreP:ScoreP.value, ScoreS:ScoreS.value});Navigate(Home)

Where I have title of the sharepoint table matching the name of the variable but it is giving me an error.

Invocation of unknown or unsupported function

Can you help with this?

Categories:

Building Power Apps

All responses (18)

Answers (2)

Sort by

WarrenBelz 156,586 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lmahmuti ,
You might try a Capital V for Value, but where are you patching the Variable?
If it is a variable, you do not need .Value
Patch( Mentors_2, Default(Mentors_2), { ScoreNew:ScoreNew.Value, ScoreSpec:ScoreSpec.Value, ScoreEx:ScoreEx.Value, ScoreT:ScoreT.Value, ScoreO:ScoreO.Value, ScoreP:ScoreP.Value, ScoreS:ScoreS.Value } ); Navigate(Home)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Imahmuti
Please show a screenshot of the code in your formula bar that is underlined.
lmahmuti 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,

I am patching them to sharepoint Mentors_2. Tried removing the value suffix but still the same error
lmahmuti 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Attached screenshot
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

...
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Imahmuti
Change this code

Default(Mentors_2)

Into this code

Defaults(Mentors_2)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
WarrenBelz 156,586 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @lmahmuti ,
Sorry, focusing on one issue around Variables and posted your code in and missed the obvious first one - @mdevaney picked it up.
Patch( Mentors_2, Defaults(Mentors_2), { ScoreNew:ScoreNew.Value, ScoreSpec:ScoreSpec.Value, ScoreEx:ScoreEx.Value, ScoreT:ScoreT.Value, ScoreO:ScoreO.Value, ScoreP:ScoreP.Value, ScoreS:ScoreS.Value } ); Navigate(Home)
lmahmuti 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Now I am getting Patch has some invalid arguments
SubmitForm(Form6);If(DataCardValue23.Selected.Value = "Mentor a new hire", Set(ScoreNew, ScoreNew+1));If(DataCardValue23.Selected.Value = "Mentor a specific employee", Set(ScoreSpec, ScoreSpec+1));If(DataCardValue23.Selected.Value = "Mentor an experienced employee seeking direction", Set(ScoreEx, ScoreEx+1));If(DataCardValue48.Selected.Value = "Provide technical guidance", Set(ScoreT, ScoreT+1));If(DataCardValue48.Selected.Value = "Provide operational guidance", Set(ScoreO, ScoreO+1));If(DataCardValue48.Selected.Value = "Provide progression guidance", Set(ScoreP, ScoreP+1));If(DataCardValue48.Selected.Value = "Provide soft skill guidance", Set(ScoreS, ScoreS+1));

Patch(Mentors_2,Defaults(Mentors_2),{ScoreNew:ScoreNew,ScoreSpec:ScoreSpec,ScoreEx:ScoreEx, ScoreT:ScoreT, ScoreO:ScoreO, ScoreP:ScoreP, ScoreS:ScoreS});NewForm(Form6); Navigate(Home)
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

There’s no way for us to solve this issue for you directly. You have to remove all the arguments from PATCH then add them back one by one. You’ll know which field is causing the error by doing this.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
lmahmuti 95 on at

Like
a
(0)

Report
Copy link

Link copied!

I am getting super close to resolution. My last error is Title:Field 'Title' is required. IconAccept1.OnSelect.

I have the mandatory Title column in sharepoint so not sure how to resolve this