Hi,
I'm trying to use the "Move rows from a Google Sheet to a SQL DB" template, but when I choose the fields from the spreasheet in the dynamic content, into the insert row, an error rises:
Solved! Go to Solution.
Hi mjsmartins,
Please try to start the flow from blank without using the template.
You could configure the flow with the trigger āRecurrenceā, then the action āGoogle sheet ā Get rowsā, then the action āSQL ā Insert rowā.
When you configure the action āInsert rowā with the dynamic content from the spreadsheet, an Apply to each will be added automatically and you wonāt get the error message.
Please try it on your side to see if it will work for you.
Best regards,
Mabel Mao
Hi mjsmartins,
Please try to start the flow from blank without using the template.
You could configure the flow with the trigger āRecurrenceā, then the action āGoogle sheet ā Get rowsā, then the action āSQL ā Insert rowā.
When you configure the action āInsert rowā with the dynamic content from the spreadsheet, an Apply to each will be added automatically and you wonāt get the error message.
Please try it on your side to see if it will work for you.
Best regards,
Mabel Mao
Hi Mabel,
IT worked! Thanks for the fast reply.
Using this template was a kind of desperate measure because of another more complex flow I'm working in, and had a similar problem. I'll try to solve the flow with this steps. if I can“t solved it, can I ask you help again?
Regards
MƔrio
Hi Mabel,
I just can't solve the problem with the real flow I'm working in. The flow seem's easy, it should take a Json from a REST service, parse it, and in the second level of that json take the project records and insert them into an SQL Server Database. Problem is that I can“t reach the project level to get the fields, or we I some how can, the error message is "
Can you help me?
is there any Other way besides create a Flow From blank/Mannualy, Because i have tried both, However, in every case i am not able to get the Data from the Google Sheets it Continuously throws error of Bad Gateway or Row Limit Exceedes etc
It would be really helpfull if you can Provide some Idea about solving these, I am really stucked into it from last 2 days and i am desperetly need this Functionality because there is no other way or approach that can Fullfill my Requirement.
Thanks in Advance
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
41 | |
37 | |
36 | |
22 |
User | Count |
---|---|
44 | |
37 | |
31 | |
28 | |
27 |