cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mr0bb0
Frequent Visitor

Help building a policy reminder flow with a slight twist

HI,

 

I'm building a reminder flow for policy documents where each policy author is emailed a reminder when their policy is going to expire.

 

I think I've managed to resolve this section using https://www.c-sharpcorner.com/article/send-an-email-reminder-notification-based-on-expire-date-using... but the next section is giving me a little trouble.

 

The reminders need to be sent to document author emails which is a lookup to a different list.

 

Can anyone tell me how I would bring in the data from this second list.

 

At the minute I'm using an apply to each to for each document and filtering the array to bring in the email from the other list.

 

I'm not sure what to do next, any ideas would be appreciated.

 

Thanks

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Mr0bb0 ,

 

Follow the amb's suggestion, if you have filtered out items and want to get lookup column details, you could refer to the following image to get author email.

 

For example, I created a lookup column in TestLibrary, named Author, look up to Test List.

 

We only need to use Get item action to get the specified item in the lookup list. And we should configure lookup column id output from the above step(Get files/Get items action).

Image reference:

171.PNG

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
abm
Super User
Super User

Hi @Mr0bb0

 

You could try using the Get Item action step, select the second list and set the id as the lookup id.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Mr0bb0
Frequent Visitor

Thanks abm, not sure I quite understand 

 

At the minute I have:

 

filterarray.PNG

Does this make it any clearer?

 

Hi @Mr0bb0 

I can see you have a filter with some condition in that. Once that is done then you need to iterate each values from the array and use the lookup id for Get Item for your next list.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
v-bacao-msft
Community Support
Community Support

 

Hi @Mr0bb0 ,

 

Follow the amb's suggestion, if you have filtered out items and want to get lookup column details, you could refer to the following image to get author email.

 

For example, I created a lookup column in TestLibrary, named Author, look up to Test List.

 

We only need to use Get item action to get the specified item in the lookup list. And we should configure lookup column id output from the above step(Get files/Get items action).

Image reference:

171.PNG

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-bacao-msft 

 

Thanks that's a great help. Sorry for the delay in replying but I've been away.

 

However I'm not sure where I get the authorid from Get Item in the lookup list?

 

I've tried using Document Author WssId but that doesn't seem to work.

 

If I can explain this correctly, I have a job role in the main document library, this is linked to and Author and Manager in the look up list through the job role field.

 

Also where do I use this (is it still required in your solution?)

 

filterarray.PNG

 

Thanks

abm
Super User
Super User

Hi @Mr0bb0 

 

I thought this is marked as solution accepted.

 

You should be able to access like below. Here ListB is my lookup column.

 

From the dynamic properties you can see the values like below.

 

image.png

 

Above ListB Id is the id of the lookup

 

Thanks

 

 

 

 


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

 

Hi @Mr0bb0 ,

 

You should get Job Role Id like the Author Id mentioned in my post.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,949)