Flow failed: the data returned in the response is invalid??

[nvrhughes]

Hello,

We created a canvas app to update an existing record in sharepoint offline and online. 

I have been testing offline mode by pulling in data (online) into a collection.. Then using this collection to get the ID of the row i am about to update.

Once i have the ID and all my updated data, I add it to a new collection (SendData) which i store in an offline table.

Here is what happens on the Save button when updating a record within the app:

If(Not(Connection.Connected),
Collect(SendData,{ID: IssuesGallery.Selected.ID, Title: IssuesGallery.Selected.Title ,Status: Status_Radio_3.Selected.Value, Notes: TextInput1_3.Text}));

I then added logic to update the sharepoint list once the user opens the app online:

On Start of my App:

LoadData(SendData, "temporary2", true);
If(Not(IsEmpty(SendData.ID)),
ForAll(SendData,HomeReadyUpdate.Run(ID,Title,Status,Notes)));
Clear(SendData);
SaveData(SendData,"temporary2");


This is working as it should in sharepoint, but my OnStart logic is causing the following "error" to  display:

 Flow Failed: The data returned in the responce is invalid. 

Is there something i need to add OnStart or in my flow? Or is this a bug? Thank you!!

[v-monli-msft]

Hi @nvrhughes ,

This is because that the OnStart property would trigger every time the app is open, whether online or offline. But while you are in offline mode, HomeReadyUpdate.Run() cannot be triggered and that is what caused the error I think. 

Try to add an If condition to the formula in OnStart property to only run the Flow when Connection.Connected is connectd.

Regards,

Mona

[nvrhughes · Accepted solution]

Turning off Asynchronous Pattern resolved the issue.

[stapes]

Whereabouts do you get the chance to turn off Asynchronous Pattern?

[Murderbot]

@stapes Asynchronous pattern is in the settings of any power automate action.