Unanswered

Help creating an item in a list from an Email TITLE

(0) Share

Report

Posted on by CarlesMartin

399

Hi guys!

I was wondering if it is possible to create an item with specified columns from a title in the mail. I will explain with more details what I did and what I need next:

First of all, I created a flow that "when item created" --> "send an email (V2) because I need it sensitivity in it. This is how the flow looks:

As you can see, I highlighted the subject which contains the values of the item I created and in the body I have always the same message + comments I will add in the item. I will show you how the list and the items look like forward:

So, the workflow I have is: I receive an email which contains documents and information that I attach to the item I create in the list. Then, with the flow I attached before, I send that information to others or "destinatarios" ("adresses" which is also one column in the list). Then I have another flow which sends those attachments to a library (it creates a folder and sends there the attachments outside I I don't know why I have this topic open Re: When item in list is created, create a folder ... - Power Platform Community (microsoft.com)).

So the thing is: try to create a flow when I receive a mail from manager with those attachments, create an item which contains all the metadata I need to then activate correctly the other flow without any manual work.

Is that possible? Hope it is, any help would be appreciate it.

Thanks!!

Categories:

Building flows

I have the same question (0)

All responses (22)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

Hi @CarlesMartin ,

Do you want to create an item in SharePoint list from the title of an email?

Based on your description, I have made a simple test for your reference.

This is SharePoint list for test:

This my test email:

The title of the email is concatenated from the required fields, separated by commas.

This is my flow:

In flow, the title of the email is separated into an array by the Split function, and each element is the value of each field.

Result:

Best regards,

Was this reply helpful? Yes No
CarlesMartin 399 on at

Like (0)

Report

Okey so I tried what you showed me. I understand I have to put all the info in the title of the mail with "," as a separator for each column of the item.
The initial part looks like that (I will send the mail to me once I received from others because they sent it forwards and would create problems, that's why I put myself in "From"):
So the first part, I think it's correct (correct me if not).
Next, is the create item which includes every column in the item and I fulfill it with the "variables" expression. I suppose it will takes every word between each ",".
So after these 2 steps we have the last, which is apply to each it appears another apply to each and I dont know why. Also it takes a different output, mine is "INFO" and yours it's "attachment".... Would it run correctly?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @CarlesMartin ,

The last step is to save the attachments in the email to SharePoint, such as pictures or files. If you are sure there are no attachments in the email, you can ignore this step. Because there may be multiple attachments in the email, there will be a Apply to each action. Its input is "attachments". The Apply to each "INFO" needs to be removed.

Best regards,

Was this reply helpful? Yes No
CarlesMartin 399 on at

Like (0)

Report

Hi @v-jefferni ,
Sorry for being so late answering this.
The thing is if I do that it will take every image in the body + the attachments of the mail. So I would need to apply a filter array = attachment is inline is equal false right? The thing is I don't know where should I put that. So following your steps, where should I put the filter array? (please attach an image where should it be for my understanding)

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @CarlesMartin ,

You can do it as below:

Best regards,

Was this reply helpful? Yes No
CarlesMartin 399 on at

Like (0)

Report

Hi @v-jefferni ,

but in this case, the create file indicates to put the attachments in a folder/library which it's not necessary in the flow. I just need to attach them in the create item I created before. Or what should I put in Create File?
In the create item action I can't add any attachments.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @CarlesMartin ,

The create file action is just an example, use Add attachment instead.

Best regards,

Was this reply helpful? Yes No
CarlesMartin 399 on at

Like (0)

Report

Hi @v-jefferni ,
Okay so the thing now is in the ID of Add Attachment, what should I pick?
And another question: could I make that can only happen if one person sends me the mail with an specific title of the mail? Like adding something in the subject filter, because it's a person that send me tons of mails, but I only want to create those items in specific cases. So putting in subject filter "Item" or something else:

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @CarlesMartin ,

It's the ID of create item, it means to which item the attachment will be add. For the second question, the subject filter is exactly used for the purpose you want to achieve. But this parameter only accepts static string.

Best regards,

Was this reply helpful? Yes No
CarlesMartin 399 on at

Like (0)

Report

Hi @v-jefferni ,
So I sent a Mail to myself with this tittle:
And this happens to the flow:
So maybe I misunderstood something of the flow. I thought that the title of the mail would be the item columns separated by commas. Maybe I should put in the subject filter "Transmittals" as is the thing they will send me but the question now is: where I should put the other metadata with the columns of the items? Look where the run fails:
Is it because the blanks spaces in the title?

Was this reply helpful? Yes No