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

Author field when using Patch

I have created several PowerApps linked to SharePoint lists, but for the first time I am using Patch. The app is embedded on a SharePoint page.  Inserting new rows into the list this way results in the Created By and Modified By fields to be set to the datasource connection user (a service account), instead of the person who is filling out the form.  

 

Is there a setting I am missing, or is that how Patch works? I could save user completing the form to a new Person field, but I'd rather have it go in the Author field.

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
rebeccas
Level 10

Re: Author field when using Patch

The Author field is from SharePoint...that will be there and not able to change in anything you tie to a SharePoint list. Same with the Created Date, and the last Modified date and name (Author is also referred to as Created By in some places like Flow). 

 

I have some that all show I "Created" them because I have a flow that runs and does them instead of it just in my App so I have a separate field that stores the name of the person who is submitting the form. If I don't need it to send them an email or anything like that I just use a separate Text column but if I want it to notify them or anything I make it a people field...that is my deciding factor most of the time.

5 REPLIES 5
rebeccas
Level 10

Re: Author field when using Patch

You cannot change the Author field so you can't refer to it in Patch. What I usually do is add a Text field or a People field (depending on my need) that stores the current user in that column separate of the Author column. 

copro
Level: Powered On

Re: Author field when using Patch

Thanks for the fast reply. Just so I understand what is happening, is that just a factor of using Patch, that the Author field is the datasource connection? Since SubmitForm uses the person completing the form, it was unexpected.

 

 

rebeccas
Level 10

Re: Author field when using Patch

The Author field is from SharePoint...that will be there and not able to change in anything you tie to a SharePoint list. Same with the Created Date, and the last Modified date and name (Author is also referred to as Created By in some places like Flow). 

 

I have some that all show I "Created" them because I have a flow that runs and does them instead of it just in my App so I have a separate field that stores the name of the person who is submitting the form. If I don't need it to send them an email or anything like that I just use a separate Text column but if I want it to notify them or anything I make it a people field...that is my deciding factor most of the time.

Community Support Team
Community Support Team

Re: Author field when using Patch

Hi @copro ,

Do you share your app and your SP Site to other users in your Org?

I have made a test on my side, and don't have the issue that you mentioned.

 

Actually, the Author field (Created By in SP list) value is based on the SP list connection you used within this shared app.

I assume that you have already shared your app and your SP Site to other users in your Org, when they firstly access this embedded app from their SP Site Page, this embedded app would ask them to provide their own connection to use this app:3.JPG

the end users should use their own account to create a connection to SP List connector within this embedded app. 

 

In addition, the Author (Created By) field value is generated by SharePoint server automatically. There is no way to change or assign to this field value from PowerApps currently.

As an alternative solution, you could add another Person type column in your SP list to store the people who fill in the form (just as you mentioned).

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
copro
Level: Powered On

Re: Author field when using Patch

Thank you for the replies. I guess my best option is to add my own field to track the form submitter. 

 

It just surprised me that Patch function stored a different value in Author than the "Submit" function. No big deal, now that I know. Thank you.