Unanswered

Trigger a flow once when multiple SP list items added

(0) Share

Report

Posted on by slockyer

I have a scenario where multiple rows in a SharePoint List are created at once and I would like to trigger a flow once, not per item added.

The user submits a request via a Canvas app which has the option to add multiple code deployment items to the request upon submission. Through another flow, these line items are all given the same request number.

I can easily grab all items based off their request number, but cannot figure out logic or method to have the flow only run once per submission.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

If the items are created at the same time you can use the When an Item is created trigger and turn off the Split On setting under Settings. That will trigger the flow and send an array of records that were created at the same time to the flow.

Was this reply helpful? Yes No
slockyer 20 on at

Like (0)

Report

I've disabled this setting as recommended, however, I'm now encountering an issue where my ODATA filter for my Get-Items is returning a 400.
This works perfectly fine when I re-enable Split On:
The input comes back as if it doesn't recognize the trigger output:
$filter": "RRF eq '' and Created ge '' (String was not recognized as a valid DateTime. Creating query failed.)

RRF is set to @{triggerBody()?['RRF']}, Created is set to @{triggerBody()?['Created']}

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Thats because the trigger now returns an array of items that are created at the same time. You'll need to change your code to use an apply to each loop to process that array of items. The triggerBody is no longer a single row so you can't use a value from it directly in a filter without a loop.

Was this reply helpful? Yes No
slockyer 20 on at

Like (0)

Report

Definitely could use some help in that regards, too. I'm not familiar with manipulating array data enough where I can get a specific value.

I did the apply to each using the output from the Trigger, and then a compose within that. I can reference Current Item, but how do I select a specific value (ex: RRF and Created) in that to use for my ODATA query? The current goal is to do a Get-Items from the output of the trigger, but only look at the newly created items.

Here's a truncated output from the Trigger;

"body": {
"value": [
{
"@odata.etag": "\"1\"",
"ItemInternalId": "39",
"ID": 39,
"RRF": 15,
"AssignedTo": [],
"AssignedTo@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
"AssignedTo#Claims": [],
"AssignedTo#Claims@odata.type": "#Collection(String)",
"Repo": "no date",
"Created": "2024-02-09T19:03:43Z",
{
"@odata.etag": "\"1\"",
"ItemInternalId": "40",
"ID": 40,
"RRF": 15,
"DeployDate": "2024-02-12",
"AssignedTo": [],
"AssignedTo@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
"AssignedTo#Claims": [],
"AssignedTo#Claims@odata.type": "#Collection(String)",
"Repo": "date 1",
"Created": "2024-02-09T19:03:42Z",

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Manually you can just add ?['fieldname'] to the JSON for current item. But you should have access to dynamic content for each field inside the loop.

Was this reply helpful? Yes No