Unanswered

MS template Flow for "Once an Outlook email is recieved, add it to a SharePoint list" NOT WORKING

(0) Share

Report

Posted on by S2000

Please help me understand why the flow is not working as intended. I am trying to generate a list in SharePoint based on specific emails that are recived from a specific sender DL. I have configured the out of the box Flow template for "Once an Outlook email is recieved, add it to a SharePoint list" and connected my O365 Outlook account and SharePoint accounts provided through my organization.

The behavior I would expect when the flow runs is:

1. I recieve an email from the specific sender in my inbox. The flow is trigger when an email is recieved.

2. If the sender is validated as the correct attribute, the flow will create an item in the SharePoint list capturing the designated variables I have specified and populate the corresponding columns in the list.

The behavior I am experiencing:

1. I recieve email and flow runs

2. No matter who the sender is, the flow will run and the run history indicates the run completed successfully (HOWEVER) there is no data being captured in the list.

At a loss for what my next step should be....

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi @S2000,

Could you share a screenshot of your flow?

I assume that you are trigging a flow based on the sender’s email address. If it comes from a specific person, trigger the flow, if not, do nothing.

I have made a simple flow likes below for testing and the issue you mentioned could not be reproduced. The flow will be only triggered when the email comes from the specific person, and corresponding columns will be created in the list.

Could you try again with it? Please feel free post back with more details if you are still having the issue.

The following doc on how to trigger a flow based on email properties for your reference:

https://docs.microsoft.com/en-us/flow/email-triggers

Best regards,

Mabel

Was this reply helpful? Yes No
S2000 2 on at

Like (0)

Report

Thanks @v-yamao-msft. I created a new flow using the same variables in your screenshot and created a new list for the data. When I created the flow I chose "Received date" from the Dynamic content in the wizard that appears. When I did that the "Date" column name was changed to "Date_x0020_and_x0020_time". When I run a test of the flow, I receive a 400 error based on the column name change. (See screenshots). It seems that the flow is failing due to the change in the standard column, however I have no way of changing it back since it's a "static" field.

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

Like (0)

Report

Hi @S2000,

Could you try to remove the space within the column name then try again?

I have made another test based on your description, it could not be reproduced by me.

The date and time column is named as Date and time, however, it won’t be changed automatically to "Date_x0020_and_x0020_time".

Please remove the space in the column name and try again.

If you are still having the issue, please feel free post back.

Best regards,

Mabel

Was this reply helpful? Yes No