Build your first PowerApp - Very Basic Feedback Form and submit data to a SharePoint List

Подписаться 2,5 тыс.

Просмотров 57 тыс.

50% 1

Build your first PowerApp - Very Basic Feedback Form and submit data to a SharePoint List
Code Used:
SubmitForm(Form1);
ResetForm(Form1);
NewForm(Form1)
Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!
If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: wetechcareofyou.com/contact/
We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts:
✅Express VPN - Get a 30-Day Money Back Guarantee with our link.
A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider:
👉 click.linksynergy.com/fs-bin/...
✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage:
👉 click.linksynergy.com/fs-bin/...
✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint:
👉 click.linksynergy.com/fs-bin/...
*Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well.
Kind Regards,
The WeTechCareOfYou Team 💙
🧧🧧Watch our others Videos :
👀 4 ways to troubleshoot and fix Microsoft Teams issues, errors or dropouts
▶️ • 4 ways to troubleshoot...
👀 Trigger/Run a Power Automate flow by clicking a button in a PowerApp
▶️ • Trigger/Run a Power Au...
👀 PowerApps Invoice Generator which automatically creates PDF invoice - App Demo / Overview
▶️ • PowerApps Invoice Gene...
Related Tags :
Build your first PowerApp, Very Basic Feedback Form and submit data to a SharePoint List,powerapps, power apps, sharepoint, powerapps tutorial, Very Basic Feedback Form PowerApp, microsoft power apps, microsoft powerapps, microsoft powerapps tutorial, powerapps tutorial for beginners, very basic feedback form powerapp, WeTechCareOfYou PowerApp Tutorial, WeTechCareOfYou, learn powerapps, Very Basic Feedback Form, office 365, power automate, Feedback Form PowerApp

Хобби

Опубликовано:

2 июл 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 66

@xentiqxx Год назад

Bro you just made my life 10x easier. You're a great teacher, thanks a lot!

@WeTechCareOfYou Год назад

Hey Xentiqx, thankyou very much for the great comment! Happy that the video helped!

@chrischris711 9 месяцев назад

This was quick and helpful ! Easy to follow. You are an A+++ teacher.

@WeTechCareOfYou 9 месяцев назад

Hey chris chris thanks for the great comment! Happy it helped!

@sureshkrishnan83 Год назад

wow.. just what i was looking for .. easy to follow and clear instructions.. Thanks for your efforts.

@WeTechCareOfYou Год назад

Hey Suresh! Thankyou for the great comment! Happy that it helped!

@g1g1nmodi Год назад

Simply great , nicely explained with easy way

@WeTechCareOfYou Год назад

Hey ggagan thanks for the great comment! Happy that the video helped!

@ginevrakurow321 3 месяца назад

Easy to do and great instruction. Thanks, mate!

@WeTechCareOfYou 3 месяца назад

Hey thankyou for the great feedback! Happy it helped :D

@werewolf-666 Год назад

Thanks for this video mate! ❤

@WeTechCareOfYou Год назад

Thanks for the comment rajkumar! Appreciate it and happy it helped!

@ahmedarchambault260 Год назад

Your video helped a lot!!

@WeTechCareOfYou Год назад

Thankyou for the great comment Ahmed! Happy that it helped :D

@Elim_84 Год назад

Really good guide to help get started in PowerApps

@WeTechCareOfYou Год назад

Hey Andy! Thankyou for the great comment! Happy the video helped you!

@gg52409 8 месяцев назад

Thanks so much, this was really helpful

@WeTechCareOfYou 8 месяцев назад

Hey Guri! Thanks for the great comment! We are happy it helped :D

@nuh_93 10 месяцев назад

Thank you very much sir

@WeTechCareOfYou 10 месяцев назад

Hey nuh, thankyou for the comment and happy it helped!

@teixeira.antonio 2 месяца назад

Liked and subscribed. You deserve it

@WeTechCareOfYou 2 месяца назад

Hey thankyou for such a great comment! 👍 I hope it helped!

@daniellemartineau4065 8 месяцев назад

Tank you so much. This kind of worked for me. The text look up values worked, but I also had currencies I wanted to look up and those columns would not appear in my list unless I changed them to "number." Still, I'm better off than before.

@WeTechCareOfYou 8 месяцев назад

Hey Danielle, thankyou for the comment. Thats great to hear you got it working. We have a possible way to work with currencies if you check at 47:40 in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-b0bYXWiEzmo.htmlsi=cWCIkoRfXCM02iZT Best of luck!

@silex7 Год назад

Thank you! very simple. One question, how do you input the 'attachment cell' into the SharePoint list? I didn't see you set any column for the attachment in the SP list.

@WeTechCareOfYou Год назад

Hey Moataz, by default attachments are already available on a list its just not showing in your default view. You can disable/enable attachments in advanced settings in list settings. To show the attachments column on your view just select "Add Column" then select "Show or hide columns", here you can check to show the attachments column.

@silex7 Год назад

@@WeTechCareOfYou Thank you very much!

@WeTechCareOfYou Год назад

No problem Moataz i hope it helps!

@stevemcc4447 Год назад

Thanks. That was so clear. However...how does the app work for other users after the first entry?

@WeTechCareOfYou Год назад

Hey Steve, thankyou for the great comment. As we use the reset and new form you can keep submitting feedback forms. If another user opens the app it is a different sessions so they will be able to submit a form to the same list.

@deejay3818 5 месяцев назад

Thank you so much. Can you also tell me how do I share that form with the users of my organisation to fill up?

@WeTechCareOfYou 5 месяцев назад

Hey deejay thankyou for the comment. Yes certainly you can share with the following steps: 1. Navigate to: make.powerapps.com/ 2. Select Apps along the left panel 3. Find your app and select the ellipsis then select share 4. In the new window you can search for the members to share with, this will show members in your organisation. Adding a member will allow them to use the app, however there is also a checkbox named coowner which will give them edit rights to edit the app. 5. Select the ellipses again and select details to get the link to the app, you can share this link with your colleague and they can paste it into a browser

@allthingsnow3343 Год назад

Hey - great video worked great! Do you know a way that you can add a default name to save people having to re-enter when using the form based on the azure AD?

@WeTechCareOfYou Год назад

Hey All Things New, Thanks for the great comment. Yes, in the default property of the textinput you can use: User().FullName This will show the name of the current logged in user. You can also use User().Email

@allthingsnow3343 Год назад

@WeTechCareOfYou thank you so much! Worked perfectly

@MyLifeAsMaggie Год назад

Is there a way where users can edit a pasty entry? For example they already entered a project and wants to edit that part entry? Also if they want to submit multiple projects?

@WeTechCareOfYou Год назад

Hey Maggie! Thankyou fir the comment. Yes sure you can load a previous record into the form. If you select the form and on the top left change it to the "Item" property. Here you can lookup that record. Ie Lookup(SharePointListName, ID = 1) This will populate the fields with that data. If you want to submit multiple projects you will need further development for this and there are many ways it can be achieved. Can you explain more how you would like to submit multiple project? Maybe complete multiple forms and they store locally then press a final submit button? Or you want to have multiple forms on a screen?

@tinoz7573 8 месяцев назад

Great video! Is there a way of seeing on the sharepoint list who has submitted the form

@WeTechCareOfYou 8 месяцев назад

Hey tinoz, thankyou for the comment. Yes when you create a SharePoint list it will have autogenerated fields with it i.e created date, created by, modified date, modified by. You can simply add this column to your SharePoint listview and you will see who submitted the record

@jl-dq5ch 10 месяцев назад

this is not the way you are supposed to set these forms up. you should use the sharepoint integration method from inside ms list at top where says integrate. This will make a different type of app specifically for this function

@WeTechCareOfYou 9 месяцев назад

Hey jl, thankyou for your comment and we really appreciate the feedback. Yes by creating the app directly from the list, it is a great method to use also, however this defaults it to mobile view and to that specific list. With the method we have shown in the video it is for browser/tablets and allows you to use more than one SharePoint list.

@xursssulaxx 7 месяцев назад

once your data is being loaded into the sharepoint from the power app, can u use the path URL of the sharepoint to make a power bi dashboard? I want people to be able to enter in data using a power app, and then i want to take the data that is being entered and have it flow into a dashboard so that i can visualize it (i have a certain vision for it)

@WeTechCareOfYou 7 месяцев назад

Hey thankyou for the comment. Yes certainly you can have your Power Bi dashboard pointing at the SharePoint list (SharePoint list is your datasource). You do not need to have it connected to the PowerApp itself.

@J_Alrighty 2 месяца назад

I did this all, except my form had many more fields. The probelm is, the "Submit" button floats over the form, whereas I want it to stay at the bottom of the form. Any help you can provide on this?

@WeTechCareOfYou 2 месяца назад

Hey J Alrighty, Yes we have a video to fix this here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jjHaYFKKGLM.htmlsi=0IHgZyJyIrj5qWNd

@xyzphd122 10 месяцев назад

network error when using patch function, field title is required? even though I filled out my title field it still says that.. not sure why

@WeTechCareOfYou 10 месяцев назад

Hey xyzphd thanks for the comment. This might be a bug. You can recreate the list and reconnect however a quicker workaround is going to your list, select the cog on top right and go to list settings, scroll down and select the title field and select no on "require this column contains information". This will make the field not mandatory. Be sure to refresh your browser page with the app open so it pulls in the updated SharePoint settings.

@mageshwaras 4 месяца назад

Hi Its editing the created Item again and again after submitting the form, is there any possibilities to create a new Item after submitting the form, i need to get response from N number of user feedback

@WeTechCareOfYou 4 месяца назад

Hey mageshwaras, please send me the code you have in the "item" property of your form.

@mageshwaras 4 месяца назад

Hi @@WeTechCareOfYou Thanks for replying , Its working now , One doubt how to share this form to users as link? like a MS Form link

@faroltecnologico6928 10 месяцев назад

There is a possibility to fill a drop down list from an Excel file in Powerapps and send the selection to Sharepoint list?

@WeTechCareOfYou 9 месяцев назад

Hey faro, thankyou for the comment, yes you can certainly add an excel file as a datasource and pull data from that, however working with Excel in PowerApps is not a good solution. If you can explain more what you are trying to achieve maybe we can advise something better.

@EveryPart 5 месяцев назад

@@WeTechCareOfYoucare to elaborate on that? Specifically for data from a website, let’s say business names, with ID#s, a contact list page, address, etc?

@WeTechCareOfYou 5 месяцев назад

@@EveryPart hey EveryPart, do you mean pulling data directly from a website or do you mean if that data (business names, ids etc) was in excel format?

@bhavyasriboppana4758 7 месяцев назад

I am getting name column untitled, even though I entered a name

@WeTechCareOfYou 7 месяцев назад

Heu bhavya, please send a screenshot of your issue to admin@wetechcareofyou.com and i will take a look

@whowawoo Год назад

After save, publish, run it , it sits there at "Getting your data" never changes, can you help me with that?

@WeTechCareOfYou Год назад

Hey truth sayer, click your form, check on the right panel and make sure the default mode is set to "New form"

@emlearning Год назад

I keep getting an error "Network error when using Patch function: The requested operation is invalid." Any ideas?

@WeTechCareOfYou Год назад

Hey emlearning, we have a call scheduled tomorrow with a user with the same issue so I will fogure the fix tomorrow on that call. If you can please send an email to admin@wetechcareofyou.com amd we can send the info there

@WeTechCareOfYou Год назад

Hey emlearning, this issue will occur when you try to patch a lookup column or a calculated column, please check the SharePoint list columns you are trying to patch and check they are not calculated or lookup.

@user-gq6yj2it9k Год назад

How to send email on the submission to assignee?

@WeTechCareOfYou Год назад

Hey, thankyou for the comment. You will need to use Power Automate flow for this. You can create an "Automated flow" with the trigger being "When a new item is added" to SharePoint. Then in your next step you can use the send an email step. We have a video emailing a document in Power Automate flow here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fx2TcVEeGPU.html At 49 seconds in the video you will see where you select the "When a new item is added" for the trigger. At 2:25 in the video you will see how to send an email. Best of luck with the app!

@jray1429 10 месяцев назад

Why do you prefer to use flow to send emails instead of any other methods❓ Just curious because it seems like more work, but I might not be seeing things right

@jray1429 10 месяцев назад

Why do you prefer to use flow to send emails instead of any other methods❓ Just curious because it seems like more work, but I might not be seeing things right

@WeTechCareOfYou 10 месяцев назад

@@jray1429 Hey, there are many ways to achieve it however I like to use flow as it is is a clean out of the box way to do this by using the products within the Power Platform. Sending an email from flow is also easier to debug if there is an issue due to the nicer interface. This is just my preference :)