Re: Comparing Share point list ID values to a list (passed as parameter from Power App)
Hi @Laksh_05 ,
I also ran into the same problem. We cannot pass collections (arrays) to Flow. What we could do is pass it as a string, and build it back into an array in flow.
1. Use the following function in PowerApps to create a variable that contains all the ID's concatted in one string: Set(collectionToString,Concat(collection,Text(ID),";"))
2. Then in flow, use the initialize variable and use the expression: split(triggerBody()['text'],';')}
This will build an array (list) based on the separators (;).
3. Create an apply to each with the value being the array
4. create a compose with input 'current item'
5. create a get items with filter query being: ID eq '<current Item>'
The flow then gets a string '1;2;3;4;5'
will split it into an array
will check if for every id if is found in the sharepoint list.
Extra info:
ClearCollect(
collection,
{ID: 1},
{ID: 2},
{ID: 3},
{ID: 4},
{ID: 5}
);
Set(
collectionToString,
Concat(
collection,
Text(ID),
";"
)
)MyFlow.Run(collectionToString)
