Power Automate Run a Child Flow

Update the child flow for action ‘Run_a_Child_Flow’ to not use ‘run-only user’ connections.

Premise

This is the error I received, while calling a child MS Flow, from another MS Flow. This error was thrown while building the MS Flow. However, the following error was thrown from within a running MS Flow.

Failed to parse invoker connections from trigger ‘manual’ outputs. Exception: Could not find property ‘headers.X-MS-APIM-Tokens’ in the trigger outputs. Workflow has connection references ‘[“shared_office365”]’ with invoker runtime source.

Read More »

Query ListItems in Batches – SharePoint Online

CSOM 5000+ items get error

I have this application, in CSOM, which used to get the entire ListItems of a SharePoint List at one go to perform certain operations. All was well and good, until, I exported a brand new SharePoint List from Excel. The List had around 5400 items (>5000). When I tried to fetch all of its items, in the same way, I received the following error:

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

Read More »

SharePoint ListItems Group By

SharePoint Grouped ListItems

In the above screenshot, I have applied a GroupBy setting on a SharePoint View. I needed the same exact values in my application through JSOM. However, all of the online examples, that I came across, were of retrieving all the ListItems of a SharePoint List. You can either retrieve all the items at once or in batches, but there seems to be no provision of applying grouping or aggregation on the ListItems through code!

Somehow, I wasn’t convinced of this and was vehemently against this idea of pulling all the data on client-side first, thereafter applying grouping and aggregations.

Read More »