Look I'm not aware about CRM Grid. Just to answer your question, you can use different manipulation functions to show only active records. Like use Filter() function which only shows active accounts.
Hi Druvin Thanks for the nice presentation. It was so well explanatory and easy to understand. Question : 1. I am not able to past the gallery or edit form in the data card value. What could be the reason ? 2. I have created one form and whole submitting it there is an error. 3. Does the share point list also will update when we submit any leaves in the power apps ?
Dear Dhruvin, I faced the error in testing in my powerApp. I created item name and "choice" but this function is issuing "ThisItem.'Item Name' = this formula uses scope, which is not presently supported for evaluation." may i know how to resolve it?
Hi Dhruvin, Nice video and explanation, but I did not understand one thing here. What is the code you used it for Edit button, can we edit the record by clicking this button?, could you pls clarify it.
Thank you so much Dhruvin for the informative video. I am trying to add 50+ columns on gallery which should be editable like excel but unable to do. Can you please suggest how can we do that functionality.
* HELP * I am implementing the same functionality, as in this video -> Like I have a form control in Tab 1, & This grid view in Tab 2., Also, Both of them are Stored in separate Sharepoint lists, with the relation of MasterID. PROBLEM - Now what I want is to make the save as draft for this grid view, I already implemented save as draft for Tab 1 Form Control. I mean, Consider my user is Tired to type too much data, & he wants to continue from where he left off whenever he comes back. How I am Thinking -> is to save the data to the collection using grid view, & then patch it to SharePoint, & when ever user comes back, I will pull that particular data again to that collection, & read it, & repeat the cycle. But I am not sure, how to implement the same. PLEASE HELP
Hi Dhruvin, Its a great effort and your videos are really helpful. I just want to know how many list items will be visible in a gallery? If there are many items, will it automatically give page navigation function?
Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe
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 ) . How can I do this using powerapps? It would be great if you teach us this.
Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe Hi, I have a problem when displaying information with dates in a table or graph ... for example, I have the daily temperature data from 01/01 to 01/31 in my excel! but when i show it on my table. is one day early. showing from 02/01 to 01/02. Could you please tell me why
Hello. Thank you for your video. It really helped me. But there is a problem. In your video, we don't see the part when you insert the code to activate the Edit button. So can you show us the code please ? Thanks
Dhruvin great video. Can you advise how to insert columns from a different table in to this table in a single gallery ? Ex: In the same gallery I want to view columns from multiple tables in a grid like format
Hello sir, I am following step by step as per the video,but couldn't add header collection,what does that collection contain, How to proceed further, Can you try helping me out with this @dhruvin shah
Thank you Dhruvin for such a nice tutorial...
Most welcome 😊
Sir how can we add different fields of two sharepoint list in blank vertical gallery with the relation of EmployeeID
How to replace CRM Grid with this grid like I want to replace the active accounts grid with this grid and show on active accounts view oagr
Look I'm not aware about CRM Grid. Just to answer your question, you can use different manipulation functions to show only active records. Like use Filter() function which only shows active accounts.
Hi,how do u create collection for header? I'm getting error whenever I'm trying to do. Plz advise. Tq
Check 07:11 for this video. You will get the answer!
@@iamdhruvinshah Yes, I follow your steps as what u did in the video but I unable to do it because of the collection.
I am not getting Header Collection while adding data to custom gallery for data, how to get it?
Hi Dhruvin, I'd like to know how to get the RGBA numbers to change the fill template colours
Hi Dhruvin, I need edit the selected row by onselect property of Button, Can you make a video on this query?
I want to check galary alternate colour along with filtering and sorting
hi dhruvin, please explain what is x & y?as we can't understand the difference after setting the values. thank you!
I am trying to add a check box column that is present in SharePoint list but not showing when clicking label
Hi Druvin
Thanks for the nice presentation. It was so well explanatory and easy to understand.
Question :
1. I am not able to past the gallery or edit form in the data card value. What could be the reason ?
2. I have created one form and whole submitting it there is an error.
3. Does the share point list also will update when we submit any leaves in the power apps ?
Dear Dhruvin,
I faced the error in testing in my powerApp.
I created item name and "choice" but this function is issuing "ThisItem.'Item Name' = this formula uses scope, which is not presently supported for evaluation." may i know how to resolve it?
Awesome video. Nice explanation... Thanks for sharing :))
Could you suggest same functionality with sql server.
Could you please make a video how to add pagination..
i would like to understand that how you stored data source in sharepoint. do you have that video
Check episode in sequence
Hi.. please let me know how do we make this table responsive
Thanks! Will prepare separate video soon!
@@iamdhruvinshah thanks
@@iamdhruvinshah can you share the new video please?
Hi Dhruvin, Nice video and explanation, but I did not understand one thing here. What is the code you used it for Edit button, can we edit the record by clicking this button?, could you pls clarify it.
liked for best practice tip :)
Thanks!
iam not getting the manager value into sharepoint
Hi Dhruvin pls give me Edit button logic, i can't found in this video
Please upload a updated version of power apps
How to give access only to the person who has to approve the request through edit button? Please help me?
Thank you so much Dhruvin for the informative video. I am trying to add 50+ columns on gallery which should be editable like excel but unable to do. Can you please suggest how can we do that functionality.
Please help in homework if(thisitem.leavestatus.value = "Approve",palegreen,"white") what about rejection color ?
* HELP *
I am implementing the same functionality, as in this video -> Like I have a form control in Tab 1, & This grid view in Tab 2., Also, Both of them are Stored in separate Sharepoint lists, with the relation of MasterID.
PROBLEM - Now what I want is to make the save as draft for this grid view, I already implemented save as draft for Tab 1 Form Control.
I mean, Consider my user is Tired to type too much data, & he wants to continue from where he left off whenever he comes back.
How I am Thinking -> is to save the data to the collection using grid view, & then patch it to SharePoint,
& when ever user comes back, I will pull that particular data again to that collection, & read it, & repeat the cycle.
But I am not sure, how to implement the same.
PLEASE HELP
brother how can we add different fields of two sharepoint list in blank vertical gallery with the relation of EmployeeID
Hi how to do pagination in this form
Please share link if possible
Hi Dhruvin, Its a great effort and your videos are really helpful. I just want to know how many list items will be visible in a gallery? If there are many items, will it automatically give page navigation function?
Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe
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 ) . How can I do this using powerapps? It would be great if you teach us this.
Sir how can I add two if statements with one card
If I want to add a serial number to each row,how I can do that.
Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe
Hi, I have a problem when displaying information with dates in a table or graph ... for example, I have the daily temperature data from 01/01 to 01/31 in my excel! but when i show it on my table. is one day early. showing from 02/01 to 01/02. Could you please tell me why
This is related Timezone issue right?
Why are we only using vertical gallery, why not horizontal gallery?
Hello. Thank you for your video. It really helped me. But there is a problem. In your video, we don't see the part when you insert the code to activate the Edit button. So can you show us the code please ?
Thanks
Hi Dhruvin, Can you please send me the link to create grid view using data table ?
Dhruvin great video. Can you advise how to insert columns from a different table in to this table in a single gallery ? Ex: In the same gallery I want to view columns from multiple tables in a grid like format
if my data has a lot.and How can I implement horizontal scrolling，Thank you
No support for horizontal scroll for gallery at this moment
under gallery u can take collection that will solve the problem
Thank You
did not write code for edit button
He did in the previous video
Please make leave request screen for patch
Hello, you didn't edit the button
Patch function video I need bro
very helpful videos! Can you do a video on how to prepopulate the form with user info from AD?
tutorials are helpful but the visibility and your audio are not clear
You speak to fast and we have to push the video several times, otherwise we do not progress.
Hello sir, I am following step by step as per the video,but couldn't add header collection,what does that collection contain, How to proceed further, Can you try helping me out with this @dhruvin shah