Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get Sharepoint list items to Canvas app

Hey guys! I have a challenge. I really don't have an idea of how to do it. The challenge is that there will be a Sharepoint list that will contain a list of records. These records will be a set of questions. Now how do I get these questions from the Sharepoint list and load a Form in Canvas app with these questions that I've fetched from Sharepoint. (The questions are records in the Sharepoint list and not column names)


Accepted Solutions
Super User
Super User
Super User
Super User

hi @SarathBabu1050 a connection to SharePoint and the list will give you access to the list. adding a gallery control will allow you to see all the questions in your question column, assuming you have a column with all the questions in it.


Assuming you have a column with 10 questions in it, this is what it will look like




hope it helps,


Hey @rubin_boer , thank you for the idea. But the problem is I wanted to these questions in a form as I need text input for these questions. That is why I mentioned to load it in a Form in the question asked.
According to your suggestion, is it possible to load the gallery with textinputs and questions and later access these text input's value on a button click? If so how ?

Community Support
Community Support

Hi @SarathBabu1050,

Based on the issue that you mentioned, do you want to list fetched records in a Form?

Could you please share a bit more about your scenario?


Actually, the Gallery could display all the records from the SP list, however the Form could only display a single record at a time. If you want to edit the questions, you could select any one you want to edit from the Gallery and then the form will load the specific record.


As @rubin_boer mentioned, you could add a Gallery directly and set the Items property as your SP list name. Set the Text property of the Label as each column name using:



Best Regards,

Hi @v-qiaqi-msft ,

I get the fact that the records from Sharepoint list can be loaded into the Gallery as Items. The problem is that I need to capture the response to these questions from the sharepoint list.

The sharepoint list contains a set of questions, and these questions must be loaded into the canvas app. Now each of these questions require an answer to be provided from the canvas app. I dont know how I can do this functionality with the Gallery; Loading the questions into the Gallery Items label with ThisItem.QuestionName is not the problem, but capturing the answers to these individual questions is the problem.
So is there a way that I can load the Sharepoint list items into a Form so that an answer to each of the questions loaded, could be made in the form of a textInput or use the Gallery to achieve solution to the fore-mentioned problem.

Super User
Super User

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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