This is very helpful! Only one issue that comes up in my case when following your instructions at 06:45. In the Edit Form when choose "Item -> SelectedItem" it gives me an error message saying "Invalid Formula. Expected a value compatible with 'Data Source' "
@@iamdhruvinshah Thanks for your answer. Similar to your case, I pass the whole line item record from Gallery1 (Screen1) to an editable Form (Screen2), where the fields should be pre-populated.The Edit Button in Screen1 passes the SelectedItem and in Screen2 I reference with "SelectedItem". Yes, my Data Source is a sharepoint List and the columns have different data types (choices, single line of text, date, etc.).
hi dhruvin..good day!.....one quick question..i want to make the form disabled to the requester till it gets approved by the approver...i have to restrict the edit access to the requester..how can i do so?
Hi Dhruv, In "View my leave application" button, it is for the manager to approve or for the employee to edit his already submitted leaves? If it is employee, then it should not show the EDITABLE Status as it is Manager's right to approve. Am I understanding it somewhere wrong?
It is for Employee. You are right..That the approve n reject should not visible for employees. I m developing the app with full managers role.. so it's appearing there. Also on later part i explained about role .. from there you will get better idea.
But when you submitted the form for the fraction of time a message displayed that "NO ITEMS TO DISPLAY" and then it displayed the SUCCESS message and I think Client or tester may log this as a bug.Please help to avoid this message.
in the manager comments i have given leave approved after submiting the form when i again click on eddit in the manager comment section itis showing my message with html tags how to get only the message in that column
After using SelectItem property one error is given on leave application form. error is "you don't have permission to use this look up, server response leaves failed, something went wrong" Please tell me how to resolve this issue.?
Hi Dhruvin, I have a query i need to add related notes for the custom record which we are creating from canvas app, i am using datasourse as Dynamics CRM, Can you help me how we can achive this
Hi Dhruvin, your tutorials on PowerApps are unmatched. I am just learnig to use powerapps and I am overwhelmed by the trash that other people post as so called tutorials. I have a simple question for you. How can I make a data entry „rewuired“ only if the field is visible? Trank you so much for your stunning effort!
Step1: Replace the TextInput(The field where the "means the name of TextInput field ) Step4: Replace the Update filed of HtmlText by DataCardValue_.HtmlText; (again _ the updated name of HtmlText )
Hi, Dhruvin. Your tutorials really helpful. Thanks a lot. I am facing one issue. After clicking on "Edit" button,, the manager field is not prepopulating. What will be the reason?. It's working exactly like yours on new form.
Hi Dhruvin, Thank you for very good video but i really need one help, i am not able to find it, i want to approve by click Approve button , i want when click button whose name is "Approved", Leave Status change to Approved, meaning i want to change field status when click approve button
Hi , tks for your video, I wanted to ask you : I’m just having an issue when I’m trying to reset and save this changes on the edit form .. for eg I have a drop down which if i change the value , another drop down should be change and save as blank but it is keeping the same old value
For ex. I am having Name and Email as a column in data source initially and with thati had created a gallery,form edit and form display. After that if i add a new column City in the data source i need get that in form edit
Hi, @Dhruvin, and thank you for your excellent work. Everything went well except that when my form is loaded with the data stored in the variable, in the comments column of the manager, it adds Html code. Ok for that.
Thank you so much! Very well explained. Thank you!!!
nice druvin
Thanks
Nice Video Sir Very Help Full Thanks
Thanks Dhruvin, another great video!
Thank you Dhruvin
Hi Dhruvin, you explain very nicely, I have one question, how to create custom card in the black form and how to set its reference to sharepoint list.
This is very helpful! Only one issue that comes up in my case when following your instructions at 06:45. In the Edit Form when choose "Item -> SelectedItem" it gives me an error message saying "Invalid Formula. Expected a value compatible with 'Data Source' "
Are you passing the value from your Selected item from Gallery to Power Apps?
And did you use List as Data source in Gallery?
@@iamdhruvinshah Thanks for your answer. Similar to your case, I pass the whole line item record from Gallery1 (Screen1) to an editable Form (Screen2), where the fields should be pre-populated.The Edit Button in Screen1 passes the SelectedItem and in Screen2 I reference with "SelectedItem".
Yes, my Data Source is a sharepoint List and the columns have different data types (choices, single line of text, date, etc.).
Hey Dhruvin, instead of the context variable I added a global variable: Set(varSelectedItem,ThisItem). Now it seems to work!
@@lorenzneufeld9114 This should work with context variables as well. Do you have any context varaible with the same name?
Thanks for confirming.
Hi dhruvin,
how you copied the test collection value ?
hi dhruvin..good day!.....one quick question..i want to make the form disabled to the requester till it gets approved by the approver...i have to restrict the edit access to the requester..how can i do so?
1. Maintain one column for Approve/Reject.
2. If it is approved, make enable else disable
3. For Approver and Requestor, maintain SP Group for Roles
@@iamdhruvinshah thank you for the reply dhruvin
HI dhruvin...I'm not able to cut and paste form inside data card
Hi,
The date and No of days column values are not populating correctly. It's always showing the default date and 1 in no of days. Please check.
Hi Dhruv, In "View my leave application" button, it is for the manager to approve or for the employee to edit his already submitted leaves? If it is employee, then it should not show the EDITABLE Status as it is Manager's right to approve. Am I understanding it somewhere wrong?
It is for Employee.
You are right..That the approve n reject should not visible for employees.
I m developing the app with full managers role.. so it's appearing there.
Also on later part i explained about role .. from there you will get better idea.
But when you submitted the form for the fraction of time a message displayed that "NO ITEMS TO DISPLAY" and then it displayed the SUCCESS message and I think Client or tester may log this as a bug.Please help to avoid this message.
How we can pull add edit form in canvas datacard
in the manager comments i have given leave approved after submiting the form when i again click on eddit in the manager comment section itis showing my message with html tags how to get only the message in that column
After using SelectItem property one error is given on leave application form.
error is "you don't have permission to use this look up, server response leaves failed, something went wrong"
Please tell me how to resolve this issue.?
Hi I am unable to paste form in the data card1
Hi Dhruvin, I have a query i need to add related notes for the custom record which we are creating from canvas app, i am using datasourse as Dynamics CRM, Can you help me how we can achive this
Hi Dhruvin, your tutorials on PowerApps are unmatched. I am just learnig to use powerapps and I am overwhelmed by the trash that other people post as so called tutorials. I have a simple question for you. How can I make a data entry „rewuired“ only if the field is visible?
Trank you so much for your stunning effort!
In form there is isrequired property..For every field..
Apply your condition on that
@@iamdhruvinshah that did the trick. thanks for the hint!
Very well explained.
Does this convas app replace the sharepoint list form or the list form is still available
This will not replace your SharePoint list form. Canvas app is independent from list form
Hi dhruvin, I unable to move form or gallery under data card, pls help me
It's slightly changed
Add container and add form inside
Microsoft has updates on that part
@@iamdhruvinshah thanks so much for the reply. Ur videos r helpful.
Thanks for great videos! How to save as DRAFT when data source is SQL server.. ?
Thank you for the tutorials. I've completed everything and found that the Manager Comments saves and shows as "
try changing the field Specify the type of text to allow:
Plain text in sharepoint and try for manager comments field
Step1:
Replace the TextInput(The field where the "means the name of TextInput field )
Step4:
Replace the Update filed of HtmlText by DataCardValue_.HtmlText; (again _ the updated name of HtmlText )
Hi, Dhruvin. Your tutorials really helpful. Thanks a lot. I am facing one issue. After clicking on "Edit" button,, the manager field is not prepopulating. What will be the reason?. It's working exactly like yours on new form.
R u able to resolve this issue?
hi it is not populated the value in edit form
Hi Dhruvin, how can we edit the labels with in the form without calling the another Form
You just need to write conditional statement on Text property of label
Hi Dhruvin, Thank you for very good video but i really need one help, i am not able to find it,
i want to approve by click Approve button , i want when click button whose name is "Approved", Leave Status change to Approved, meaning i want to change field status when click approve button
Hii sir , pls crete a video on site development, by using content we parts
Hi , tks for your video, I wanted to ask you : I’m just having an issue when I’m trying to reset and save this changes on the edit form .. for eg I have a drop down which if i change the value , another drop down should be change and save as blank but it is keeping the same old value
If you are setting up with the vaiables, then you need to update the variable values as blank on reset event.
thanks for the videos dude. Could you pls put ur mic a little closer, your voice sounds low and sometimes difficult to hear
New videos are with improved quality.. this was recorded a year ago
How I Lock item when someone is editing
Hi Dhruvin, Thank you for sharing this. I am facing one issue - button On-select, I am not able to get "SelectedItem" property. Can you please help?
Did you select item from Gallery?
@@iamdhruvinshah same issue i am facing , while click on edit button 'No item to display{blank screen}' getting
Hi Dhruvin, Your videos were really helpful thank you so much and i m having doubt, Is that possible to create a dynamic form?
Dynamic form.. meaning?
@@iamdhruvinshah if l directly adding a column in data source need to get that in edit form dynamically is that possible?
For ex. I am having Name and Email as a column in data source initially and with thati had created a gallery,form edit and form display. After that if i add a new column City in the data source i need get that in form edit
If I can't access SharePoint then where can i store my data
1. SQL
2. Excel
3. Dataverse
This support more connectors. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list
why so many views, and so little likes.
I don't understand this
Are you able to give some training on power apps for me or us because my friends also there...if yes please can you give contact Details
You can send inquiry here
powerplatformtrainings.com/contact/
Hi dhruvin
Hello
Hi, @Dhruvin, and thank you for your excellent work. Everything went well except that when my form is loaded with the data stored in the variable, in the comments column of the manager, it adds Html code. Ok for that.