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.
