Trying to pick files from chat and store it elsewhere

[slaik]

I searched it on various forum but not able to locate an approximate solution for this.

My main objective is to trigger when a chat post is made with a certain keyword.

Once triggered I should be able to locate the attachments in the chat, separate them by their respective extensions, and then move them to their respective folder.

I have so far been able to 

1. Trigger on keyword.

2. Read the message and the body text

3. split the body text and isolate the etag(s) within(incase of more than one attachment in a single post)

4. I now need to identify the file within the /microsoft teams chat folder/ in our onedrive and then get it's actual name(so that i can process the file type) and then move the file based on file path.

I am not able to figure out how to get the file name matching for the etag. My vague solution would be to loop through the files in the folder and go through their properties and incase of a match pick the file name. However that mean a loop repeating for each attachment and that seem inefficient incase there's a openquery or some other smarter solution exists.

Please help & guide me on this.

Thanks.

[slaik · Accepted solution]

So, for those who will find this question after me lost and frustrated equally the same.
Have hope, it can be solved, not exactly how I first thought but in a much simpler way.

1. First point, pay more attention and don't start writing code at the middle of night coz you had and idea and now you can't sleep. For me, if I wasn't so sleep deprived, i would have noticed, that if i compose the body parameter, it also returns the JSON with attachment tag.

2. Next, take out the length of the attachment parameter and store it in a variable.
Formula:

length(outputs('Compose')['attachments'])

length(outputs('Compose')['attachments'])

3. Decrement it by 1 here(or later when you are looping) coz array start's at 0.

4. Loop though number of attachments.
5. Get the name of the current attachment by formula like this:

outputs('Compose')['attachments'][variables('FilesList_count')]['name']

6. Also store the path of the attachment by formula like this:

outputs('Compose')['attachments'][variables('FilesList_count')]['contentUrl']

7. Start your crazy rabbithole of if-else to filter based on the type of file it is depending on your need. If you are trying to handle images from Apple phone like I did, don't forget to handle .HEIC extension.

8. For each type run a sharepoint move file logic that will move the file from it's original sharepoint location to the new location.

9.Dont forget to decrement the loopcount variable in order to run the loop properly.

10. Once done, perhaps use reply to channel or chat logic to put a note that the operation was completed.

Cheers.