cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

PowerApps Submit Button

Hello Everyone, 

 

Need assistance please.  I created a form with 2 datasources: Calendar and Sharepoint List and the list is updated when the form is submitted, however I would like the form to also to update a field (FilledSeats) in the calendar when the form is submitted to keep track of attendees (max 4).  How do I go about in completing this task?

 

Thank you in advance for your assistance!    

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @Anonymous ,

Do you want to update FilledSeats field in calendar table with the data of attendees field that is one field of Sharepoint List1?

Does the form's data source set to Sharepoint List1?

Could you tell me the data type of FilledSeats field and attendees field?

I've made a similar test for your reference:

I assume that: use attendees field's data to update FilledSeats field; the form's data source set to Sharepoint List1; FilledSeats field and attendees field are both number.

 

1)inset a form conneted with list1.

2) Set the attendees field's Datacard's Update to a variable.

Set(testdata,attendees_DataCard1.Update)

3)submit the form and update FilledSeats field.

SubmitForm(Form1);Patch(calendar,Defaults(calendar),{FilledSeats:testdata})

621.png

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @Anonymous ,

Do you want to update FilledSeats field in calendar table with the data of attendees field that is one field of Sharepoint List1?

Does the form's data source set to Sharepoint List1?

Could you tell me the data type of FilledSeats field and attendees field?

I've made a similar test for your reference:

I assume that: use attendees field's data to update FilledSeats field; the form's data source set to Sharepoint List1; FilledSeats field and attendees field are both number.

 

1)inset a form conneted with list1.

2) Set the attendees field's Datacard's Update to a variable.

Set(testdata,attendees_DataCard1.Update)

3)submit the form and update FilledSeats field.

SubmitForm(Form1);Patch(calendar,Defaults(calendar),{FilledSeats:testdata})

621.png

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (81,076)