Home

Saving PowerApps app results to SharePoint list using service account instead of app user

%3CLINGO-SUB%20id%3D%22lingo-sub-574225%22%20slang%3D%22en-US%22%3ESaving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-574225%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20an%20app%20for%20end%20users%20to%20take%20a%20test%20and%20then%20submit%20the%20results%20to%20a%20SharePoint%20list.%20I%20am%20no%20fan%20of%20giving%20everyone%20contribute%20access%20to%20the%20list%2C%20as%20they%20potentially%20will%20be%20able%20to%20edit%20their%20test%20results%20in%20the%20list%2C%20so%20I%20am%20looking%20to%20run%20the%20save%20(patch())%20function%20using%20a%20service%20account.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20I%20know%20is%20possible%20to%20to%20with%20Flow%20actions%2C%20but%20I%20have%20not%20seen%20if%20or%20where%20I%20can%20define%20the%20same%20in%20PowerApp%20connections.%20Have%20anyone%20managed%20to%20do%20this%2C%20and%20if%20so%20-%20how%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-574225%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EImpersonation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-574995%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-574995%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20probably%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fdeveloper%2Fcommon-data-service%2Fimpersonate-another-user%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fdeveloper%2Fcommon-data-service%2Fimpersonate-another-user%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-575201%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575201%22%20slang%3D%22en-US%22%3EFar%20as%20I%20know%20it's%20not%20possible.%20You%20could%20use%20flow%20instead%20of%20Patch%20to%20pass%20in%20all%20your%20values%20then%20use%20impersonation%20there%20to%20put%20it%20into%20SharePoint.%20Or%20use%20an%20Azure%20SQL%20Database%20and%20connection%2C%20which%20is%20what%20I%20pref%20using%20since%20you%20have%20less%20delegation%20issues.%20Then%20you%20use%20a%20shared%20login%2C%20but%20you%20can%20control%20security%20through%20the%20app%20and%20they%20dont'%20have%20a%20way%20to%20get%20to%20the%20raw%20data.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%2C%20you%20might%20want%20to%20try%20the%20official%20Powerapps%20forum%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ELot%20more%20people%20watch%20that%20forum%20smarter%20than%20myself%20in%20PowerApps%2C%20so%20might%20give%20that%20a%20whirl.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633612%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633612%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F120902%22%20target%3D%22_blank%22%3E%40Henning%20Strand%3C%2FA%3E%26nbsp%3B%2C%20have%20you%20thought%20of%20doing%20the%20test%20with%20Microsoft%20Forms%20then%20saving%20the%20results%20to%20a%20SharePoint%20list%20via%20Flow%3F%20It%20works%20well%20and%20means%20those%20taking%20the%20test%20don't%20need%20to%20have%20access%20to%20the%20SharePoint%20list.%3CBR%20%2F%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636556%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%2C%20yes%20I%20did%20try%20that%20approach%20first%2C%20but%20as%20the%20info%20sent%20into%20the%20Flow%20is%20very%20limited%20I%20discarded%20the%20idea%20pretty%20quickly.%20For%20example%3A%20There's%20no%20way%20to%20see%20in%20the%20Flow%20if%20the%20answer%20the%20user%20chose%20was%20correct%20or%20not.%20So%20then%20I%20have%20to%20build%20that%20check%20into%20the%20Flow%20myself%2C%20hard%20coding%20comparison%20values%20or%20checking%20against%20a%20SharePoint%20list%2C%20or..%20And%20as%20I%20also%20need%20the%20test%20to%20run%20in%20different%20languages%2C%20I%20would%20even%20have%20to%20create%20multiple%20Forms%20and%20Flows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636969%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636969%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F120902%22%20target%3D%22_blank%22%3E%40Henning%20Strand%3C%2FA%3E%26nbsp%3B%20you%20can%20identify%20the%20correct%20answers%20in%20the%20Forms%20Quiz%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fadjust-your-form-or-quiz-settings-in-microsoft-forms-f255a4ba-e03c-4e12-b880-f7e8b62e0665%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fadjust-your-form-or-quiz-settings-in-microsoft-forms-f255a4ba-e03c-4e12-b880-f7e8b62e0665%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-637016%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20PowerApps%20app%20results%20to%20SharePoint%20list%20using%20service%20account%20instead%20of%20app%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-637016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1096%22%20target%3D%22_blank%22%3E%40Dean%20Gross%3C%2FA%3E%2C%20yes%20I%20know%2C%20but%20I%20have%20not%20seen%20this%20reflected%20in%20the%20Flow%20action.%20I%20need%20to%20know%20in%20the%20Flow%20if%20the%20answer%20sent%20in%20is%20correct%20or%20not.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I am creating an app for end users to take a test and then submit the results to a SharePoint list. I am no fan of giving everyone contribute access to the list, as they potentially will be able to edit their test results in the list, so I am looking to run the save (patch()) function using a service account.

 

This I know is possible to to with Flow actions, but I have not seen if or where I can define the same in PowerApp connections. Have anyone managed to do this, and if so - how?

 

Thx

6 Replies
Highlighted
Far as I know it's not possible. You could use flow instead of Patch to pass in all your values then use impersonation there to put it into SharePoint. Or use an Azure SQL Database and connection, which is what I pref using since you have less delegation issues. Then you use a shared login, but you can control security through the app and they dont' have a way to get to the raw data.

Also, you might want to try the official Powerapps forum here: https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1

Lot more people watch that forum smarter than myself in PowerApps, so might give that a whirl.
Highlighted

Hi @Henning Strand , have you thought of doing the test with Microsoft Forms then saving the results to a SharePoint list via Flow? It works well and means those taking the test don't need to have access to the SharePoint list.
Rob
Los Gallardos

Highlighted

@Rob Elliott, yes I did try that approach first, but as the info sent into the Flow is very limited I discarded the idea pretty quickly. For example: There's no way to see in the Flow if the answer the user chose was correct or not. So then I have to build that check into the Flow myself, hard coding comparison values or checking against a SharePoint list, or.. And as I also need the test to run in different languages, I would even have to create multiple Forms and Flows.

Highlighted

@Dean Gross, yes I know, but I have not seen this reflected in the Flow action. I need to know in the Flow if the answer sent in is correct or not.

Related Conversations