I have started to create a very complex conditional flow with the below scenario:
We will be provided with an excel with two sheets:
Sheet1 contains Email Ids and Names. These are our leads.
Sheet2 contains Account Holder Name, Account Type, Account Balance, Assigned To. This will have all the types of acount, each account holder will have multiple accounts, different types. Sample data attached. Each account holder will be assigned to a lead from Sheet1.
Use Case: Once we trigger using Flow, the goal is to have Flow pull the emails/rows from Sheet1 -> For Each value, get the corresponding rows assigned to in Sheet2, put in a table and send it to the lead in an email. I apologize for making it very confusing.
|Account Holder Name||Account Type||Account Balance||Assigned To|
For Each value in Sheet1, pull the corresponding values in Sheet 2 and send all of them in an email.
Here is the flow I started to create. Not sure what to enter in 'Key Value'.
Hi @BB9 ,
I assume that you would like to get distinct value for each “Name”.
Please check if the following thread could be a reference for you:
I have followed all the steps mentioned in the other post, however, as many of them in the same other post mentioned, I am stuck with the below error:
Unable to process template language expressions for action 'Apply_to_each' at line '1' and column '2032': 'The template language function 'first' expects its parameter be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#first for usage details.'.
I have tried all the options but does not seem to be working!
Hi @BB9 ,
Could you share an image of your current flow?
What’s the function used in this step?
The error message says that the value you provided for the first expression is Null. Please make sure the value you used in the function does return a value.
Hi @BB9 ,
What’s the column type of AssignedTo field? Is it of type People or group?
In the sample thread, it is of type people or group as well.
Yes, the column type is Type Person or Group. I have tried both with 'Allow selection of Groups' on and off as well.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!