I want to use sql server to realize pagination. However, when i insert a SQL query, it doesn't give the 'ResultSets Table1' button to choose.So that i can't return the records i want to power apps.
I need to return array type data.If i choose 'ResultSet',it returns the JSON.It's not my need and I can't use the JSON in power apps.
What should i do ?
Go to Solution.
I found this thread that may have the solution that you're looking for:
If I have answered your question, please mark your post as Solved.If you like my response, please give it a Thumbs Up.
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.