'Format data by examples' test successful, but fail in the production execution

(0) Share

Report

Posted on by dora

Dears,

I occur to a problem in using 'Format data by examples'.

I would like to extract my file name, to get the category name. I got it successfully in 'Format data by examples'.

This is what i would like to have.

While I put it into the 'send email'-body, I cannot get this result. I received the email like this:

My variable setting:

My send email setting:

I only have 2 variables: BU and reportDate, both of them failed to display.

Can anybody help on this?

Thanks a lot.

All responses (5)

Answers (1)

dora 18 on at

Like (0)

Report

Re: 'Format data by examples' test successful, but fail in the production execution

Thank you Dezhi. It works now.
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Re: 'Format data by examples' test successful, but fail in the production execution

Hi @dora ,

If your filenames have a fixed format, you can try the following.

split(split(base64ToString(triggerOutputs()?['headers/x-ms-file-name-encoded']),'--')[1],' ')[0]

Best Regards,
Dezhi
dora 18 on at

Like (0)

Report

Re: 'Format data by examples' test successful, but fail in the production execution

Hello Dezhi,
I have more and more problems now.
1. The flow works again, but it really missed 2 new files and capture the 3rd&4th new files. Does it mean that in the normal operation, power automate will miss some of the new files?
2. Base64toString:
It show me the error msg:
I have 2 variables, one is BU, which only has characters; another one is requestdate. Its data type is string and the value is serveral number, like 1220.
My slicer:
slice(triggerOutputs()?['headers/x-ms-file-name-encoded'], 13, indexOf(triggerOutputs()?['headers/x-ms-file-name-encoded'], ' '))

3. When I get the error msg and go back to edit the flow, i cannot find Base64toString in the variable, it still shows the slicer(...), i remmber that when i change it into base64, it shows base64tostring(...).
dora 18 on at

Like (0)

Report

Re: 'Format data by examples' test successful, but fail in the production execution

Hello Dezhi,
The trigger is the same as your screen cut. I used 'when a new file was created in sharepoint'.
I just try the base64tostring, but i don't know why the Automate fails to capture my new file in the sharepoint and the flow cannot be triggered.
This has also happened in this morning, and it can capture the next new file updated.
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: 'Format data by examples' test successful, but fail in the production execution

Hi @dora ,

Could you please show the trigger you used?
You could try base64ToSring() to convert the output.

Best Regards,
Dezhi