Answered

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

(0) Share

Report

Posted on by GFinlayTerumo

122

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?

Categories:

General topics

All responses (10)

Answers (2)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 122 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 122 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 122 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi this is definitely a step in the right direction I should be able to use this to iterate through.
Thanks
CFernandes 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @GFinlayTerumo ,

I am glad that my inputs helped. I hope that you have learned something new 😀.
GFinlayTerumo 122 on at

Like
a
(0)

Report
Copy link

Link copied!

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 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@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 122 on at

Like
a
(1)

Report
Copy link

Link copied!

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.