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

Like (0) Share

Report

Posted on 15 May 2024 20:25:09 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

I have the same question (0)

All responses (2)

Answers (0)

admin97 2 on 24 May 2024 at 18:15:45

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

Was this reply helpful? Yes No
v-yetonggu-msft on 16 May 2024 at 01:33:27

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

Was this reply helpful? Yes No