When a File is created in a folder - Excel Get Worksheets

[GFinlayTerumo]

I have a .csv file that is to be uploaded to a SharePoint site, the Flow will then go through the data and update information based on the content of the file.

I have tried to use the File Name Encoded and get Item Not Found error

I have also tried using the Get HTTP Request From SharePoint action but I cannot figure out how to get the correct Uri.  

I get the following error;

My Document Library does not sit in the default Documents library.

What am I doing wrong with the HTTP GET request?

[CFernandes]

Hey Mate,

@GFinlayTerumo 

A Quick question, If you click on the Folder, can you select the file?

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[GFinlayTerumo]

Hi thanks for your reply.  I can just now but that's only because the file is was uploaded then the flow failed.

The whole point of the flow is to trigger when a file is uploaded so it won't be selectable in the Get worksheets as it will have just been created.

Thanks

[CFernandes · Accepted solution]

Hello @GFinlayTerumo 

In HTTP you can can get the file content - using the below.

API URI - _api/web/GetFolderByServerRelativeUrl('Source')/Files('@{outputs('Get_file_properties')?['body/{FilenameWithExtension}']}')/$value

Reference  - https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[GFinlayTerumo]

Hi

Thanks for the info, this is passing and I can now see 'body' in Dynamic Content.  However I cannot seem to use it for anything, my initial plan was to use the csv that was uploaded and iterate through the rows by creating a table.  I would then use the information in the table to update a series of lists based on each line.

How can I use the File content that this HTTP request has gotten?

Thanks

[CFernandes · Accepted solution]

Hey @GFinlayTerumo 

From the Body you can extract the base64 using the formula below-

outputs('Send_an_HTTP_request_to_SharePoint')?['body']['$content']

You can then Convert the above to String -

base64ToString(outputs('Compose'))

Output -

Now that you have the content you might be able to use it for your requirement.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[GFinlayTerumo]

Hi this is definitely a step in the right direction I should be able to use this to iterate through.

Thanks

[CFernandes]

Hey @GFinlayTerumo ,

I am glad that my inputs helped. I hope that you have learned something new 😀.

[GFinlayTerumo]

Hi @CFernandes 

thanks again for your help.  I now have the csv data in the following Compose

I am now attempting to either build a table with the information in the Full Name column or just have an array with the information so as I can use each name to iterate through my list.

I've tried using split() but I can't find a good way to make it work.  I have also tried just Appending to an Array variable but it just takes everything as one value.

Do you have any ideas?

Thanks

[CFernandes]

@GFinlayTerumo 

Hey Mate, 

What happens when you split using space?

split(<variable>,' ')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[GFinlayTerumo]

Hi

It doesn't give me the expected results.  I have decided to go another way with my project but thanks for all of your help.  The HTTP request part will definitely come in handy somewhere else.