Hello,
sorry it took me some time to work out the nuance of inserting an image into the forum.
I start with getting notes when one is created. - from CRM trail can take up to 4 hours to trigger? - but works.
then filter on when it relates to a work order. - works as expected
Then i filter where isDocument is true. - using advance because "true" does not equal true.
Then Currently i attemp to convert from base64 to binary, but inserting into a compose field the value: "@{base64toBinary(triggerBody()?['documentbody'])}"
once saved this for some reason hides the code but still preforms the desired action.
then i try inserting into Sharepoint.
From the outputs you can see the filename and type are being identified correctly.
and there is no errors.
Trying to open it in sharepoint returns:
This is the sample output from the saved file being opened with notepad when NO Base64toBinary convertion happened:
as you can see it just populated the file with a base64 string.
once i added the base64 to binary convertion in the compose task i get these different files:
correct on the left, incorrect on the right.
as you can see its close, and with a Hex editor its actually very simular, however i am not sure where it goes wrong.
The out of the box solution does not hold a constistant type for files, and i feel flow should take care to tranform data to one type when dealing with it internally and converting where required on the save and retierve connectors.
