Thank you so much for the video! Your method is able to solve the issue I've been facing for days. I can't thank you enough for this. Please keep up the good work!
I have one doubt if possible please try to resolve How to update/copy list row data from one SharePoint to another by selecting the value in gallery as check box(check box is there ,if i check that item in gallery then only that item will update in another SharePoint)?
This is possible via PowerApps. You can use a collection to collect all the rows which need migrating to another SharePoint list. YOu can then Patch the whole collection to the new list
Hi Rashid, Thanks a lot for this video. However I have another question like here you are selecting the email address and according to that populating the fields but if you are logging in and without selecting the field and you need to get the logged in email I'd like in this video you are logged in by getting the email address and query the list and comparing the email and filtering and then display the Fields. Could you please suggest on that
Yes, you can. Instead of pulling value from dropdown, you can use the User().Email to get current user email and then on form load you can do the lookup instead of dropdown on change event.
@@KeaPointTechTips Hi Rashid, I have another question is while I am customizing the form in power apps and trying to auto populate the fields using SharePoint list by verifying the current logged in user i.e. User().Email how to proceed on that as there is no on load or on Start event available due to the SharePoint integration. The available actions for the create screen are Item, on failure,on success, on reset, visible, default mode ,data source
Thank you for the lesson. I have a question on for you. My auto-populate source is Department then from department it will populate the list of staffname. for the part Onchange, Set(xxxVar....) which one should i select?
Hello! This is great and helpful! May I ask you a question? I used your approach but when it is on EDITMODE, all the data fields that were auto-populated went missing? I need to re-select the dropdown again to make it visible.
Yes, you will need to collect the selected value of a column in current record and set it as default value of that column on edit form load. This example only explains new form scenario only.
Hello ,Thankyou Sir. The video was quite helpful. I have one question here. Here we use different controls instead of a form,right. And we set the items of the drop-down to the list and it's email as its value. So how do I make my drop-down as appear to be as blank when a user lands on the screen from other screen? Also, how to do validation of all these fields and display error messages if any ?
Thank you, I have a one question, i have used this functionality in my form but when i hit new form it shows the values i believe this is because of we are setting the variables in default, Any solution for this
@@keimomomon I was facing the exact the same issue. You can reset the value by using this on the control you use for form submission SubmitForm("yourFormName"); Set( "yourVarName", Blank() ); ResetForm("yourFormName") This will set the variable that we declared to blank thus resetting all of the input fields associated with it
Hi! Thank you for the advice, you helped me a lot! I still have a question for you. What if I wanted to have more than a few text inputs. If I was doing it like this, there's only a limited amount of text fields I can fit into one screen, and without using Gallery or Table (you are able to have as many records as you want on one screen and you can SCROLL down in that one screen to access the ones that are lower on the page), I can't see a way of putting more text fields into one screen. Is there a workaround? Is there maybe a way to put more text fields into that one screen and being able to scroll through them like I would be able if I used gallery? Thank you!
hello,Vedio is very Usefull ThankYou And also can u tell how to auto populate radio Buttons. For example based on Email radio button1-Employee Radio button2- Manager we need to select from the list based on email present in the list table
@@KeaPointTechTips Use the same column - "email" but instead of a drop down have the end user simply type the email into a text box. That is wha I think Kamoteng Lanot is looking for. I am also curious on the functions to do that.
You can actually do that the same way as the video instructed, but on your case, you just need to change ".Value" into ".Text" since it is now a text input box Set("yourVarName", LookUp('yourDataSource', "yourLookUpField" = DataCardValue.Text))
Hi Rashid. I have a specific doubt. Please help me clear it. Suppose there is a shared mailbox and I have access to it. There are different folders in that shared mailbox. I want to create a flow that triggers when a SharePoint file is modified and it sends the mail to a specific folder in the shared mailbox. Can we do it ? Sending it to a specific folder in the shared mailbox ?
How to auto fill based on two different variables example If I select ID and Name it should give me details in other columns also I have to have one option to fill in missing values
Buddy Thank you for the video. It was helpful. I have a question - after the values are auto populated using the above formula, as my field is a choice function, therefore I had to apply the function contactvar on the property default selected items. After the record is created and when I go to create a new form I see my earlier autopopulated fields. I have tried to use reset function on success to clear the values but it will not clear. Can you please help.
@@KeaPointTechTips Buddy, this function is already applied on the New Form, I just need to reset these values under selected items which was selected by me earlier as they reflect again when I create a new record on the form.Can you suggest any function to reset the contactvar selected items so that they don’t reflect again when I create a new record.
If you used a form in PowerApps you can submit your form using SubmitForm(Form1) and to reset it ResetForm(Form1). Field by field would be something like Reset(TextInput1).
@@terencealmeida4594 I was facing the exact the same issue. You can reset the value by using this on the control you use for form submission SubmitForm("yourFormName"); Set( "yourVarName", Blank() ); ResetForm("yourFormName") This will set the variable that we declared to blank thus resetting all of the input fields associated with it
Exactly what i was looking for, straight and simple, thanks.
Glad it was helpful.
Thank you so much for the video! Your method is able to solve the issue I've been facing for days. I can't thank you enough for this. Please keep up the good work!
Hi!!
Thanks for teaching me how to do this in PowerApps! I really enjoyed it!
All the best and keep like that!
You are welcome!
Thank you for posting this - really helped me today
Glad to hear that. You are welcome!
I've been looking for this! thanks Rashid!
You are Welcome Nakai :)
Dude you saved my ass at work with this tutorial hahahahaha 1000 Thanks for you!
Hahaha, thanks.
Amazing Video, thank you so much its been so helpful!
Glad it was helpful!
thank you so much, this video is very helpful, just one thing, i have to write "Value" instead of "Result"
Yes, you are right
So useful ! Thank you so much
Glad it was helpful!
Very helpful , thanks 👍
Glad it was helpful!
I have one doubt if possible please try to resolve
How to update/copy list row data from one SharePoint to another by selecting the value in gallery as check box(check box is there ,if i check that item in gallery then only that item will update in another SharePoint)?
It is possible by powerapps or it need power automate??
This is possible via PowerApps. You can use a collection to collect all the rows which need migrating to another SharePoint list. YOu can then Patch the whole collection to the new list
@@KeaPointTechTips thanks, it works 😊
Just what I wanted. Thank you so much. Can we also populate attachments present in sharepoint list?
Thanks & Yes we can populate attachments.
@@KeaPointTechTips could you please elaborate on how to achieve that?
Thank you So Much, Great Video
Glad it was helpful!
Very good tutorial. Thank you.
You are welcome!
Hi Rashid,
Thanks a lot for this video. However I have another question like here you are selecting the email address and according to that populating the fields but if you are logging in and without selecting the field and you need to get the logged in email I'd like in this video you are logged in by getting the email address and query the list and comparing the email and filtering and then display the Fields. Could you please suggest on that
Yes, you can. Instead of pulling value from dropdown, you can use the User().Email to get current user email and then on form load you can do the lookup instead of dropdown on change event.
@@KeaPointTechTips Hi Rashid, I have another question is while I am customizing the form in power apps and trying to auto populate the fields using SharePoint list by verifying the current logged in user i.e. User().Email how to proceed on that as there is no on load or on Start event available due to the SharePoint integration. The available actions for the create screen are Item, on failure,on success, on reset, visible, default mode ,data source
Thank you for the lesson. I have a question on for you. My auto-populate source is Department then from department it will populate the list of staffname. for the part Onchange, Set(xxxVar....) which one should i select?
Hello! This is great and helpful! May I ask you a question? I used your approach but when it is on EDITMODE, all the data fields that were auto-populated went missing? I need to re-select the dropdown again to make it visible.
Yes, you will need to collect the selected value of a column in current record and set it as default value of that column on edit form load. This example only explains new form scenario only.
Hi, is there anyway to search and type into either of the boxes? As I have a list with over 3000 data points? Thanks
Hi, I have made another video on how to make search box based on SharePoint list values, here is the link.
Great, really helpful👍
Thank you.
Hello ,Thankyou Sir. The video was quite helpful. I have one question here. Here we use different controls instead of a form,right. And we set the items of the drop-down to the list and it's email as its value. So how do I make my drop-down as appear to be as blank when a user lands on the screen from other screen? Also, how to do validation of all these fields and display error messages if any ?
Thank you. You can keep the dropdown empty in the case of new form. The validation need to be configured on "OnChange" event of the field.
Thank you for the video.. can I replace the table with office365 user
Thank you, I have a one question, i have used this functionality in my form but when i hit new form it shows the values i believe this is because of we are setting the variables in default, Any solution for this
Hi Anuja, you need to reset form fields on form load and also after form submission.
How did you do it resetting the values after submitting the form?
@@keimomomon I was facing the exact the same issue. You can reset the value by using this on the control you use for form submission
SubmitForm("yourFormName");
Set(
"yourVarName",
Blank()
);
ResetForm("yourFormName")
This will set the variable that we declared to blank thus resetting all of the input fields associated with it
Hi, is there a way to only show the email/name of the user logging in or submitting the form? Thank you!
Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
You are welcome!
Hi! Thank you for the advice, you helped me a lot!
I still have a question for you. What if I wanted to have more than a few text inputs. If I was doing it like this, there's only a limited amount of text fields I can fit into one screen, and without using Gallery or Table (you are able to have as many records as you want on one screen and you can SCROLL down in that one screen to access the ones that are lower on the page), I can't see a way of putting more text fields into one screen. Is there a workaround? Is there maybe a way to put more text fields into that one screen and being able to scroll through them like I would be able if I used gallery?
Thank you!
You can use table view with three columns layout to add more field horizontally /
What if I want the dropdown list to have emails of microsoft365 users list?
if we use number instead of drop down, EmailDDL.Value is this ryt?
What if instead of dropdown for email, if the user types in the email, what changes should we do?
Pass Textbox text to the query, instead of drop box selected item value
hello,Vedio is very Usefull ThankYou And also can u tell how to auto populate radio Buttons. For example based on Email radio button1-Employee Radio button2- Manager we need to select from the list based on email present in the list table
You will need to build an array and set it to the radio button choice property dynamically on form load.
Hi, please upload a video that shows how to auto populate other columns based on their names without dropdown, just a text input box
Hi, Are you after a specific column type or single line text columns only?
@@KeaPointTechTips Use the same column - "email" but instead of a drop down have the end user simply type the email into a text box. That is wha I think Kamoteng Lanot is looking for. I am also curious on the functions to do that.
You can actually do that the same way as the video instructed, but on your case, you just need to change ".Value" into ".Text" since it is now a text input box
Set("yourVarName", LookUp('yourDataSource', "yourLookUpField" = DataCardValue.Text))
many many thanks
Welcome!
How would I be able to sort the Email column by ascending order without messing up the autofill formulas?
use SortByColumn function
Hi Rashid. I have a specific doubt. Please help me clear it. Suppose there is a shared mailbox and I have access to it. There are different folders in that shared mailbox. I want to create a flow that triggers when a SharePoint file is modified and it sends the mail to a specific folder in the shared mailbox. Can we do it ? Sending it to a specific folder in the shared mailbox ?
By default the flow will be looking into the inbox folder unless you point it to a different one. I think it is possible.
How to auto fill based on two different variables example If I select ID and Name it should give me details in other columns also I have to have one option to fill in missing values
Yes, it is possible. I will see if I can pull a video on it sometime soon.
please Contactvar , what is this?
Buddy Thank you for the video. It was helpful. I have a question - after the values are auto populated using the above formula, as my field is a choice function, therefore I had to apply the function contactvar on the property default selected items. After the record is created and when I go to create a new form I see my earlier autopopulated fields. I have tried to use reset function on success to clear the values but it will not clear. Can you please help.
Can you create separate new and edit forms? that will make your life simple.
@@KeaPointTechTips Buddy, this function is already applied on the New Form, I just need to reset these values under selected items which was selected by me earlier as they reflect again when I create a new record on the form.Can you suggest any function to reset the contactvar selected items so that they don’t reflect again when I create a new record.
If you used a form in PowerApps you can submit your form using SubmitForm(Form1) and to reset it ResetForm(Form1). Field by field would be something like Reset(TextInput1).
@@terencealmeida4594 I was facing the exact the same issue. You can reset the value by using this on the control you use for form submission
SubmitForm("yourFormName");
Set(
"yourVarName",
Blank()
);
ResetForm("yourFormName")
This will set the variable that we declared to blank thus resetting all of the input fields associated with it
🙃🙃🙃I can't believe no one here has asked what the variable ContactVar is, where is this variable defined?
No, because you are the one setting its function
Tom cruise didin't answer my call...
You can create a CSV file in flows to store meta data in Azure Blobs