Unanswered

Creation file trigger flow

(0) Share

Report

Posted on by Daniel2024

hi all,

I created a simple schedule flow that should advise with an email for a new file creation in Onedrive folder (/Documents/Notifications)

step 1:

i selected "Automated cloud flow" > created the recurrency - ok

when i need to select the file name, i want to use the dynamic content (every time is a different file name) so i put this string:

'split(triggerBody()?['/Documents/Notifications'],'/').last()'. and i got this error:

"One or more fields provided is of type 'Null', a different type is expected."

what the problem? is the the string?

any of those strings doesn't work:

split(triggerBody()?['/Documents/Notifications'],'/')

last(split(triggerBody()?['path'], '/'))

last(split(triggerBody()?['/Documents/Notifications'], '/'))

the error

Thanks !

Categories:

Using flows

I have the same question (0)

All responses (12)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @Daniel2024 ,

Where are your files? There are no attributes to reference in your trigger, so flow will report a null error.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Daniel2024 on at

Like (0)

Report

not exactly,
there are some files and some are "new" to let the flow to recognize them
please see the folder status below

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @Daniel2024 ，

Maybe there is something wrong with my description.

I am not asking where your files are stored.

I want to ask if there are triggers and controls for getting files in your flow.

If you want to get the name of the file, you must first know how to get the file.

If I guess correctly, do you want to extract the attachment name from the email?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Daniel2024 on at

Like (0)

Report

hi, you are correct
the flow meaning is to advise that a new file was created and to send the file name by email to someone
can you please advise if the flow process is wrong and how should be?
thanks !

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @Daniel2024 ，

Do you want to check whether there are new files created every day, and if so, send all the newly created files through one email, or do you want to send an email notification every time a file is created?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Daniel2024 on at

Like (0)

Report

hi,
I prefer to set a schedule every hour that should collect all the new files created on the specific folder and send the notification by email

the main target is to create an "interface error files alert email" that will advise regarding the new files created in the specific folder (error folder).
but since i'm new on this area, i started to create a "simple" job/flow
thanks !

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
addHours(utcNow(),-1,'yyyy-MM-ddTHH:mm:ssZ')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Daniel2024 on at

Like (0)

Report

i follow your guide but i get this error in the second stage:
can you please explain what the problem is here? thanks

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @Daniel2024 ，

If you just want to send an email, take a look at this test:

For files created in the previous hour, we use the Apply to each control to cycle through the names and contents of those files, append them to an array variable, and send them in an email:

Created gt '@{addHours(utcNow(),-1,'yyyy-MM-ddTHH:mm:ssZ')}'

{ "Name":@{items('Apply_to_each')?['{FilenameWithExtension}']}, "ContentBytes":@{body('Get_file_content')} }

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @Daniel2024 ，

Show me a screenshot of the configuration parameters in your Filter Query.

I used this expression flow in Filter Query without getting an error.

My Flow Run Successful:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No