I am writing to hopefully get some help with using Power Automate flows. Currently we have a visitor form that users fill out and submit to a SharePoint list. The form for this is made using a custom Power App form that is connected to the SharePoint list. When a user submits it will check for required fields then run this command,
(SubmitForm(EditForm1) And Navigate(Submitted) And 'VisitorFormSubmissionFlow'.Run()). We are having issues where the Power Automate flow does not get started, however the Power App successfully submits the form data to the SharePoint list. Additionally, we once had the Power Automate flow fail due to its connection to SharePoint when the flow attempted to GetItems for the latest item, this showed us an error with the login token expiring. The way to fix the first issue requires going into the Power App and refreshing the connection to Power Automate. The fix to the second issue requires disconnecting the connection from Power Automate to SharePoint and reconnecting it. All of these flows and Power App's were created under my user.
I am quite new to using Power Automate and Power Apps and do not know if I need a different setup for the connections to be persistent.
I would recommend for that to use a application user to connect to your Sharepoint list, because if you are using a normal user, and in your company have security definitions that expire you authentication, for security reason, you will always have problems with the connection.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.