'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.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dora ,

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

Best Regards,
Dezhi

Was this reply helpful? Yes No
dora 18 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
dora 18 on at

Like (0)

Report
Copy link

Link copied!

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(...).

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
dora 18 on at

Like (0)

Report
Copy link

Link copied!

Thank you Dezhi. It works now.

Was this reply helpful? Yes No