cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trishmalloy
Level: Powered On

Re: Syntax for submitting 2 forms to SP list

@v-siky-msft  - Can you help with this?

v-siky-msft
Level 10

Re: Syntax for submitting 2 forms to SP list

Hi @trishmalloy ,

 

Apologize for the delay reply.

<BaseRecord> is the record that Form2 submitted , in other words, that is the record you want to add client name to.

I think you should use lookup function to findout that record, but since it was the last submitted record, you can use Last() to find out it.

You can try this:

SubmitForm(Form2);
Patch('client workout data',Last('client workout data'),{'client name':{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:Gallery2.Selected.ID, Value:Gallery2.Selected.'Client Name'}})

Hope this help.

 

Best regards,

Sik

 

View solution in original post

trishmalloy
Level: Powered On

Re: Syntax for submitting 2 forms to SP list

@v-siky-msftThank you so much for this solution!! 

trishmalloy
Level: Powered On

Re: Syntax for submitting 2 forms to SP list

Hello @v-siky-msft ,

 

With the formula you provided a record is created in the SharePoint list with the Client Name and related workout data. But, I am unable to view data from the app.  Do I need to include "Defaults" for a new record creation or "Update(s)" for editing a workout?

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (3,591)