Hi,
I have a requirement which I'm struggling with.
Requirement:
Master list of account numbers (there will be thousands).
Filter a document library to see if the account number in the master list is contained within the folder name.
Once returned, delete the folder(s).
Current setup
Get file properties (using a filter query which only returns the folders - this works).
Get items (from the master list).
Append all the account numbers into a compose variable (so it's, 123456;22222; etc - this works).
Select function using the output from the get items - the key column here is called "Name". However, the account number from the master list will say "12345"; however, in the document library it will say "12345 FirstName LastName"; therefore, I need to split and only get anything before the space - this is the point which errors / doesn't work.
Filter array using the output from the Select function which says: @contains(@{outputs('Compose_-_account_number')},@{item()['Name']}) - compose_-_account_number is the concatenated values from the master list.
This works if compose_-_account_number shows in the correct string: i.e. 12345;252525;23456; however, I need to do the split earlier first.
Can anyone advice? Alternatively, is there a better way to solve my requirement?
Thanks,
Jamie

Report
All responses (
Answers (