web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

SaveasDraft Button

(1) ShareShare
ReportReport
Posted on by 2,249
Below are the basic screens but issue im facing in step 1.1 where save as draft button is not saving the values
 
Onselect  //saveasdraft button
Set(varItemsetupApprovalStatus,"Approved");
If(varStep=1.1,SubmitForm(Form2);If(varItemSetupID>0,Navigate(scrSuccess), Navigate('Item Dashboard')),
SubmitForm(ApprovalForm1);If(varItemSetupID>0,Navigate(scrSuccess), Navigate('Item Dashboard')));
Refresh('Item Setup Data')
 
Onvisible //saveasdraft button
 
Visible
 
If(varFormMode <> FormMode.New,
(varStep=1.1 && First(colItemSetupSelectedRecord).ApprovalStatus="Submitted" && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="Sourcing").AssignedOwners,Email) && !LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'IsSsCompleted?') Or
 If((varStep=1.2 && First(colItemSetupSelectedRecord).ApprovalStatus="Rejected") Or
 
(varStep=1.2 && First(colItemSetupSelectedRecord).ApprovalStatus="Submitted" && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="Sourcing").AssignedOwners,Email) && !LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'HavePMapproved?') Or
     (varStep=2 &&
    First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department=" Engineering").AssignedOwners,Email) && (!LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'IsEnggCompleted?' Or First(colItemSetupSelectedRecord).RequestStatus="Draft")) Or
      (varStep=3 && First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="BS").AssignedOwners,Email) && (!LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'IsProCompleted?' Or First(colItemSetupSelectedRecord).RequestStatus="Draft")) Or
(varStep=4 && First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="Product Mgmt").AssignedOwners,Email) && (!LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'IsPMCompleted?' Or First(colItemSetupSelectedRecord).RequestStatus="Draft")) Or
     (varStep=5 && First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="Customer ").AssignedOwners,Email) && (!LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'Is Customer Completed' Or First(colItemSetupSelectedRecord).RequestStatus="Draft")) Or
     (varStep=6 && First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="PD").AssignedOwners,Email) && (!LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'Is it add to 365?' Or First(colItemSetupSelectedRecord).RequestStatus="Draft")) Or
     (varStep=7 && First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="Fin").AssignedOwners,Email) && (!LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'IsFinCompleted?' Or First(colItemSetupSelectedRecord).RequestStatus="Draft")) Or
     (varStep=8 && First(colItemSetupSelectedRecord).ID > 0 && User().Email in Distinct(LookUp(NewItemSetupOwners,Department="Inv ").AssignedOwners,Email) && !LookUp(
        'Item Setup Data',
        ID = First(colItemSetupSelectedRecord).ID
    ).'IsInvCompleted?'),
    true,false
))
 
 
 
 
 
Categories:
I have the same question (0)
  • NickWarner Profile Picture
    113 on at
    Do you have any required fields on Form2 and if so, do any of them have conditional visibility?  I had an issue recently where SubmitForm(Form) would not work if there was a hidden blank required field on the form. So the issue might be here: 
     
    Onselect  //saveasdraft button
    Set(varItemsetupApprovalStatus,"Approved");
    If(varStep=1.1,SubmitForm(Form2);If(varItemSetupID>0,Navigate(scrSuccess), Navigate('Item Dashboard')),
    SubmitForm(ApprovalForm1);If(varItemSetupID>0,Navigate(scrSuccess), Navigate('Item Dashboard')));
    Refresh('Item Setup Data')
  • Veblitz Profile Picture
    2,249 on at
    Yes i have conditional visibility in form2 but is there any workaround for the same? please suggest and how you managed to overcome this issue 

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard