I cannot thank you enough for this video. You saved me in a time of need. You have a clear and succinct style that makes it easier to understand. Thank you April!

@AprilDunnam

3 жыл бұрын

You are very welcome. Great to hear that my video was easy to understand and helpful!

Once again, I STAN your succinct and incredibly informative videos! Lol...The setting that "current user" variable tip is so helpful because we have a huge user-base and performance will be an issue. Keep that brilliance shining for us all!

@AprilDunnam

3 жыл бұрын

Thank you so much for the great feedback and support! I appreciate you ☺ Glad you picked up some tips to help performance!

Thank you April! After watching your video I realized I left a flaw in one of the forms I customized. I'm glad I was enlightened

@AprilDunnam

3 жыл бұрын

You are so welcome!

Hi April, One additional clear, straight to the point and very informative video. I love it and was able to finish the v2 of an app to report occupational health and safety risks. Thanks a lot!

@AprilDunnam

Жыл бұрын

So happy to hear this helped with your project!

Thank you April! This is what I needed!

@AprilDunnam

2 жыл бұрын

Glad it was helpful!

Thank you soo much for the help!

@AprilDunnam

Жыл бұрын

You're welcome!

Thanks April... Nice and very informative video... i love powerapps

@AprilDunnam

3 жыл бұрын

Glad it was helpful!

Thanks for such a useful video , Knowledge is the best tool a person can possess & its best donation also , In our country , knowledges is considered as a form of light .

@AprilDunnam

3 жыл бұрын

I love that, thanks Pavan ❤

Thank you April. Follow up question: Do you have an example on setting a Managed Metadata field from a parameter?

Thank you so much, April. You have explained the process of getting the current logged in user in a very clean and simple manner. This method worked like a charm in one of my lists but does not work in a second list in the same SP site. I get an error saying 'Invalid argument type(Table). Expecting a record value instead'. Both lists (and people columns) are exactly the same. any thoughts why the code works in the first list but not in the second ?

Great video, nice strat on the wall!

@AprilDunnam

3 жыл бұрын

Thanks! It was actually given to me by a not very well known country singer lol

@disturbedcarrot

3 жыл бұрын

@@AprilDunnam All the better, enjoy!

Thank for the video! Can we autofill a users manager and still keep the drop down? Any tips?

Great Content April! Quick question: I have two columns numerical data type. I want to have the third column in the gallery to immediately show the multiplication of the two columns prior to saving. How can i do that?

Thank you for excellent tutorial. Please do similar tutorial for creating cross site lookup field, thanks again

@AprilDunnam

3 жыл бұрын

Thanks for watching!

Hello Dunnam! I need guidance on using delegable functions to popularize a combo box. I need to extract data from a List Sharepoint, column ID2 (numeric), to fill a combobox, I am using this function: ClearCollect (arrID; Filter (Cadastro_Inspecao; ID2> = IDInicial && ID2

I'm trying to have a rich text field pull from the previous entry as the default value for the data card when creating a new form - is this possible?

Thank You April

@AprilDunnam

3 жыл бұрын

You're welcome!

Thanks April 🙏🙏🙏 😊

@AprilDunnam

Жыл бұрын

You're welcome!

Great tutorial, April. I tried to implement this method for a requirement but wasn't successful. I have two SharePoint lists and their columns are detailed below. List name: IDIODB Columns: ID = Text field SysAKA: Text field SysName: Text field List name: IDIORequestForm Columns: ID = LookUp field SysAKA = LookUp field SysName = LookUp field NewIDIO = Person field In IDIORequestForm list, If I select an ID, the corresponding values for SysAKA and SysName fields should auto-populated. Any assistance would be much appreciated.

Hi April, Thank you for this so pragmatic tuturial... as usual ;-) I would just have a "conceptual" question: You are working on the Default/DefauldDate/SlectedDefaults property of each component. and it's work ;-) But as we have a Card (as a container), why couldn't we directly update the Default property of the CARD ITSSELF . and continue to use Parent.Default inside the card. From my conceptual point of view, it would be cleaner . But I'm facing some issue I can figure out. For a choice column I will set Choice_DataCard1.Default = If( Parent.Mode = FormMode.New, {Value:"Default"}, ThisItem.Choice ) But for some reason, when I try to access Parent.Default.Value within a component of my card, it says that Value is not recognized. This is like the Parent.Record did'nt get a "correct" data definition type Did I miss something ?

I have a scenario where the User A fills 3 forms in 3 different screens and one of the field is a people picker field and its something like : Qa reviwer . once the details are filled all this data sits in SP list and trigger and email to the QA reviewer . The main thing comes here : QA reviewer needs to click the link and go to screen number 4 and 5 where he needs to perform his duties and should have only view access to entire record filled by the user . the 3 screen filled by user A should be view mode and screen 4 and 5 in edit . What i the best way to achieve this? how would i prepopulate the items from SP ? in powerapps ? please advice

Hi APril, Thanks for this video... How do you populate multiple users in that people field? Lets say you want to populate the field with 3 users instead of 1 as shown in your example.

Hi can we prepopulate the multiple people picker column

Hi, I had a question maybe you can solve it. If I have an excel file as the data source and I create an app. When the user adds his id he must be able to see only his data(specific fields, not all the fields say if I have 5 fields name, surname, id, course, class, and school. when the user inputs his id he would see only his name and surname ) a. How can I do this using powerapps? It would be great if you teach us this.

Hi April, great video thank you for sharing! I would like to default a field to be an employee's manager. How do I set the person/group field to be someone other than the current user, specifically a manager? Thank you!

@AprilDunnam

3 жыл бұрын

You can use the Office365 Users connector for that. There's an action call "GetManager" which you can pass in the email address of the user you want to get the manager for and it will return that data

I tried adding the form mode if and i'm not able to get the prepopulated person field to submit to the list. I'm using a SharePoint List Integration.

Excellent and brilliant

@AprilDunnam

2 жыл бұрын

Thank you so much 😀

@raghus8746

2 жыл бұрын

@@AprilDunnam hope u have recovered well and doing fine

Really appreciate April.. First thing is app layout... I'm using Tablet layout but I can not get like you it's coming very small area(content page) .. Where I can see your screen The layout itself is bigger and right side and left side there still space between properties tab and datacard tabs (1:36).. Can you help me how can I get such bigger layout.. reply please

how can i prepopulate date ,when the dropdown column status we change ( not started, in progress, Completed).. user will use same record every time for edititng?

Great Video April. Is it possible to this on a field that is not a dropdown list.

@AprilDunnam

3 жыл бұрын

Hi Des - Of course! I show setting the default value of a text field here: kzread.info/dash/bejne/aYWH0amPmJqbmbQ.html

How can i use text input control to automatic navigate to next screen when the value is correct. Example. Staff number is correct and same with your data source it will automatic open the next screen. Please help

Is it possible, while launching the PowerApp from Excel, to use a cell value from the Excel file to prepopulate a field(s) in the PowerApp?

New subscriber here, wonderful content! Question: say I have 2 data sources (d1 = PBIIntegration, d2 = List), what I want to do is > search / filter d1 >> select a record >> pre-populate it to a form > edit / submit form as a new record for d2. It's similar to your video, I got step 1~2 covered, but not sure about step 3 (prepopulate form), would you please kindly comment?

Thanks so much April as always! Is it possible to go straight to the form with pre-populate fields with one click? It seems like the url with parameter takes you to the home page of the app and the new form icon click takes you a pre-populated new form. I'm looking for a link that takes you to the new pre-populated form. Thank you :)

@AprilDunnam

3 жыл бұрын

Hey! Absolutely you can do that with deep linking to take you directly to that screen. I have a video that walks through that: kzread.info/dash/bejne/d46t2s6SpN3XhLQ.html

@akmz05

3 жыл бұрын

@@AprilDunnam Thank you so much as always!!! I'll look into it soon.

I see that they are all DataCards but one is set as DatePicker etc. Can you please let me know how do you change the property of a data card.

Thank You for the great video! How to Implement the same when source is SQL Server...how to create choices column in SQL?

@AprilDunnam

2 жыл бұрын

The process would be the same if the data source is SQL. SQL doesn't have a true choices column like SharePoint and Dataverse does. . You can restrict the options allowed in a column which the Check command in SQL like so. Gender VARCHAR(6) NOT NULL CHECK (Gender IN ('Male', 'Female'))

@madhurishirsat491

2 жыл бұрын

@@AprilDunnam Thank You!

Thanks for another informational video April. Please correct me if I am wrong here but the query string parsing inside Powerapp will work only if this Powerapp is run in browser. It won't work if I view Powerapp on a mobile device.

@AprilDunnam

3 жыл бұрын

Parameters should work on all platforms (Desktop, tablet, mobile)

@ashishdubey9245

3 жыл бұрын

Thanks April

Dear ma'ma I have a query. I have one share point list in this list I won't to set specific words base view For user group Unit's base view ( if it's possible how?)

I need that t-shirt.

@AprilDunnam

3 жыл бұрын

I snagged it at Microsoft Ignite last year 🙂

I set my Global Variable accordingly as you showed but still its not recognized when I call it (currentUser) in the Default section, Please Assist. Thank you. All in all everything else was clear and easy to understand

@AprilDunnam

3 жыл бұрын

Hi John, Unfortunately I don't always have the time to reply to comments and KZread isn't the best for these troubleshooting type scenarios. I suggest you post the question on the powerusers.microsoft.com site. There are experts on there answer questions all the time (I look and answer when I have time) and you can share screenshots, etc

cool stuff :D but what happens when i do this in EditForm ? Is it possible to do this in EditForm ?

@AprilDunnam

3 жыл бұрын

Yes you can do this same concept in an edit form

How to insert a table in the Description text field?

Is it possible to do the same on Model Driven App ?

@AprilDunnam

3 жыл бұрын

Not in the same way that I show here. This thread on the power users community talks through ways to do it in model driven: powerusers.microsoft.com/t5/Building-Power-Apps/Autopopulate-field-in-model-driven/td-p/550659

Is it possible to generate fields dynamically in Powerapps?

@AprilDunnam

3 жыл бұрын

Can you explain your use case?

@sowrimihiryss

3 жыл бұрын

Suppose i want to create survey form where answers will be multi select, single select etc. based on selection i want to get new questions from SharePoint list. I don’t want to create multiple screens since we really don’t know how many questions will be there. All i want to manage in single screen. Here i would like to generate new label control based on option selected. Any possibility?

@AprilDunnam

3 жыл бұрын

@@sowrimihiryss Ah ok yes that is possible. I've did that recently on a project. I can make a video about that next week.

@sowrimihiryss

3 жыл бұрын

April Dunnam even i did with single screen by utilising single label control. But not generated any controls on the fly. In your demo along with next question show how to navigate to previous question along with selected answer.

this was a great explanation, but totally useless to me. I need to set a default who is not the user. I want to be able to have the form fill in the name of the VP, who is sadly not me and not likely to be the person using the form.