Power Platform Community Forum Thread Details

Retrieve all SP lists based on column with value

Hi,

I want to retrieve all the SP lists that has a column (Owner or Responsible or Manager) with the value (email).

Exclude if a column exists but does not have the value,

My current flow able to retrieve all the lists that has either of the columns but got an error if the one does not exist.

varOldStaff - email

varColumnExist-array

varColumnNotExist-array

varIsColumnExists-boolean

Get lists - retrieve all lists

Apply to each - output from get lists

Inside apply to each:

http request (CheckColumn) uri: _api/web/lists/getbytitle('items('Apply_to_each')?['DisplayName'])')/fields?$filter=InternalName eq 'Owner' or InternalName eq 'Responsible' or InternalName eq 'Manager'

Condition: 
length(body('CheckColumn')?['d']?['results']) greater than 0
TRUE
http request (retrieve column) uri: _api/web/lists/getbytitle('items('Apply_to_each')?['DisplayName'])')/items?$select=Title,Owner/EMail,Responsible/EMail,Manager/EMail&$expand=Owner,Responsible,Manager
 
 
 
Once I retrieve the lists that has either of the column, next I need to check if that column has the value of varOldStaff.
If it does, retrieve and send the lists in email.
 
Appreciate everyones help.
 
Thanks.