Power Apps Edit Form 

That is AWESOME!! Fazil. Glad I could help

@@DanielChristian19 Have you done anything specifically for the education sector?

Hey Fazil, I have built a few apps for admin purposes. I also did a POC where teachers could write a test and students could take it. It kept track of how much time was taken for each question and gave a score at the end.

@@DanielChristian19 thanks - did you post videos on these?

I have not. I demoed them in a few sessions though

Glad it helped!

Thanks for the compliment, Jennifer and you are most welcome.

Thanks Prabhat!!

*Awww shucks* Thanks for the compliment Ramesh.

Thanks for the great compliment, Prasad!

Your welcome S S.

Thanks Mariano. This means alot coming from a Power Platform SME like you.

Awesome! Glad to hear that. Ha! Your sleep comment reminds of a statement somebody once made, "Power Apps! Building apps and taking naps!"

Glad it was helpful!

Glad it helped!

Thanks for the compliment, Rudi.

Glad it was helpful!

Hi Jani, Welcome to the Power Platform world and thanks for the compliment!

Awesome!

Glad it was helpful!

Your welcome. It's work the time and effort. Here are some links to free and helpful content for a beginner to pro level training. App in a day: aka.ms/appinaday Admin in a day: aka.ms/powerapps/admininaday Several free Power Apps in a Day workshops are available around the globe. Take a look to see which one is closes to ou. Here's a link to their dates and times aka.ms/AIADEvent. This is a great link to a site by the Microsoft Power Apps group that has several learning resources. powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/ Power BI Dashboard In A Day - powerbi.microsoft.com/en-us/diad/

My pleasure!

You are welcome, Dorothy. Keep Power Apping!

Thanks for the compliment Amina. Glad I can help.

Glad it was helpful!

Glad you enjoyed the video. I the demo I should have added a ClearCollect for the secondary image collection both at the View and the Add/Edit screen. This will solve that problem.

Hey KC, That is an AWESOME!! use-case for my next security blog 🙂. I already have a few ideas which I'll test first and then blog on it.

Glad it was helpful!

So can we use the same default property to the attachment control so that the same file gets saved here . Let’s say a scenario where the form mode is new and all the other fields are copied from other form as explained by you ! similarly the attachment control ( files ) must be copied . Tried the collection on add file property but didn’t work !! Any other trick please …

Hi Sanju, I've very glad to hear my videos are helping you. Your requirements are achievable and I've done a whole video on 'control level permissions using Office 365 groups' which will answer your first question. Here's the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d0Ra0qr29JM.html

@@DanielChristian19 thank you so much for the response, it's also one of the feature I was looking at, my way of putting question is wrong. I'm sorry for that. Challenge is I'm creating feedback from for learners who can select their role and select team name and can submit feedback to the questions in next page. Everyone showing this in two Button functionality for edit separate and new separate button and navigation through gallery. I need a code where it checks the selected options are already submitted if yes then populate the values else enable to participant to give feedback to the question in next page. I'm really sorry for making you misunderstood. I'm very much glad to get your help.

The SP out-of-box has the created, created by, modified and modified by columns. You can also turn on versioning to record how many times the files have been edit.

You are most welcome Jennear!

Thanks Utsana, For filtering/alphabetising you can using the Sort or SortBy function. Now, in a gallery you are presented with 100 items at a a time. Once you scroll down you will see the next 100. The success of the filter function depends on the data source and if it's delegable. For delegable data sources such as SharePoint, Dataverse & SQL your filter works at the source level. To update only a specific field and not all here is what I do- 1) Make sure no fields or columns are marked required at the data source. 2) When editing using Edit form or patch function, refer to only that field. Hope this helps and keep power apping!

@@DanielChristian19 Thank you very much for your help. I will give it a shot!

Your welcome and thanks for the compliment!

Yes, absolutely! Multiple apps for the same set of data sources. For viewing purpose only, consider using Power BI, it has some great visualization features in it. And you can add a Power Apps Canvas in it to do editing as well.

Hi Komal, Thanks for the compliment. I haven't worked with the AI form scanner feature yet but based on the demos I have seen you can save the scanned items in a collection. Hence I'd first add the collection to a gallery and take a look at all the columns. If any columns do give the red squiggly line then add them to a secondary gallery and see if the data shows up there. You'll have to do this again and again for a few columns and through the process of elimination you'll get it working. Hope this helps and keep Power Apping!

Hey Dale, You can make a data card invisible based on a condition. I usually use the If() for that. Select the entire data card and not the data card value and apply the condition. It will magically disappear 🙂

@@DanielChristian19 Thanks for the feedback, will give it a try!

Thanks for the compliment Amro. I haven't tested attachments in an Excel spreadsheet hence can't much there. CDS, SharePoint & SQL are the three main data sources I use to save data. I use Excel spreadsheets in OneDrive or SPO library primarily for POCs or if I'm only viewing data for controls such as Dropdown.

Problem solved, I manged to fix this!

You're welcome Aaron!

Safiya, They will see the default SharePoint list in the edit form.

@@DanielChristian19 ok thank you for the response , Daniel. I am trying to send edit link item to few users for security management and a customised edit form is required for that. With power apps I couldn’t figure out how to be able to only show the item to be edited to the user. Any ideas would greatly help

Yay! Good for your Bianca. I don't have any plans on recording a blog for approval flow. Here's what you can do. - Create an automated flow - Using SharePoint list's New Item as a trigger - Use the Approval action - You add email notifications if you wish. - In your SharePoint list add a status column to track the approval process. Hope this helps.

@@DanielChristian19 Super, Daniel! Keep up with the great work. Thanks for your response. Muh appreciated.

Glad it was helpful!

Hi Kumar, Yes you can. There is an Import and Export feature that comes with SQL Management Tools which will allow you that.

Your welcome BrianP.

Hey Bobby, Thanks for the compliment! Here is an example of the patch formula for People or Groups column RespondantName: { Claims: Concatenate( "i:0#.f|membership|", User().Email ), Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" }

@@DanielChristian19 Thank you so much for your response. I have been able to patch a People column as long as it contains one value...but if the People column allows multiple values, the above patch statement does not work. I've been looking for a way to do this but I have not been able to find it. I don't want to use a form and would really prefer Patch, but I'm stuck on this. My People values are coming from a combo-box in which the user inputs multiple names...so the Patch statement can't be hardcoded and must be able to read the input from the user via the combo-box.

Tushar, For filtering based on the user, the data source needs to have a column with the user's login ID or email address. Then you can filter the gallery using Filter(DataSourceName, UserID=User().Email) The data should get refreshed automatically after an entry has been made. You can try adding Refresh() in the OnSucess()

@@DanielChristian19 thank you for your reply.Actually when I am placing this filter on item property of the gallery Filter(DataSourceName, UserID=User().Email) my gallery does filter out but then when i edit one of the items in the gallery through edit form, the updated data is not reflecting on the gallery. I tried placing the Refresh() on the OnSuccess() property of the submit button but still my gallery does not show the changed data. But strangely when i remove the filter form the gallery and then try to update one of the elements in the gallery using edit form the gallery is showing the updated data. If you could you please share some solution to this.

Hi Alexander, Two galleries on the same screen to leverage a single edit form is possible. Do some trouble-shooting using a label and confirm you are using the OnSelect property for the gallery.

Hi Vivek, You can use the same SharePoint connector in several edit forms across multiple screens. Keep in mind that you will be submitting the data multiple times as well. My recommendation would be to first do all the app level saving in a collection and then do a one-time fine save using patch. Hope this helps!

Hi Srirangam, Take a look at Shane Young's video -> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2rfAQe1kK8M.html

Hey Maggie, Take a look at this section of the video and confirm you have similar settings in your app. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m0WSYJtqMFM.html

Hey Mgiusto, Confirm that when you are adding new entry you have selected the NewForm() function.

@@DanielChristian19 thanks for the reply, it's not actually a new record, it is to add data to an existing field of a record that's already in the database. I am filling my form with other values and this one field I want to allow the user to enter into and save their entry. Just nothing saves to the database.

Hey TaClesia, Use the NewForm, EditForm and SubmitForm in the correct places to avoid this issue. When entering new data use Defaults() in the item. For editing use a selected item from a gallery. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form

NJ, Confirm the form is displaying the selected item from your gallery.

Hi Amyrah, It should show up. Try removing that field and adding it back.

Hey Zero, Yes there is a way. Use the Set() in the OnSelect of the gallery. The formula will look something like Set(UserVar, Gallery.Selected.Item.xyz)

I figured it out by setting the form item to LookUp('ListName',EmailAddress = User().Email)

Hi Supriyo, There is a Contacts template already available which is similar to what you are looking for. Try that first.

@@DanielChristian19 Ok Sir can you please share the video link for the same

Hey Chipmunk, Yes to both using a control column. For filtering the gallery with the post edit item, you can use a control column or use the modified date column. If modified date No Equals created date means it has been modified later on and you can hide those from the gallery. For the lock, I use a control column and usually name it as status or something. What I do is by default set the value of that column item as lock or false. That way in the app it opens as lock or false. In the app do whatever you need to but make sure when the item is saved, the column value is set back to lock. Hope this helps.

Hey Eric, Yes there is. I use a gallery to select the item and then use that as the default of the Edit Form. You can then modify that selected column and submit

Hi M1cajah, Here is a link for some great self-paced learning resources. powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/

Syed, For what you are trying to achieve, have the data populated in a collection and then display that in the Edit form.

Thank you Daniel, issue is resolved with some other method. I fix form data source with SP List and in item I put lookup instead of gallery's selected.

Thanks Steven!

Thanks for the feedback. Audio is something I'm working and have purchased some accessories to enhance the experience. You'll notice significant improvements in my next video.

You and me both! Don't forget to subscribe to my RU-vid channel.

Okaaay, it it a cricket ball on the table to your left!!!!