Automatically choose a value from choice column when submitting form

(0) Share

Report

Posted on by nerdyplayer

148

I have a choice column in a SP list so far it's original, rejected, edited, Completed.

that when a new submission is sent, it defaults to original and working correctly.

I am making an app where if the requestor makes any changes, it will automatically update the choice column to "edit".

Tried to see if I could update that in the app, but the few tries isn't working.

Do I have to make another flow and do a run command when the user submits it?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I am understanding correctly. When a user makes an update via the Power App you would like the choice column to update to 'edited'?

Are you using custom fields or a form? If Form you can update onsuccess if custom fileds you can use a patch statement. Please provide more details.

If this helps, please like. If this solves the problem, mark as a solution.

Follow me on LinkedIn: https://www.linkedin.com/in/charlie-phipps-bennett-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/

Was this reply helpful? Yes No
nerdyplayer 148 on at

Like (0)

Report
Copy link

Link copied!

I am using a SP list, and using an Edit form for the user input the data.

I have 2 canvases,

Submission -for initial submission. the choice Column value defaults to Original. Working as intended.

edit page- if user is on this page, when they submit the editform, I want the choice column to automatically switch to Edit.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!
I believe that you can set the default to something like

If( EditForm1.Mode = FormMode.Edit, { Value: "edit" }, Parent.Default)

where EditForm1 is the name of the form but you still need to consider if the form edit condition is the only condition that determines the change in the choice column. How are you setting the 'original' value? Do you set it as the default?

Was this reply helpful? Yes No