cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nvrhughes
Frequent Visitor

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

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!!

1 ACCEPTED SOLUTION

Accepted Solutions

Turning off Asynchronous Pattern resolved the issue.

 

 

2019-10-17 10_24_27-PowerApps.png

View solution in original post

4 REPLIES 4
v-monli-msft
Community Support
Community Support

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Turning off Asynchronous Pattern resolved the issue.

 

 

2019-10-17 10_24_27-PowerApps.png

stapes
Impactful Individual
Impactful Individual

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

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

image.png

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,874)