I had a Flow developed that was working nicely up until this morning. The Flow was triggered by a new item in a SharePoint Online list, after which an Approval Email (O365) was sent, followed by a conditional check (Approved? Rejected?) and lastly an update to the source list item.
We have an on-premise AD instance that we use for authentication in O365. However, we do not use Exchange Online. I set up two different "tenant accounts" (not in AD, purely on the tenant) that I granted Full Control and Site Collection Admin rights to within the site that holds the list used in the Flow mentioned above. And again, the accounts + Flow were working great until this morning.
First thing this morning, the accounts were unable to read values from SharePoint list items. I deleted the Flow, thinking I would just rebuild it and that would fix things... and now, neither of the "tenant accounts" (i.e. "@tenantname.onmicrosoft.com") can even connect to the SharePoint Online site. I've gotten a blend of NetworkError messages and Access Denied, even though the accounts, as I said, are full control and site collection admin.
To make things stranger, the AD account I use regularly is able to authenticate successfully and can communicate between Flow and SharePoint. However, I can't use my AD account because it doesn't have an associated Exchange Online account.
Is anyone aware of anything odd going on between SharePoint Online and Flow today? Anyone experiencing similar issues? I'm not sure where to go with this one except to wait it out and try again in the morning...
Hi CC_LE,
I created a flow which was triggered when a new item was created in SharePoint Online list, sent an Approval email. Followed by a condition. If the Selected Option was equal to Approve, Update item in SharePoint list. This flow worked well, there was no problem with SharePoint Online connection. Here is a screenshot of my flow.
Did you try to create a flow with SharePoint Online again? Did your flow work well now?
Best regards,
Mabel Mao