Answered

Getting Error on SubmitForm

Like (0) Share

Report

Posted on 16 Jan 2023 02:44:08 by jmikemyers

Hi, let me first say this is my first Powerapps app I have created. I mostly have it working. One of the remaining issues I am having is when I do a SubmitForm on a form that is in Editmode.New.

I get the following error when I submit the form:

The requested operation is invalid.

Server Response: PI Planning Notes and Items Tracker failed: The specified user 1:0#.f[membership]xxxxxxx@xxxxxxx.com could not be found.

I do not have error on other forms anywhere in the app. I also can update the same data, just get this error on saving data in the form set it new mode.

Categories:

Connecting to Data

All responses (3)

Answers (1)

jmikemyers 12 on 16 Jan 2023 at 16:03:08

Like (0)

Report

Re: Getting Error on SubmitForm

Thank You, that worked!
Verified answer

v-liwei-msft on 16 Jan 2023 at 06:41:38

Like (0)

Report
Re: Getting Error on SubmitForm

Hi @jmikemyers

Please try this formula in the DefaultSelectedItems of the field

{Claims:"i:0#.f|membership|"&User().Email,Email:User().Email,Department:"",DisplayName:User().FullName,JobTitle:"",Picture:""}

Best Regards,

Levi
jmikemyers 12 on 16 Jan 2023 at 04:20:38

Like (0)

Report
Re: Getting Error on SubmitForm

I figured out the problem, just not how to fix it. I was thinking it was an error about my account not existing but it is because one the fields is a user complex field. I am using the below code to fill in the current user but apparently I am doing something wrong because it says that user does not exist.

{'@odata.type':"#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser", Claims:Concatenate("1:0#.f[membership]",User().Email),DisplayName:User().FullName,Email:User().Email}

This is in the DefaultSelectedItems of the field where the user is entered.