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.
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!
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
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!
Hi @DeepikaN ,
If you can get the item ID, you could use Get item directly to get the specified item.
Best Regards,
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
15 | |
10 | |
8 | |
7 | |
6 |