Power Platform Community Forum Thread Details

Hi!

I am new to using PowerApps and have a question. I want to update 2 different list on my SharePoint at the same time with one form based on the following conditions:

If the form is edit mode and the DropDown is equal to Admin support, update Last Name, First Name and Email on my 'Assistant List' and on the main datasource liked to my EmployeeForm, otherwise update just the EmployeeForm. The error that I got was related to EmployeeGallery.Selected and it says: The specified column 'field_10' does not exists. What does it mean?

If(

FormModeValidation.Text = "Edit Form" && DrpParticipation.SelectedText.Value = "Admin support",

Patch(

'Assistant List',

EmployeeGallery.Selected,

{

'Last Name': LastNameEmployee.Text,

'First Name': FirstNameEmployee.Text,

Email: EmailEmployee.Text

}

SubmitForm(EmployeeForm);

Navigate(

HomeScreen,

ScreenTransition.Cover

SubmitForm(EmployeeForm);

Navigate(

HomeScreen,

ScreenTransition.Cover

)

Thank you!

Categories:

Building Power Apps

Hi @maryalexa91 ,

You have created your list by importing from Excel, which gives all fields the underlying "original" name of field_x.

If you go to your List Settings and select each field, you will see the actual field name at the end of the top URL.

If you have not gone too far with this list, I suggest you re-create it with the field names you need (do not change them after this) and copy in the data - you can do this in Edit in grid view.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps