With all my respect to you and your work, I would suggerst you add to the title something like "Favorite item" or "User Favorite" so that it is easier to find this video. Huge thanks for all your efforts!
Hi Shane, is it possible if i have a string -"peter,32,male,i like swimming" and i want to split it and put them into a collection with field columns- name, age, gender,hobby?
Hi Shane, i'm having problem in splitting sql table column. My data source is SQL table. In that i've acolumn "Location" which will have value like "Lousiville, KY". I want to show Location in dropdown filed and the value should show only "Lousiville". How can i do that?
Hey Shane, i built a super cool app with your help. Thanks for that. I now have the problem that I have to give everyone access rights to the data sources so that all employees can use this app. Unfortunately this is sensitive data. Maybe you had similar problems and an idea how to use the app without access rights? Love from Berlin Johanna
Shane I had a question for a possible video. I am building a skill matrix with skills in rows employees for columns and I want to make an app to assign score for each training. I was trying to make a two way lookup to find person and skill then write the score. Is it possible to have a two-way lookup this data set is in SharePoint and potentially huge. Right now I'm using the switch function which works with no flexibility to adjust when new hires are added. Thank you in advance
If I wanted to do this for multiple lists, would you recommend multiple user favorite lists for each one? Or could you use one favorite list with multiple columns, and each column references the user's favorites for that specific list?
Hello Shane, I have a question about saving forms, if I want to edit an existing SharePoint list entry in my powerapp but save it is a new entry how would I do that? (What i want is to save each version of a form so I can see them in my gallery and choose the version of that entry I want to use). Thank you for the videos, very helpful.
You could use Patch to create a copy and then edit the copy. Or you could use your form in New mode but set all of the fields to reference the original.
thank you for this video ^_^ I am asking if this split function is have features to select an index where to start in splitting? Something like Array Split. example. sample text : a,b,c,d,e,f,g,h,i in this sample text i need to regroup them in to 3. I want to split it the expected output below a,b,c d,e,f g,h,i
Hi Shane, First off your videos are great! My question is can the Gallery then be filtered by the Yellow Star? Building on this could a separate Gallery be made to filter the results of the first? Thanks for all of your help! Regards, Jethro
Hello, i have question. I need share information from list for external user (other organization). Something like site where users can see status (some columns). How can this be organized by means Sharepoint? Thx.
Nice. Maybe you have covered this already but I’m wondering how to do something similar to this but somehow flag new items at the user level and remove the flag after they have been read, I would want to flag new items for all users and allow each users to mark items as read, independent of the other users. So each user will be able to see what items are new that they have not yet read. I haven’t figured it out so in the meantime I have set up a dog ear flag that turns transparent over a 12 hour period. So this way users can see how fresh an item is based on the level of transparency of the dog ear. But It’s not as good as marking items as read at the user level.
Hi Shane, I was able to learn powerapps thanks to your videos. However i came across a problem and now at a standstill, hoping u can help me out. I built an app for our organization shared to multiple users. Its main function is to allow users to upload photos and and other users should b able to see the photos. The problem is, the source file is an excel file saved in onedrive. Once users upload an image, it will be patched to the 'Photo[image]' column in the excel file. It's working well on my my end and i can see the photos I myself uploaded, but other users cant. they only see a blank page. Tried to search ways/workaround for days now but still cant fix it. Hope you can help me with this.
Excellent video Shane! I had something similar working but this made it so much easier 😁 Will you be doing videos around Form Processor or Text Recognizer? I have explored the functions but I am sure you will make it easy for everyone to understand and use. Great content , Keep up the good work!
Your videos have helped me with PowerApps where Google searches and Microsoft Docs can't - much appreciated!
Glad to help. 😀 😎
Love watching all your videos! Only started with PowerApps last month and they've helped me loads :)
Awesome! Keep going 😀
This seems like a great way to do comments on a record instead of repeating table
That works for sure :)
With all my respect to you and your work, I would suggerst you add to the title something like "Favorite item" or "User Favorite" so that it is easier to find this video. Huge thanks for all your efforts!
Thanks for the idea!
Perfect timing. I will be doing favorite contacts in my app.
Nice!
I like the idea to use In and Split together. Is there any way to avoid a delegation issue with the In operator?
There is not. Sorry
Hi Shane, is it possible if i have a string -"peter,32,male,i like swimming" and i want to split it and put them into a collection with field columns- name, age, gender,hobby?
Not easily. Probably possible but I don’t have a quick suggestion 😐
Hi Shane, i'm having problem in splitting sql table column. My data source is SQL table. In that i've acolumn "Location" which will have value like "Lousiville, KY". I want to show Location in dropdown filed and the value should show only "Lousiville". How can i do that?
Hey Shane,
i built a super cool app with your help.
Thanks for that. I now have the problem that I have to give everyone access rights to the data sources so that all employees can use this app. Unfortunately this is sensitive data.
Maybe you had similar problems and an idea how to use the app without access rights?
Love from Berlin
Johanna
Try this ua-cam.com/video/NqQGysNCac0/v-deo.html for ideas
Shane I had a question for a possible video. I am building a skill matrix with skills in rows employees for columns and I want to make an app to assign score for each training. I was trying to make a two way lookup to find person and skill then write the score. Is it possible to have a two-way lookup this data set is in SharePoint and potentially huge. Right now I'm using the switch function which works with no flexibility to adjust when new hires are added. Thank you in advance
You can have an And in your Lookup formula to check two fields at once.
If I wanted to do this for multiple lists, would you recommend multiple user favorite lists for each one? Or could you use one favorite list with multiple columns, and each column references the user's favorites for that specific list?
In my head you could use one list and just have different columns for each type of favorite
Hello Shane, I have a question about saving forms, if I want to edit an existing SharePoint list entry in my powerapp but save it is a new entry how would I do that? (What i want is to save each version of a form so I can see them in my gallery and choose the version of that entry I want to use). Thank you for the videos, very helpful.
You could use Patch to create a copy and then edit the copy. Or you could use your form in New mode but set all of the fields to reference the original.
thank you for this video ^_^
I am asking if this split function is have features to select an index where to start in splitting? Something like Array Split.
example.
sample text : a,b,c,d,e,f,g,h,i
in this sample text i need to regroup them in to 3. I want to split it the
expected output below
a,b,c
d,e,f
g,h,i
Not that I know of. I think you split things into different rows then put them back together in groups of 3 but I haven't tried it.
Hi Shane,
First off your videos are great! My question is can the Gallery then be filtered by the Yellow Star? Building on this could a separate Gallery be made to filter the results of the first? Thanks for all of your help! Regards, Jethro
Yes you could filter on any field. Try this video for some ideas. ua-cam.com/video/0xZ4fMJbLvk/v-deo.html
Hello, i have question. I need share information from list for external user (other organization). Something like site where users can see status (some columns). How can this be organized by means Sharepoint? Thx.
SharePoint has external sharing built in.
Nice. Maybe you have covered this already but I’m wondering how to do something similar to this but somehow flag new items at the user level and remove the flag after they have been read, I would want to flag new items for all users and allow each users to mark items as read, independent of the other users. So each user will be able to see what items are new that they have not yet read. I haven’t figured it out so in the meantime I have set up a dog ear flag that turns transparent over a 12 hour period. So this way users can see how fresh an item is based on the level of transparency of the dog ear. But It’s not as good as marking items as read at the user level.
Can you make a video of a running total in PowerApps. Thanks Shane!
Look for my video on Sum. ua-cam.com/video/DF4KX1oSrV/v-deo.html
Hello Shane. How to Create loading spinners?
You are the PowerApps God :)
Thanks Frank. 😌
Hi Shane, I was able to learn powerapps thanks to your videos. However i came across a problem and now at a standstill, hoping u can help me out. I built an app for our organization shared to multiple users. Its main function is to allow users to upload photos and and other users should b able to see the photos. The problem is, the source file is an excel file saved in onedrive. Once users upload an image, it will be patched to the 'Photo[image]' column in the excel file. It's working well on my my end and i can see the photos I myself uploaded, but other users cant. they only see a blank page. Tried to search ways/workaround for days now but still cant fix it. Hope you can help me with this.
Have to share the excel file with them. You might Also run into locking issues. Excel isn’t a great datasource. Maybe try SharePoint instead
Excellent video Shane! I had something similar working but this made it so much easier 😁
Will you be doing videos around Form Processor or Text Recognizer? I have explored the functions but I am sure you will make it easy for everyone to understand and use. Great content , Keep up the good work!
I need to get back to those Vince. 😐
Shane, how to send e-mail with timer summary?
Use the OnTimerEnd property to send an email?
Gracias por la traducción en español,
Split functions no longer work in the modern canvas powerapps
It does, I just double checked. Split("1,2,3",",")