How to pre-populate person field in PowerApps edit form for new record
HTML-код
- Опубликовано: 7 мар 2022
- I found a few videos that explain you the formula you need to write to pre-populate person field in PowerApps edit form, but where can we find that special format and not just for person field, but for other data types?
In this video you will see how to use PowerApps JSON function to extract data format from any database or control.
To enroll in my Udemy courses see below link for discount vouchers
sslwsh008.securedata.net/dotn...
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb 
Наука
This was a lifesaver. Thanks a lot!
Yet again, a blockbuster tutorial for his highness Alireza Aliabadi" , Bless his soul to keep is educated.
Brilliant video! You explain a completely foreign concept as simple as possible - I've learned a new thing today. THANK YOU!!!!
It's a bit old video. JSON is not a behavior function anymore. You can simply assign it to a Text Label and it shows you the JSON string.
This was a great learning video, THANK YOU VERY MUCH!
such a great video!! i was looking for this solutions. I have watched so many videos regarding this but the way you clarify the concept that's awesome. Not for this video for all of your video you describe very logical way.
Thanks for sharing this! Helped me a lot.
This is gold! 😀 Thanks you very much Alireza! Use this type of form in my Help Desk solution!
Tqvm Ali.. Great.. This is what I need as default value
Thank you so much for this video. I was stuck and it helped me out.
Really good video, always happy when there is voice clarity and concise here is the text for those copy paste folks
Table({Claims:"i:0#.f|membership|" & User().Email, Department:"", DisplayName: User().FullName, Email:User().Email, JobTitle:""})
Excellent tuto ! Many thanks
you are just great.
Great video and great way to present this concept.
Using this method, I am able to pre-populate the current username and the form is submitted too. But when I check the list, the username is not saved in the record. Any reason why this could be happening?
I am not creating a new form, only did a 'Customise Forms' option from an existing SharePoint list.
Thanks for this video.I've some issue for applying this for a reference record (n-1 relationship) on my Edit Form. the JSON fonction said it's not possible de serialise tables with property "_ownerid_value" which is polymorphic type . I don't figure out any solution. Any idea ? Thanks
Hi Alireza, Good to see all your useful videos however I'd wish to see any video on On Premise vs Cloud version application developments. Deprecated features in On Premise or not supportive features which are turn into something else in Cloud version. That could help us when we migrate or upgrade On Premise applications to Cloud. Hope you consider this request and come up with some video on it. Thanks and looking forward to hear.
I really don't want to spend time on On-premise products. The reality is that I ALWAYS advise against using any hybrid solution, considering Microsoft support model.
Brilliant. This video has solved a problem I have been struggling with for months, thank you so much. The only issue I have is that this works perfect for new records however what commands should be entered in DefaultSelectedItems to see the name already in existing records. I have tried an "If" statement together with Parent.Default but it doesn't work.
Remarkably I have just solved this. Parent.Default does not work in an If statement together with the Table ...... however when I use ThisItem. instead of Parent.Default it works perfectly. Your video has really helped me a lot.
I have multi person field. How can I preserve existing persons saved before in list item with current user claims and concatenate them in one table for updating SharePoint list item?
But when you edit item it's showing the same default value for different people picker values also.
Like Can I know how it works when I click on edit of a particular item. I think odata. Type is missing. But Thank you. I understood it clearly😄
What about if I want the default for 'dddd', 'wwww', 'mmmm' to be appeared as default value as well..
Can you elaborate on that? I don't understand the question.
@@AlirezaAliabadi let say I've ready a data card in form which is I need to specify (select) each .. for Days, Week and Month in my form. How I can with a single date selected can generate
automatically Days, Week and Month in the form submit .
Ps:And one more thing, till now I still can't solve an issue on Week item. My Week 01 start 3jan2022 but auto Week refer as Week 02, How I gonna minus 1 Week here.. Appreciate your help. I did ask in forum but no reply.
Hi Alireza, Thanks for this video, but it looks like you cheated your way through the main issue. What happened to the variable var_MyJSon? I thought you could have used the same variable to extract the name or email in the selected item from the dropdown. You cheated by using the current user--- User () to get the name. Lol!
I just used the variable to figure out the JSON format of the person data type. You don't really need it to set the default value. That is my typical back door to construct the JSON object that should match a built in JSON schema.
Ok, but if you don't mind, could you please teach how to extract the display name from the drop down that the Json generates.