I'm not sure what type of expression or function I need to achieve the following results
In data source A I have a vendor name, in Data source B I have a vendor name and number, I would to be able to extract the associated vendor number from source B to the name in source A.
How do I accomplish this?
Unlike Power Apps there is no direct Lookup function available in Power Automate. Here's the typical workaround.
How to lookup data in a SharePoint list in Power Automate (tomriha.com)
Check out the new Power Platform Community Connections gallery!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.