Help with getting value from Sharepoint List just once

[DeepikaN]

I am getting user id from Dynamics 365.

My SharePoint list has the user id and user name mapping.

I am fetching the entire SharePoint list at the beginning of the flow.

Now, I want to read the user name based on the user id in Dynamics 365 and perform further processing

Please help.

[CollabTechie]

Hi @DeepikaN , you use this approach and then continue processing with an apply to each

You may want to map email eq 'email' or whatever else lines up with your scenario...

-----------------------------------------------------------------------------------------------

If my reply was helpful, please give a THUMBS UP or if this solved your issue, please ACCEPT SOLUTION so others in the community can identify it more easily. Thanks!

[DeepikaN]

Thank you for your reply @CollabTechie . This is a possible option. Let me explain my situation in detail though -

I have a lot of records, so I do not want to do a get items and filter for every item. I want to get the list once from SharePoint and then use may be an expression/dynamic formula to do something like this -

If SharePoint list contains id1, return name1

Please suggest.

Thanks,

Deepika

[CollabTechie]

Hi @DeepikaN , perhaps something like this? 

-----------------------------------------------------------------------------------------------

If my reply was helpful, please give a THUMBS UP or if this solved your issue, please ACCEPT SOLUTION so others in the community can identify it more easily. Thanks!

[v-bacao-msft]

Hi @DeepikaN ,

If you can get the item ID, you could use Get item directly to get the specified item.

Best Regards,