PowerApps In and Split Functions

In this video, you will learn how to use the In and Split functions to mark items in a gallery as favorites. This is based on a client app we are currently building so very topical for me. :)

[snowcone]

Your videos have helped me with PowerApps where Google searches and Microsoft Docs can't - much appreciated!

[jbwise]

This seems like a great way to do comments on a record instead of repeating table

[Flaredesign]

Love watching all your videos! Only started with PowerApps last month and they've helped me loads :)

[RobFahndrich]

Perfect timing. I will be doing favorite contacts in my app.

[ivannaivanova]

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!

[vba]

I like the idea to use In and Split together. Is there any way to avoid a delegation issue with the In operator?

[jethrofriggens]

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

[bernardranola]

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

[vincephillips]

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!

[schwesterjohanna]

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

[chunheilee]

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?

[yms]

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?

[tonyy]

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?

[MrSpaceplay]

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.

[bearpawproduction]

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

[TheRemyRomano]

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.

[fibonacci]

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.

[hellsoul]

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.

[darkmar]

Hello Shane. How to Create loading spinners?

[magdialameen]

Can you make a video of a running total in PowerApps. Thanks Shane!