cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
livingstonep
Kudo Commander
Kudo Commander

PowerApps creating SharePoint record using data connection and not user id

we are testing a new PowerApp that creates records on two SharePoint Lists, one a Master list and one a Detail list...

 

The PowerApp isusing a service login called BHF App Connector for the data connections - see this image:

PowerApp using BHF App Connector for data connection.PNG

the user creates several detail records, and when ready, clicks the button Submit request, which calls UpdateIf to set the status of the Master record to submitted.

 

We have noticed that when I am using the PowerApp (but not anyone else) the records are being created in the list with the data login BHF App Connector in the Created by and Modified by fields - see below image

BHF App Connector login in list.PNG

 

so what can be causing this - and how do we prevent it?

1 ACCEPTED SOLUTION

Accepted Solutions

@livingstonep 

Two other ideas:

 

#1  What happens if you play the app from another computer logged in as yourself?  (The credentials might be cached on your machine).

 

#2  What happens if you clear your browser cache and play the app logged in as yourself?

 

 

(Did the app ever work?  I mean did it ever show you as the creator?)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

6 REPLIES 6
mdevaney
Super User
Super User

@livingstonep
To my knowledge PowerApps will always write the record as whoever is logged in. You must be currently logged into the BHF App Connector account. Log out and login to your personal account then conduct a test.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

this is the strange thing - I am not logged in as BHF App Connector, I am logged in as myself.

I have even rebooted my pc but it's still happening...

I only used the BHF App Connector in the PowerApps studio to add the SharePoint connectors to the lists...and I have rebooted since closing the studio after publishing the PowerApp

@livingstonep 

Two other ideas:

 

#1  What happens if you play the app from another computer logged in as yourself?  (The credentials might be cached on your machine).

 

#2  What happens if you clear your browser cache and play the app logged in as yourself?

 

 

(Did the app ever work?  I mean did it ever show you as the creator?)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

hi,

I cleared all site data, cached data and cookies, restarted the browser, and the same thing happens.

I also tried using In-private/Incognito windows on both Chrome and Firefox with the same result.

 

any other ideas?

I would also like to know how to change this when it (somehow) is set. I've created a number of Power Apps and they all write to SP with the user logged in account but have one app that is using the Power App SharePoint connector account for some reason which throws so many things out the window with galleries only showing users "their stuff" based on the Created By SP column. How does one app end up having this set but no others?

@vwyaankee
This post is closed. Suggest you start a new one

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,100)