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 Platform Community / Forums / Power Apps / Save formula on screen...
Power Apps
Unanswered

Save formula on screens with multiple forms, one being read only

(0) ShareShare
ReportReport
Posted on by 415

Hello,

 

I tried to be detailed in how my app is configured.  Please let me know if there's anymore information you need!

 

SCREEN 1

 

Text input used for Search

 

SCREEN 2

 

Gallery2 (Select Client based on text input from screen 1)

 

Filter('Client Profile',StartsWith('Client Name', 'Search for Client'.Text))

 

SCREEN 3

 

1 form and 1 gallery.  Selected client’s profile named FormViewer1 and …

 

Gallery3 list of selected client’s workouts

 

Filter('Client Workout', Client_x0020_Name.Value = Gallery2.Selected.'Client Name')

 

From this screen a new workout can be created.

 

NewForm('New workout');Navigate('New Workout', ScreenTransition.None)

 

1.PNG

 

The New Workout screen has 2 forms on it.  The bottom form is named New workout, the top form is named New workout – Name and is a read only field brought in from selecting a client from Gallery2.

 

I am not sure what the Save formula should be when a new record is created.

 

2.png

 

 

Back to SCREEN 3 where a client’s workout can be viewed and edited by selecting the right arrow

3.PNG

 

 

The bottom form name is View workout and the top form is named View workout - Name

 

4.png

 

When the Edit icon is clicked it goes to Edit Client Workout screen where there are 2 forms.  The bottom form name is Edit workout and the top form name is Edit workout – Name.

 

I am not sure what the Save formula should be for editing a workout.

Categories:
I have the same question (0)
  • rebeccas Profile Picture
    2,591 on at

    If it is a form then the save button can just be SubmitForm() ...are you saving changes to data in a Form or in a line of a Gallery?

     

    Also, be careful referring to a Gallery on a different screen...that can be inconsistent. Normally if I want to select an item from a Gallery and then have my form or another gallery on the next screen I instead set a global variable that I refer to. An example of that would be:

     

    Gallery - Icon - OnSelect= Set(varTitle, ThisItem.Title)

    Form - Items = LookUp(SpList, Title=varTitle)

  • v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @trishmalloy ,

     

    Are there 2 sharepoint lists involved in your app? 

     

    To create a new item with edit form, when form is in NewForm mode, SubmitForm function will create a new item. Make sure the data source property of the form is the target list.

     

    To edit an existing item with edit form control, when form is in EditForm mode, and you set the Item property of the form control to the record you want to edit, like Gallery1.Selected, then SubmitForm function will edit this item.

     

    Regards,

    Mona

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 396 Most Valuable Professional

#2
11manish Profile Picture

11manish 134 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 101 Super User 2026 Season 2

Last 30 days Overall leaderboard