Hello all!
I have built a Sharepoint site where Sharepoint events point to Teams webinar registration links for various training courses used by various employees through my organisation.
I'm then getting the .csv report from each event to get the attendance list and I have created a flow that triggers when the .csv files are dropped in a specific Sharepoint folder.
Before the flow triggers, please note that I can open the .csv file in Excel or Notepad++ and the information is displayed correctly (the data is not corrupted or badly encoded).
The flow does 2 specific things:
1. Get information from the ActiveDirectory for each attendee and put that information in a dashboard so we can get statistics for attendance in each department.
2. Export the user data on a Sharepoint list used to send e-mail surveys based on attendance for each event (sending the survey is a separate flow to automate it all).
I'm using the trigger "When file created (properties only)" following by a condition that makes sure it's a .csv file.
I then get the file content (It doesn't matter if I select "yes" or "no" to the infer question; the result is the same):
with the following output:
{
"$content-type": "application/octet-stream",
"$content": "//4xAC4AIABSAOkAYwBhAHAAaQ..."
}
I have searched for a while as to what to do past this point. I read that I can use the base64tostring() formula to decode the content. While using this formula:
decodebase64(outputs('Obtenir_le_contenu_du_fichier')?['body']['$content'])
I can see that I decoded the string, however it's filled with garbage:
When I input the $content string on https://www.base64decode.org/, I can see the data formated the way I want it and without the garbage.
I'm wondering what to do at this point, I have tried using the OneDrive for Business action to get the file, but I can't seem to use it to fetch a file on Sharepoint. I have found a few posts with users reporting this exact behavior, but none of them get a solution that works for me.
I know I could purchase some premium connector to parse the .csv, but that option isn't accessible to me. I'm confident I can manually parse the .csv and do what I want with the data after I get a clean conversion. I'm assuming it must have something to do with the conversion format, but I'm not sure how to tackle it.
Oh and I had another flow that did the exact same thing, but with the deprecated trigger "get file when created" and I'm trying to build a flow that is not based on a deprecated action.
Thank you!
Edited to clarify my goal with the flow as well as additional test information.
