Sharepoint lists with multi value vlookup and power automate

Like (0) Share

Report

Posted on 26 Jan 2021 08:29:33 by karlijnk

Hi!

I'm pretty new to power automate but I'm loving it so far! I need some help with this new flow I'm working on.

I've got 1 list of events. Notes things that happened on a certain date to a certain dog.

The second list is a list of Session. They are about a certain dog on a certain date

I would like to automatically update a Vlookup column with the corresponding events on the same dog with the same date.

Example:

On 16/01/2021 the dog Peter didn't feel well. The Title is "sick" dog = "peter" date = 16/01/2021

In the other sheet we log training session. So on 16/01/2021 we did a short training session with Peter. I would like power automate to fill in the things that happened on that same day to the same dog. So in de vloookup column events: I would like it to link to: "Sick"

The trigger isn't very important. I would be fine with a button to activate. or scheduled trigger.

I have the same question (0)

All responses (3)

Answers (2)

karlijnk 13 on 26 Jan 2021 at 08:42:08

Like (0)

Report

Re: Sharepoint lists with multi value vlookup and power automate

Example events:
Example sessions:

Was this reply helpful? Yes No
Verified answer

v-yiwenxie-msft Microsoft Employee on 27 Jan 2021 at 05:50:45

Like (0)

Report

Re: Sharepoint lists with multi value vlookup and power automate

Hi @karlijnk

In my understanding, you want the lookup column in the list of training session to be filled with event that happened on the same day to the same dog.
That is, the content should be filled in lookup column comes from the column ‘event’ from the list of events.

If I’ve misunderstood your need, please feel free to let me know.

To meet your need, flow has to get items of both lists and compare the dog name and date are the same, then fill in the lookup column with the ID of matched item in list of events.

I’ve created a flow as below:

The content should be filled in ‘LookupColumn Id’ is the item ID of the list of events because the column data comes from the list of events.

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

Was this reply helpful? Yes No
Verified answer

karlijnk 13 on 27 Jan 2021 at 11:42:31

Like (0)

Report

Re: Sharepoint lists with multi value vlookup and power automate

Hi!

That does work indeed! however there was one problem I ran into. Being that multiple events could happen on 1 day to a dog. This meant the vlookup should be a multi select vlookup. Making it difficult to Update. I managed to update it today and im so happy!!!

What was still missing was me formulating the correct input for a multi value vlookup. It should be an array with this format:

So what i did was this:

Was this reply helpful? Yes No