cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamiehandelman
Frequent Visitor

PowerApps Triggering Flow to Create SP List Item Fails for Only some users

I have a PowerApp that i've embedded to a Power BI Dashboard. Whenever a user uses the PowerApp for the first time, they have to put in their SP login, and press accept on the SQL connection as well. 

 

Users enter data in the PowerApp - press submit, and the Submit button triggers a flow that creates an item in a SP List. I should also mention our SharePoint is on-premise. 

 

Only for some users do I get the error below in the Flow. All of the required fields are filled out, there are no values missing. I have narrowed this down to that it must be an authentication issue. All users have full control permissions to the SharePoint list. Can anyone help? 

jamiehandelman_0-1663944843880.png

 

4 REPLIES 4
phipps0218
Super User
Super User

Is the record being updated and stored in SharePoint correctly?

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

The flow creates the item in sharepoint and that's where it's failing. It succeeds when some users enter data into the powerapp (triggering the flow to create the sharepoint item), but fails on other users. 

Pstork1
Dual Super User
Dual Super User

Did you verify that all the users also have access to the On-Premises gateway?  That might be preventing them from accessing the On-premises SharePoint even if they have permission to the list.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Yes, our 'everybody' domain group has admin level permissions to the gateway. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,635)