Update a single line text field in SharePoint based on a button select event

(0) Share

Report

Posted on by cooltechie

116

Hi,

I have a form with "Submit" button. I would like to set the value of a text field with name "Start workflow" to "Yes" when user clicks on the "submit" Button and also save any unsaved changes.

Once it is submitted, the "Submit" button should be disabled.

I tried using Patch , set Var nothing really worked. Can someone help with correct syntax and functions to use?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cooltechie

On button select

Patch(DataSource, Lookup(DataSource ID = itemid,{ColumnInternalName:"Yes"})

ID = itemid - This should be the query that identifies the data row to update
ColumnInternalName - internal name of column to update
"Yes" - text column value

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cooltechie ,

Do you want the button becomes disabled after you submit the form?

If so, try this :

1)Set the button's OnSelect:

Patch(tablename,LookUp(tablename,....),{fieldname:"test"});Set(var,1)

1)Set the button's DisplayMode:

If(IsBlank(var),DisplayMode.Edit,Disabled)

Then after you clicking the submit button, your variable var will not be blank value, the button's DisplayMode will change to Disabled.

Best regards,

Was this reply helpful? Yes No
cooltechie 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Reza,

I am trying your code, however, I do not see option to select the dynamic variable itemid

Patch('My Requests', LookUp('My Requests', ID=??? ),{'Start WF?':"Yes"});

When you say ID = itemid are you expecting me to hard code a particular ID? or should itemid be defined elsewhere?

Was this reply helpful? Yes No
Verified answer

cooltechie 116 on at

Like
a
(0)

Report
Copy link

Link copied!

What worked for me is the following code for On Select of the button:

Patch('My Requests', {ID: Value(ID_DataCard1.Default)},{'Start WF?':"Yes"}); SubmitForm(SharePointForm1);

Was this reply helpful? Yes No