question

Pavel-2112 avatar image
0 Votes"
Pavel-2112 asked YanliJiangMSFT-7045 answered

Sharepoint library

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".
201981-screenshot-193.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".
201945-screenshot-195.png


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.
201982-screenshot-196.png
201908-screenshot-194.png

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!

office-sharepoint-onlinepower-query-not-supportedsharepoint-dev
screenshot-193.png (32.8 KiB)
screenshot-195.png (26.9 KiB)
screenshot-196.png (35.1 KiB)
screenshot-194.png (32.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YanliJiangMSFT-7045 avatar image
0 Votes"
YanliJiangMSFT-7045 answered

Hi @Pavel-2112 ,
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.