Power Platform Community Forum Thread Details

Hoping someone can advise, as this is driving me potty...

I am running a Power Automate flow from a Power App, to

query a SharePoint Site's "Site Pages" List using a "Send an HTTP Request to SharePoint" action; and
return the response to the App using the "Respond to a Power App of flow" for processing.

All standard stuff.

Understood, that this should probably be done using a graph request, but I'd very much like to stick with SharePoint API for now. ;-)

When a button is clicked in the App, the flow triggers correctly, runs correctly, and populates the "Respond to a Power App or flow" correctly.

If I click the button ten times, it will work maybe three times. The remainder of times, the App will hang for two to three minutes (the flow itself takes c. 406ms to 895ms), then return an empty collection. I have tried removing then re-adding the flow from the App, and also removing then re-adding the "Respond to a Power App" control. Given that the whole process does work, if only intermittently, and that the flow works 100% of the time, I am thinking that the issue is in the App, or in my script, rather than in the flow.

I have no issue querying SharePoint Sites with one or two Site Pages. Understood, that I can only retrieve the top 100 pages of any given Site. However, with a Site I'm currently testing, containing 43 pages, the App will sometimes work, and sometimes not.

Here is the script I use:

//  Collects Site Pages in the specified Site using an API call
//  Onscreen banner, to advise that the App is doing something
    Set(varWorkingOnIt, "Retrieving Site Pages for the specified Site using API... this may take a mo or two depending on the number of pages...");
//  Resets any variables and collections
    Set(varSitePages, Blank());
    Clear(colSitePages);
//  Sets the response of the flow in a variable
    If(
        IsBlankOrError(
        Set(varSitePages,
            SPAPIEndpointExplorer.Run(
            "https://TENANT.sharepoint.com/teams/" & varLookUpSite,                               //  Team Site Code
            "GET",                                                                                //  REST Method
            "_api/web/lists/GetByTitle('Site%20Pages')/items?$select=Title,ID,Created,Modified,CanvasContent1,FileLeafRef&$expand=Author&$select=Author/Id&$expand=Editor&$select=Editor/Id",                                                                                                        //  URI
            "{                                                                                  
                'accept': 'application/json;odata=nometadata',
                'content-type': 'application/json'
                
            }",                                                                                   //  http headers
            ""                                                                                    //  body if needed
            ).response
        )
    ),
//  If error, notifies the User
    Notify("Unable to collect Site Pages for the specified Site. Please try again. If symptoms persist, shoot the Developer.", NotificationType.Warning),
//  If no error, collects the variable values in a table
    Collect(
        colSitePages,
        ForAll(
            Table(ParseJSON(varSitePages).value),
                {
                    Content: Text(Value.CanvasContent1),
                    Created: Text(DateTimeValue(Text(Value.Created)), "[$-en-US]dd-mmm-yyyy, hh:mm am/pm"),
                    'Created By': Text(Value.Author.Id),
                    ID: Value(Value.ID),
                    Modified: Text(DateTimeValue(Text(Value.Modified)), "[$-en-US]dd-mmm-yyyy, hh:mm am/pm"),
                    'Modified By': Text(Value.Editor.Id),
                    Link: Text(Value.FileLeafRef),
                    Title: Text(Value.Title)
                }
            )
        );
//  Clears the banner
    Set(varWorkingOnIt, "");
//  Navigates to the screen for a gallery review of the collection
    Navigate('Review API Screen *')
    )

I think this is fairly solid.

Any suggestions will most gratefully received...?!

Categories:

Error handling

Thank you, 11manish, really appreciate the response, and the suggestion for the cause of the error, which does make perfect sense. :-)

The accumulated CanvasContent1 does return a very large amount of data, which I was hoping to parse - in one go - within the App (the flow I use is a generic one, which I use for a number of different types of API call, so doesn't permit selection and return of specific elements for specific calls to the App from within the flow).

I did find a workaround, which was to get a list of the IDs for every page in the Site, then to run a targeted, cumulative, request and Collect operation for each item()'s data, which is working, although it is not ideal! Again, I should probably start using Graph, and Graph's (easier?!) identification of webparts. It's the age-old problem of brain power vs. scripting options. Just wish I (or at least my brain!) was a good twenty years younger... ;-)

Thanks again for the response, and for providing the answer to the question.