Sharepoint library

Question

Hi!
I've a library "Upload Library", where I upload the images (PNG, JPG, BMP, GIF). I choose the category from drop-down menu. For example "PNG".

Then, based on the value in the Category field, the file is assigned an ID/type by concatenation of the Category fields and the value of the corresponding number in the Index_List. For example "PNG_0". After that, 'one' will be added to the number in the sheet and the next file with this extension will have Type/ID "PNG_1".

The file should move to the correct folder in the library "Destination_Library", according to the specified category. If the folder doesn't already exist, create a new one.

So, my question is, how can we choose the right number from the list "Index_List" to set the desired Type/ID for the file. And if we create a new category, how to add it to this sheet and take the number?
Thanks!

Answer 1

Hi @Pavel ,
According to your description, you can try to use Power Automate to achieve your requirement, we suggest that you can go to the Microsoft Power Automate Community for professional help.
Thank you for your support and understanding.
Thanks,
Yanli Jiang

===========================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.