Hello,
I am using the List rows inside of a For Each action. I have left the action named as 'ListRowsPresentInTable'
When the action runs, it outputs a JSON file, as below
I now need to flow to check the values inside of the 0,1,2,3,4 etc.
Inside of each 0,1,2,3,4 are the following columns from the excel
Name,
Employee Number,
Manager,
Department
I need to do a check to ensure that each value is populated. So it need to loop through all the rows and check to see if they are blank.
I have tried to do a condition, but I don't know how to use the expression to do the check against each value. I have added in a condition to say :
If body('List_rows_present_in_a_table_2')?[0]?['Name'] is equal to 'null', then do send email.
However, there is something wrong with the expression I have written.
What I need it to do is, for each row, check to see if theName,Employee Number, Manager,Department are blank.
Can someone please assist me?
Thanks
