0

I have the following in my browsescreen1.

enter image description here

enter image description here

This is already populated "NOT Started" in my SharePoint list, it is the default value i have inputted manually for every record.

Now on my EditForm I have a save button:

OnSelect: UpdateContext({VarProgress:"In Progress"});SubmitForm(EditForm1_1);

How can I update my NOT Started to In Progress when clicking save?

3
  • Is "Attestation Status" column editable field in Power apps form? Try setting Default property of control to VarProgress. Let me know if this works. Commented Jan 12, 2023 at 16:00
  • Attestation status is just text i inputted, its not a field. "Status" is an actual field in my sharepoint, but i do not have the card in my app Commented Jan 12, 2023 at 17:01
  • Try suggestions given in my answer below Commented Jan 12, 2023 at 17:15

1 Answer 1

1

Try using formula like below in OnSuccess property of EditForm1_1 control:

Patch( SPListDataSourceName, EditForm1_1.LastSubmit.ID, { Status: VarProgress } ) 

Or use formula like below in OnSelect property of Save button control:

Patch( SPListDataSourceName, ThisItem, EditForm1_1.Updates, {Status: "In Progress"} ) 
4
  • getting an error here : Patch( [testme], ThisItem.Status, EditForm1_1.Updates, {ThisItem.Status: "In Progress"} ) How cna i fix this? Commented Jan 12, 2023 at 17:44
  • 2nd parameter to patch function is the context of item you want to update in SharePoint list. Use ThisItem instead of ThisItem.Status. Refer formula given in my answer. You just need to change the name of list in that formula. Commented Jan 12, 2023 at 18:33
  • Im getting This Name isnt recognized and specifcied column Status does not exist. Commented Jan 12, 2023 at 18:42
  • Can you try using first solution in my answer? Note: You have to use the correct name of your Status column. Commented Jan 13, 2023 at 4:30

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.