Solved: Get Rows Sql with Filter - Json error

Hutchy15 · ‎05-21-2020

I have a simple flow that uses data within a sharepoint list to filter data in a sql table.

Everytime I run the flow I get the following error: Http request failed: the content was not a valid JSON.

Can anyone help?

v-bacao-msft · ‎05-21-2020

Hi @Hutchy15 ,

Please try to add a single quote outside Taylan and try again.

Check this article and get more details about configuring Filter Query.

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

Best Regards,

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

View solution in original post

ChristianAbata · ‎05-21-2020

oh this is an API error my friend @Hutchy15 please try recreating your conection, I saw this week lots of API errors, if the error persist please consider to open a microsoft support case.

Did I answer your question? Please consider to Mark
my post as a solution! to guide others

Proud to be a Flownaut!

If you want you can follow me at www.christianabata.com

Quieres contenido en español? Síguenos en Power Automate LA

v-bacao-msft · ‎05-21-2020

Hi @Hutchy15 ,

Please try to add a single quote outside Taylan and try again.

Check this article and get more details about configuring Filter Query.

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

Best Regards,

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

View solution in original post

Get Rows Sql with Filter - Json error

Helpful resources

Global Power Platform Bootcamp

Power Platform Community Conference On Demand

Power Automate Community Blog