Add Name from next item in a sharepoint list to an Email body

(0) Share

Report

Posted on by Laurelp

Hello to all,

I have a power automate that gets items from a sharepoint classic calendar list and then sends an email based on when a person is done with their on call. I use a sharepoint get items with a date filter to determine who to send the email to. What I'd like to do is get the name of the next person in the on call list and include it in the body of the e-mail.

I've tried a couple different ways but getting lots of errors and I'm not sure which process to use so I can lookup details. Still pretty new to the power automate world. Would appreciate any and all help or gu

So the Email will be going to Person 1 and in the body I want to include the name of person 2. The dates in this list are incorrect and just an example. The actual list has dates 1 person per week.

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

v-liwei-msft on at

Like (0)

Report

Re: Add Name from next item in a sharepoint list to an Email body

Hi @Laurelp

1. Since you need to get the item that meets the conditions and the name of the next item, you cannot use Filter query.
You need to put the filter conditions in the Filter query into the Filter array.
2. After Filter array, you need to perform a second Filter array (to get the ID of the next item).
3. Use Get item (Get the person's name for the next item.)

Best Regards,

Levi