Connect a SharePoint List to Power Apps | Canvas Apps

This is a demo of how to connect a SharePoint List to a Canvas App
SharePoint:
How to create a new list, add columns, show/hide specific columns, and remove the required "Title" column
Canvas Apps:
Create a solution in Power Apps, create a new canvas app, add a form for the SharePoint list items, and a gallery list for the form responses.

[@jupiter792]

very simple, but just what I needed to learn how to connect SP List with PowerApps. Thanks.

[@guilleni]

Great video thank you so much for showing how to connect lists with a power app

[@paigebarrone4469]

thank you! very helpful for a first time power apps user :)

[@tradertube]

Very nice explanation. Much appreciated.

[@jwats98]

This was really helpful :)

[@rafaelapinillos6]

Great video!

[@phunguyen6856]

thank you for your video !!! help me a lot

[@pickgps]

You solved all of my problems!!!

[@davidm2143]

excellent demo, concise, clear and easy to follow. May I ask if you can connect the same list to different apps. Are there any limitations to using the same connector?

[@andreapinillos]

Yes, you can connect the same list to different apps.

[@jayashreevasudevan3641]

Amazing!

[@mayas1349]

Very helpful video! Is there a way to move the data source fields? I want to change my design a bit, but it seems the data source fields are stuck on one place. Can I not move them around individually? And second, how do I add a new data source that I newly added to my SharePoint list. Do I have to get all the data again?

[@andreapinillos]

Yes, you can use the blank gallery option and insert text inputs and move them around.

[@mahimabhimwani6032]

Amazing🤘🔥

[@aducaale328]

Thank you

[@ochiengkevin6701]

You saved a life

[@tuoyo6896]

Great video. Where does Power Automate comes in on this App?

[@andreapinillos]

Please watch my latest video to see how to connect power automate to power apps!

[@ahmadyamout6867]

Thank you so much as a newbie to powerapps. What is the difference between creating a project from the create tab and from the solutions ? In the labor market do they create the apps from the solutions tab ?

[@andreapinillos]

Creating tables within the solution will use your custom publisher and prefix for your project. It is best practice to create a solution for all of your project components.

[@ahmadyamout6867]

@@andreapinillos much appreciated 🙏

[@W.Wallace73]

Hello Andrea, Very helpful content. I need something similar, I have a form with a record gallery, but I just show records, with a criteria, I mean, I have a field called Month, so I want to show only the records were that field is equal with the current month. How can I do it? Also how can I include the apps in my Sharepoint Intranet? Thanks in advance

[@andreapinillos]

Yes you can filter by month. Check out my other video on sorting and filtering in a canvas app!

[@W.Wallace73]

@@andreapinillos Thanks for reply. I already did it...

[@financiallyfreegenz]

7:55 Default mode set to "New". Gave me headache for an hour why the form isn't showing. Problem solved. Thanks

[@delesewilson429]

Great video! So I need help. I'm trying to create a Phone app for the warehouse workers. It is a Personal Protective Equipment Request App or PPE App. I want to know if it's possible for the app to show a detail record of all the times requests were made by the employee, i.e.; showing date of requests made, date items requested were received, name of employee. Essentially, I want to be able to see a log of all the times each employee made a request by tapping on their names and this function should take me to the screen showing a log of all of the above information I listed earlier. I'm sorry for the long comment. Please respond as soon as possible. Would be very grateful for the help.

[@andreapinillos]

This can be done! Watch my previous videos on canvas apps to learn how to create fields similar to your requirements in dataverse or SharePoint and expose them in a canvas app. Just ensure you select phone instead of tablet when you first create your canvas app! Happy developing!

[@yt1hemani329]

if you add a column can you still connect that column to a new component in power app ? just for that new one ? or do we have to fetch the whole form each time ?

[@andreapinillos]

You should be able to refresh your power app and see that new column as an option to expose.

[@yt1hemani329]

Thank you for your reply@@andreapinillos I found another way. after adding a new column to the sharepoint list. In the power app click on the existing "form" element and click on the "edit field" next to "field" to add the newly added coulmn into the fieldsets.

[@hmj8469]

What if your Powerapp was going to have pre-populated data from a list, for instance a list of choices with each choice having a check box; and users could select one or more entries and click submit in the powerapp, and the submit button would update the same list with additional information? Is that possible?

[@andreapinillos]

I am trying to see if I am understanding correctly that you want the values in an option set field in a SharePoint list updated by a Power App? Or do you mean that the option set field is tied to a row and the user would be able to select an option from a power app and it sync back to SharePoint with their answer?

[@thelifeofjenelle6286]

Do you know how to add the time stamp that was present on power app to MS lists?

[@andreapinillos]

Sure - I will add this functionality to a future video.

[@prasanthnair143]

Nice

[@PastulioA]

i love the broken English (in a good way)

[@jeremytang2192]

What if I have 20 columns of items to insert in power app? I've tried only the first 3 column showed up

[@andreapinillos]

Try extending the gallery box, you’ll be able to see all of the items.

[@maheshs2125]

Hii andrea can you make one video on In form i have 4 tabs so how to navigate using javascript

[@andreapinillos]

Can you please provide more details?

[@delesewilson429]

How do you create a new publisher?

[@andreapinillos]

I'll create a video on how to create a new publisher but when you create a new solution, you will be given the option to create a new publisher.

[@jakubkozio2277]

Hello. As my first contact with powerapps I've tried to make this app twice and it looks like button doesn't send any data to the list. Nothing happens. What can be the problem?

[@andreapinillos]

Hello! Which button is not working? After you connect to the data source and add a gallery list, you’ll want to look at the right panel properties and ensure your table/data source is connected to your gallery list.

[@jakubkozio2277]

@@andreapinillos "post feedback" button. It does mit add data to the SP list. When I click on the Form there is source od data: feedback list do I think it's ok. Alsow when I manually added data to the list gallery does not show it after starting an app. Can there be any problem with connection between sharepiont and powerapp or something?

[@breadandcheese1880]

How do i display that power apps on the SharePoint list when user hits New?

[@andreapinillos]

Can you elaborate on this question please?

[@breadandcheese1880]

@@andreapinillos When the user selects "New Item" in the SharePoint list, We want the form built from PowerApps to render on the screen. The end user wants to view the submitted items in the regular list but wants to submit via a PowerApps form.

[@andreapinillos]

@@breadandcheese1880 I would embed the power app in SharePoint and create the “new button” in the power app.

[@breadandcheese1880]

@@andreapinillos yes, my question is geared more towards how to embed it and still allow users to view the traditional list.

[@wljf000]

Please move the mic away from the keyboard. The sound of the typing is very jarring. That said, great content!

[@nene1964]

You lost me at publisher. you really didn't explain that and just brushed it off

[@andreapinillos]

I'll create a video on this!