Unanswered

Create an flow, which triggers when an email arrives, and delete items from sharepoint list.

(0) Share

Report

Posted on by admin97

Hi Team,

I'm creating a flow, where it triggers when an email arrives with Subject 'XYZ'. It fetches the details from the email body and compare with each ID value of SharePoint list. If it matches, then it deletes the item from the SharePoint list?

I've already created a flow for onboarding where I converted the email body to text, and using split function I differentiated it and update the corresponding value required. But how can I create a flow for delete item from SharePoint list

Please, help.

Thanks

All responses (2)

Answers (0)

admin97 2 on at

Like (0)

Report

Re: Create an flow, which triggers when an email arrives, and delete items from sharepoint list.

Hi Team,

I've crated a flow on the basis that the user is sending an email with only employee name,

As, till the condition flow is running perfectly where the condition gets true as the Title field matches with the output from the mail Employee Name. But when I'm adding the title field in Delete Items Parameter. I'm getting error. As, Object ID should be integer.

Is there any way possible that the complete row can be deleted on the basis of the condition where Name=Name verifies the condition as true? Or what can be done to achieve what we require?

Please, help.
Thanks
Ravikant
v-yetonggu-msft on at

Like (0)

Report
Re: Create an flow, which triggers when an email arrives, and delete items from sharepoint list.

Hi @admin97 ,

Please check this test:

My SharePoint List:

My Email Body:

My Flow Configuration Parameters:

split(split(outputs('Html_to_text')?['body'],'ID:')[1],decodeUriComponent('%0A'))[0]

@contains(triggerOutputs()?['body/subject'], 'XYZ')

The Result:

Best Regards,

Sunshine Gu