Flow SQL Query Result into SharePoint List

(0) Share

Report

Posted on by randallg Microsoft Employee

Hey All!

I'm new to PowerAutomate. I've built a Flow to get data from a Form, take one of the answers and lookup some data in SQL, and then add the Form and SQL query data to a SharePoint List. Everything works except for getting the SQL Data added to the SharePoint form. The Query is working and returning a single answer field from a table as expected.

From other posts I see that Parse Json appears to be the way to go. but it just wont work.

First, there is no Dynamic output from sql to add as "Content" in the Parse json. So I used this:

any direction would be apreciated. I suspect getting just the one field back with a single answer is messing it up. But not where to go from here.

All responses (1)

Answers (0)

v-yujincui-msft on at

Like (0)

Report
Re: Flow SQL Query Result into SharePoint List

Hi @randallg ,

Could you please provide more details about your Flow?
Can you tell me what is the Input to the Parse Json Action? Is the schema of this Action written by you manually?

Maybe you could try to add a Compose Action in the previous step and use the Json function, then use the Outputs of Compose as the schema of the Parse Json Action.
json(outputs('Compose'))
Here is a link that might help you:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-contact-to-Outlook-from-PowerApps/td-p/1410241

Best Regards,
Charlie Choi