You’re offline. This is a read only version of the page.
22
I have a very odd problem/behavior with a Power Automate Flow.
The purpose of the flow is to automatically file emails into the relevant client folder.
There are hundreds of clients so maintaining Outlook rules isn't an option, and it needs to work for both inbound and outbound emails.
The flow triggers when a new email arrives.
I then run a SQL Stored Procedure that logs the email details into a Table,
Based on certain conditions, we then run a second Stored procedure, that returns the Outlook Unique folder ID
Then using V2 Move email - it moves the email to the client folder.
95% of the time it runs flawlessly.
Then occasionally returns a error:
The thing is the Id isn't malformed.
I have compared two ID's one from a successful run and one from a unsuccessful one and they are identical apart from the end digits (I have replaced some of the digit wth *** to protect the actual ID's)
Failed ID:
AAMkADQ3ZDdmYjYwLTg**************************BGAAAAAAChIeAr1zcBRrXEa1ctRYqQBwA-aZMi0FcjQqnLHtkDZa08AAAAAAEMAAA-aZMi0FcjQqnLHtkDZa08AADG4OEIAAA=
Successfull ID:
AAMkADQ3ZDdmYjYwLTg**************************BGAAAAAAChIeAr1zcBRrXEa1ctRYqQBwA-aZMi0FcjQqnLHtkDZa08AAAAAAEMAAA-aZMi0FcjQqnLHtkDZa08AADG4OEKAAA=
Now for the extra special strangeness.
Currently, this is only failing when one particular outlook Folder_ID is returned, but it is the correct Folder_ID, I have triple-checked it, and according to the error message that isn't why the flow is failing.
It turns out it was something corrupt in the Folder ID from the Outlook folder, not the message ID.
We renamed the old folder, created a new one, then using the new folder ID, the messges moved correctly.
Would have been helpful if the error message had said Folder_ID and not simply ID, which I took to be the message ID 🙄
I understood that the message ID's wouldn't be identical, they are different messages after all.
Share
Report
All responses (
Answers (
and they are identical apart from the end digitsThat means they are NOT identical. These IDs are Base64 encoded versions. Run them through the Base64 online decoder and see which character is causing the issue. Might be as simple as a trailing space or backslash.
What happens with an email when you get this error - does it really move?
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
