Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Automatically choose a value from choice column when submitting form

(0) ShareShare
ReportReport
Posted on by 92
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?
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,388 on at
    Automatically choose a value from choice column when submitting form
    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?  
  • nerdyplayer Profile Picture
    nerdyplayer 92 on at
    Automatically choose a value from choice column when submitting form
    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.
  • MVP-Phipps Profile Picture
    MVP-Phipps 3,447 on at
    Automatically choose a value from choice column when submitting form
    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/

    If you would like our services checkout Synapx: https://www.synapx.co.uk/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard