update a column when a file is named with

[Ulysse4733]

Hello,
I'm new to the forum and I'm not very good at English. I am sorry for that. I post here to get help on creating a flow to allow me to automate an action.
I use a document library with columns for progress tracking. I have a file for each case in this library. I would like:
when a file labeled "validated" is added to a specified folder of this library.
the "status" column of this library is updated with the mention "validated"

in other words, when I add or rename a file in a folder with the mention validated, the column is updated with the corresponding mention

Can you help me

Thanks

-- 

Bonjour,
Je suis nouveau sur le forum et je ne suis pas trés doué en anglais. Je m'en excuse. Je poste ici pour avoir de l'aide sur la création d'un flux pour me permettre d'automatisé une action.
J'utilise une bibliotèque de document avec des colonnes pour le suivi de l'avancement. j'ai pour chaque affaire un dossier dasn cette bibliotheque. Je souhaiteraisque :
lorsqu'un fichier portant la mention "validé est ajoutée à un dossier spécifié de cette bibliothèque.
la colonne "statut" de cette bibliothèque soit mise à jour avec la mention " validée"

[v-xiaochen-msft]

Hi @Ulysse4733 ,

Need more information.

How do you labeled the file? 

What's the data type of 'status' column? Is it a choice column or anything else?

Best Regards,

Wearsky

[Ulysse4733]

How do you labeled the file? 

I save it with the signed mention at the end

What's the data type of 'status' column? Is it a choice column or anything else?

ccurrently it is a choice list column with 3 possible statuses

[Shujaath_Khan]

Hi @Ulysse4733 

can you as below 

where we would be having - for label in last for example filename to be helloworld-Choice 1.xlsx

split(split(triggerOutputs()?['body/{Name}'],'-')[1],'.')[0]

We've to make sure the label name should be from choices column.

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[Ulysse4733]

Thanks for your help.

Is it possible to update the column of the file AND the folder the file is located ?

because, I track the status on the columns at the folder level

[Shujaath_Khan · Accepted solution]

Hi @Ulysse4733 

here you go, apply as below

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[Ulysse4733]

Je rencontre un problème. Probablement un souci dans la traduction entre les commande en anglais et en Français 

I have an error. Probably a problem in the translation between the commands in English and in French

[Ulysse4733]

Bonjour,

désolé mais je n'arrive pas à effectuer l'opération. Je reprend donc l'exemple:

J'ai une bibliothèque de documents que j'appelle "BIBLIOTHEQUE" contenant des dossiers. 

Cette bibliothèque comprend une colonne "statut" de type choix (choix 1, choix 2, choix 3)

Je souhaite mettre à jour la colonne "statut" du dossier lorsque j'ajoute ou modifie un fichier contenu dans ce dossier en le renommant avec la mention "-valide" (cad file-valide.xls).

Pourriez vous reprendre  le modèle avec cet exemple pour que je comprenne SVP?

Hello,

sorry but i can't do it. So let's take the example:

I have a document library which I call "LIBRARY" containing folders.

This library includes a choice type "status" column (choice 1, choice 2, choice 3)

I want to update the "status" column of the folder when I add or modify a file contained in this folder and renaming it with the mention "-valide" (for this exemple : file-valide.xls)

Could you repeat the model with this example so that I understand please?

thank you

[Ulysse4733]

Bonjour, j’ai finalement réussi à configurer mon flux pour mettre à jour une colonne selon la modification ou la création d’un fichier dans le nom se termine par « signe ». Je rencontre quelques problèmes.
1) Initialement à cause du caractère « _ » que j’ajoute qui a été résolu sans que je comprenne pourquoi.
2) maintenant je rencontre souvent des notifications d’échec.
Avez-vous des sujétions pour améliorer ce flux ?

Hello, I finally managed to configure my flow to update a column according to the modification or creation of a file in the name ends with "sign". I encounter some problems.
1) Initially because of the " _ " character that I add which has been resolved without my understanding why.
2) Now I often encounter failure notifications.
Do you have any suggestions for improving this flow?

[Ulysse4733]

Hello,
I come back asking for help on this stream.
I observe that the stream fails half the time. I can't fix it so I don't get a failure notification anymore.
Below is the error code

Any ideas to fix the problem ?
I have the impression that it executes the stream twice the first time for the file to be marked... the second for the same file which has been renamed...

[Ulysse4733]

To solve the problem, I think I have to configure the trigger condition.

I learned a lot from this link.  

It could be useful for others

@contains(triggerOutputs()?['body/{FilenameWithExtension}'], 'xxxxxxx')

it seems to work, I still have to follow the execution over a few days