How to pre-populate person field in PowerApps edit form for new record

Подписаться 15 тыс.

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

50% 1

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

Наука

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

7 мар 2022

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@iyengar007 2 года назад

Yet again, a blockbuster tutorial for his highness Alireza Aliabadi" , Bless his soul to keep is educated.

@sudarsana1234 2 года назад

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.

@MrsLaubie 6 месяцев назад

Brilliant video! You explain a completely foreign concept as simple as possible - I've learned a new thing today. THANK YOU!!!!

@AlirezaAliabadi 6 месяцев назад

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.

@arupswapna Месяц назад

This was a lifesaver. Thanks a lot!

@zenlasurfer Год назад

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:""})

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

This is gold! 😀 Thanks you very much Alireza! Use this type of form in my Help Desk solution!

@mariafelizpereira6080 Год назад

This was a great learning video, THANK YOU VERY MUCH!

@eduardoscaranari5262 Год назад

Thanks for sharing this! Helped me a lot.

@ritusaikia1721 Год назад

Thank you so much for this video. I was stuck and it helped me out.

@meetdenis82 Год назад

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.

@suhaimiabdazais 2 года назад

Tqvm Ali.. Great.. This is what I need as default value

@doud1158 Год назад

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

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

Excellent tuto ! Many thanks

@TheGoodMilkMan Год назад

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?

@venkatkommisetty 2 года назад

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.

@AlirezaAliabadi Год назад

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.

@MdHasnainr Год назад

you are just great.

@nigelmilner479 Год назад

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.

@nigelmilner479 Год назад

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.

@guggilamdivyasai3451 Год назад

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😄

@suhaimiabdazais 2 года назад

What about if I want the default for 'dddd', 'wwww', 'mmmm' to be appeared as default value as well..

@AlirezaAliabadi 2 года назад

Can you elaborate on that? I don't understand the question.

@suhaimiabdazais 2 года назад

@@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.

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

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!

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

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.

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

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.