This is really good. I am having a look at all your tutorials now. Straight to the point and you really walked me thru from beginning til the end. Please do more power automate and power apps innovations for beginners :)
@@KeaPointTechTips Hey :) its me again. Is it possible to collect a Image to a collection and patch it afterwards to a SharePoint-List? If so could you give me a hint how? Thx in advance ;)!
This is really a very good video. very good explanation. Just want to know like once we add data to collection how to clear single selected item rather than clearing all items.
Thanks for the video and I wanted add a validation with the Collect function to check if all the required data filled by the user. Can you help me on this pls?.
Hi, just started learning Powerapps couple of days ago, I'm wondering what data type should I use if I'm using column with multiple line text and column that contains people profile from sharepoint list?
Very helpful! Just wondering how would you do it if you there are multiple rows of data for the 3 columns you've shown. Also, can we club two collections together with completely different columns in both the collections?
Thank you for this wonderful explanation. Is there a way to copy data from clipboard inti collection? There are multiple users who will make data entry in bulk (both add and edit bulk rows) and I need to get all the changes into SharePoint list.
So my question is how do they access that power apps page in the first page. Right now i have a sharepoint list, and i want that user to access the page list of items in power apps but when you are on the sharepoint list, it doesnt lead me directly to the item but instead the list i created which is the screen. So it wouldnt make sense for me to click on an item in a sharepoint list, and then it would show me the list of items in the sharepoint list instead of the items itself. If that was resolved, then how would a user get access to the power apps list instead? Would they need a specific link to get to it?
Hi there, I'm receiving errors in columns that have Person or Groups data type. There are also errors in columns which I allowed multiple selections. Can you help me with this?
I took some ideas. Thank you! I am dealing with a 2-branch approval process, but I need to add to it, the ability to go back in each branch if one of them rejects the document and requests changes. Do you know how I can do that? It seems that the same solution can be done in both branches, so it can be considered as 1-branch approval process. Regards!
Hi Jose You can use Power automate switch control to create multiple approval branches and depending on the outcome, you can easily switch between the branches. This video of mine will give you some ideas on how you can implement it for document approval. ua-cam.com/video/Xe-nvaXekRw/v-deo.html
I tried and it worked, partially. When I'm adding the column values to the collection, it's showing the value in the table but in diagonal manner. For eg the first item title value is book. In my case, the color blue shows up diagonally and the date 15 02 shows up diagonally as well. Due to this, I'm able to add more values to collection but those don't show up
Just for an understanding, if we need to link the data to sharepoint -- without creating the connection in power app can we link it to sharepoint? If yes, could you please let me know the formula? If i use Patch i am getting error message.
You will have to connect SharePoint list to PowerApps before you can patch records to it. The question is why you don't want to connect list with the PowerApps?
In My List of SharePoint I am having a Primary field and some connected fields with other List. so can You please give me a idea how to connect that table?
@@KeaPointTechTips yes I am using that only. But in power apps for the ForAll function there are some errors. Like patch fucntion having invalid argument. Thank you for the reply
ForAll( ProjectUserCollection, Patch(ProjectUser, Defaults(ProjectUser ), {ProjectID: Project_ID, UserID: User_ID, RoleID: Role_ID, AssignmentStartDate: AssignmentStart_Date, IsActive: Is_Active, Title: Comments_IFAny})) this is my function but its giving errors.
You need to patch lookup Id and value for lookup columns. See this example. matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-lookup-column-in-power-apps/
@@olivaadak Hello Oliva, I got many errors while performing patching ie. this same step. How did you resolve these errors. Can you please reply and help me out on the same?
this is an awesome video is more helpful
Glad it was helpful to you!
This is really good. I am having a look at all your tutorials now. Straight to the point and you really walked me thru from beginning til the end. Please do more power automate and power apps innovations for beginners :)
Thanks for your kind feedback.
Your video answered by project requirements. Thank you!
Glad I could help!
Thank you so much for your great explanations and your great videos!!! They have really helped me 👍🏼
Thanks for your kind words.
@@KeaPointTechTips Hey :) its me again. Is it possible to collect a Image to a collection and patch it afterwards to a SharePoint-List? If so could you give me a hint how? Thx in advance ;)!
Awesome 😊
Thank you! Cheers!
Wow this is super and ideal for my immediate need. Thanks so much.
You are welcome, Steve!
Thank you man its all working🙃
This is really what I want to do on my app. Great! Thank you.
Glad it was helpful!
Awesome video!!!
Thanks for the visit
This is really good and easy.
Thanks.
This is really a very good video. very good explanation. Just want to know like once we add data to collection how to clear single selected item rather than clearing all items.
When you will select a different record, it will override the selection. You don't need to clear the selected record.
Very Very helpful video.
Glad it was helpful!
Hi, Thanks much this is sooper useful.
Glad it was helpful 😀
Thank you, great job
Thanks for watching!
Thanks for the video and I wanted add a validation with the Collect function to check if all the required data filled by the user. Can you help me on this pls?.
You probably need to do that while filling the data and disable save button if required info is not filled in. This will be more clean approach.
Hi, just started learning Powerapps couple of days ago, I'm wondering what data type should I use if I'm using column with multiple line text and column that contains people profile from sharepoint list?
Very helpful! Just wondering how would you do it if you there are multiple rows of data for the 3 columns you've shown. Also, can we club two collections together with completely different columns in both the collections?
Club two collections is possible but the data won't be normalised.
Thank you for this wonderful explanation. Is there a way to copy data from clipboard inti collection? There are multiple users who will make data entry in bulk (both add and edit bulk rows) and I need to get all the changes into SharePoint list.
You can use collection to temporarily store data and then can process the collection to SharePoint list
Good one... Can you help with this What if I want my user to delete the saved SharePoint record from Power apps
You can get SharePoint list record in a gallery view and can implement edit or delete button with logic easily.
A very helpful instruction :) Well done! How can I add photo and other file as attachments to the SharePoint list?
Glad it was helpful! Are you looking to save attachments to SharePoint list via the PowerApps?
@@KeaPointTechTips Yes, I am looking for exactly this solution (without using flow)
try this article
powerapps.microsoft.com/en-us/blog/add-attachments-to-sharepoint-lists/
So my question is how do they access that power apps page in the first page. Right now i have a sharepoint list, and i want that user to access the page list of items in power apps but when you are on the sharepoint list, it doesnt lead me directly to the item but instead the list i created which is the screen. So it wouldnt make sense for me to click on an item in a sharepoint list, and then it would show me the list of items in the sharepoint list instead of the items itself. If that was resolved, then how would a user get access to the power apps list instead? Would they need a specific link to get to it?
Hi there, I'm receiving errors in columns that have Person or Groups data type. There are also errors in columns which I allowed multiple selections. Can you help me with this?
I took some ideas. Thank you! I am dealing with a 2-branch approval process, but I need to add to it, the ability to go back in each branch if one of them rejects the document and requests changes. Do you know how I can do that? It seems that the same solution can be done in both branches, so it can be considered as 1-branch approval process. Regards!
Hi Jose
You can use Power automate switch control to create multiple approval branches and depending on the outcome, you can easily switch between the branches. This video of mine will give you some ideas on how you can implement it for document approval. ua-cam.com/video/Xe-nvaXekRw/v-deo.html
how can i make a button to create a collection? thx
I tried and it worked, partially. When I'm adding the column values to the collection, it's showing the value in the table but in diagonal manner. For eg the first item title value is book. In my case, the color blue shows up diagonally and the date 15 02 shows up diagonally as well. Due to this, I'm able to add more values to collection but those don't show up
Did you figure it out?
@@KeaPointTechTips I did manage to fix it eventually. Thanks!
The Patch function won't work for me. Showinng multiple errors in Power Apps..
Not sure why it is not working for you. Make sure you follow the steps.
Just for an understanding, if we need to link the data to sharepoint -- without creating the connection in power app can we link it to sharepoint? If yes, could you please let me know the formula? If i use Patch i am getting error message.
You will have to connect SharePoint list to PowerApps before you can patch records to it. The question is why you don't want to connect list with the PowerApps?
why my collection does not appear in data source list? i already search and its not working
That is strange, can you save and close the app and reopen it?
In My List of SharePoint I am having a Primary field and some connected fields with other List. so can You please give me a idea how to connect that table?
Hi Oliva, you can use lookup columns in SharePoint to connect tables (Lists).
@@KeaPointTechTips yes I am using that only. But in power apps for the ForAll function there are some errors. Like patch fucntion having invalid argument. Thank you for the reply
ForAll(
ProjectUserCollection, Patch(ProjectUser, Defaults(ProjectUser ), {ProjectID: Project_ID, UserID: User_ID, RoleID: Role_ID, AssignmentStartDate: AssignmentStart_Date, IsActive: Is_Active, Title: Comments_IFAny}))
this is my function but its giving errors.
You need to patch lookup Id and value for lookup columns. See this example. matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-lookup-column-in-power-apps/
@@olivaadak Hello Oliva, I got many errors while performing patching ie. this same step. How did you resolve these errors. Can you please reply and help me out on the same?