Echec condition Flux desktop

[Philippe_D13]

Hello,

I create a flow to detect the creation of a file and I want to catch the name of this file to test if present and start a new action.

Here below the screenshot.

The flow end with an error when the file is created, do you know what is problem ?

[Henrik_M]

There's a better chance of getting help if:

1. You show the error.
2. Post in the right forum.
3. Switch language to English, so most people can have a better idea of what's going on.
4. 😊 

[Philippe_D13]

Hello Henrik,

I have publish the error , you will find below the text for it :

"status": 404,

  "message": "The resource could not be found.\r\nclientRequestId: db9901b5-5caf-4bc4-8985-f8c59730edc4\r\nserviceRequestId: d04c63d0-bb6e-4b16-bf51-9419a6d7c600",

  "error": {

    "message": "The resource could not be found."

  },

  "source": "excelonline-we.azconn-we-002.p.azurewebsites.net"

}

Regards

[Ankesh_49]

@Philippe_D13  Could you please act on the suggestion by @Henrik_M 

However, based on your screenshot. Below is my recommendation:

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Philippe_D13]

Thanks Ankesh,

what I want to do with my test is to detect when a file is create "Appareils ECME GR1.xlsx" and if it is présent in the folder "C:\Users\Dumasdelage\OneDrive - TDF SAS\5-ECME\Information planification" , I want to create a Table.

Regards

[Ankesh_49]

@Philippe_D13 Did you give it a try, above screenshot actions?

[Philippe_D13]

Yes but there is 2 operations in "the apply to each " one is true the other false.

Even with the true condition the action is not realized :

[Ankesh_49]

@Philippe_D13 Plz help me to help you. Would you mind switching the language to English in power automate settings and ask your queries. 
It’s very difficult to comprehend, your issue. 

hope you understand. 

Thanks

Ankesh

[Ankesh_49]

@Philippe_D13 I believe you should provide sheetname!range in Table range input field. 

Hope it helps!!

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Philippe_D13]

Here is the the screenshot in english , with the error details

[Ankesh_49]

@Philippe_D13 

Here you go, 2 possible solutions:

1. Add "Get file metadata" action in your flow as below and use its output 'Display name' in your condition to verify.

2. File name is encoded, use expressions to get encoded file name as shown below. In this case you wont have to use 'get file metadata' action.

Hope it helps!!

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Ankesh_49]

@Philippe_D13 Is your problem resolved?

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Philippe_D13]

Hello Ankesh,

the message error is the same as you can see below :

[Ankesh_49]

@Philippe_D13 Ok perfect, condition issue is resolved. 

Now the issue is with create table action, please refer below screenshot:

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Philippe_D13 · Accepted solution]

It works perfectly , you're the Ankesh 😁💪

[Ankesh_49]

@Philippe_D13 Glad it helped.👏

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.