@@DeShonClark hello sir . I want to fetch second list date colomn data in my first list date colomn in power apps , but I used filters lookup etc nothing was helpful pls make vdo on it thnx. ?
Very helpul content. Is there a way to hardcode the condition instead of having onchange in another datacard? I want to exactly what you did, but people will always be the same. Filter function is only giving me records. Thanks in advance.
Hi Clark. Thanks for the amazing video. In my sharepoint list the title is not a unique value whereas the team is a unique value. Basically multiple title are there against each team name. What changes should I make for the formula to work.
If you have a different column that uniquely identifies the users, update that filter query with your specific column name and value...let me know if we need to jump on a screen share
Hi DeShon, Thanks for the video - very helpful!! When I used this technique on a PowerApps list form the filtered people picker field lost the search functionality (i.e. options for the people field were filtered, but the control now lost the text box to allow for searching the filtered options. Do you know is this an issue related specifically to powerapps SharePoint list forms? Thanks
Thanks for watching... here's the latest version on LinkedIn www.linkedin.com/feed/update/urn:li:activity:7146122658978381825?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7146122658978381825%29
@@DeShonClark Yes, I added Office365Users.DirectReportsV2("MANAGEREMAIL").value to the Items property of a dropdown and it gets me the list. Getting it back to a person field in SharePoint gets a little more complicated, what I settled with is adding a drop down with the list on top of the default one (effectively hiding it) and pointing the original one to the fields of what's selected in the one on top (between brackets, using Record format). Not sure if it's the more practical way of doing it, but it's the simpler one I found that works and avoids circular references. Any feedback is appreciated!
hi this is great. i was able to do the same on my multi select people picker that is coming from a sahrepoint config table for people. however , the i am getting error while saving the data back to sharepoint. Will you show how to patch( if it is an app) or update ( for customized sharepoint app) this multi select people column in sharepoint. TIA!
let me take a closer look and see if I can replicate this. It has been a while sense I filmed this video and since came-up with some more efficient patterns to solve for this...it actually may be time for an updated video around this topic.
This is amazing! Thank you! :) I’m guessing we can use the second list like a SP permission Group with multiple users defined for each group. For example, HR with HR folks, Finance with Finance folks. Then we can show/hide elements and sections in the app to those users (admins) based on their function. I can’t use Azure groups to do this unfortunately, that’s for IT staff and I’m on the business side. Any possibility of making a video on this as a part 2? That would be awesome 😅
Thank you for your comment! I'm glad you found the video helpful. Yes, you can definitely use the second list like an SP permission group with multiple users defined for each group. That's a great idea! As for your suggestion of making a video on showing/hiding elements and sections in the app based on user roles and functions, that sounds like a great topic for a part 2 video. I will definitely take that into consideration and try to create a video on that in the future. Thank you for the suggestion! Stay tuned for more videos.
Hello Deshon, Is it possible to create a people picker from a SharePoint list and not from the entire organisation directory. So if my SharePoint list has only 25 people than the people picker should show only those 25 only.
this should be a filter on the list of people mapped to the technology category. The best way (that's less error prone) is to use a collection for the drop-down, and when the category changes, ClearCollect that collection with the new list of users. Hopefully this makes sense.
Hi I am trying to achieve the similar result .But the formula to filter is throwing error. I have 2 SharePoint Lists. 1st SharePoint list has 'Assigned To' column that shows user from the whole AZ directory. The 2nd config SP list has title column and TeamMember column. In power app I have added two SP list. On the form, I have only Assigned to people picker Column. How can I filter this column to only show users where Title = 'ABC'. Many many thanks for such a useful content. I am using only one column on the form 'Assigned To' and I am hard coding the second list's Title value as "ABC" Assinged to, Item formula : ColInternalUser Assigne to , On change formula : Clear(ColInternalUser); ForAll(Filter('Internal teams', Title = "ABC"), ForAll(ThisRecord.'Internal User',Collect(ColInternalUser,ThisRecord))); My Assigned to drop down is still empty ?How can populate the data here without having the second column on the form ?
Sorry to hear...check out the 2024 version on LinkedIn www.linkedin.com/feed/update/urn:li:activity:7146122658978381825?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7146122658978381825%29
![How to Filter SharePoint items for current user in PowerApps - [Me]](http://i.ytimg.com/vi/hsElyAb4oe8/mqdefault.jpg)
Hi Deshon,
I've been stuck with this issue for months! Thank you for this!
With the help of this tutorial, I could create a customized list of staff as approvers and requesters for my form. Thanks a million!
Glad it helped! Thanks for watching!
This video saved me from hours of endless torment, thank you 🤠
glad it was helpful, yep, it is not clear at all that a 'special' format is needed for saving....trips a lot of people up on the first go.
This masterclass is a gem. You have helped me a lot. Thanks.
Great to hear! Thanks for watching!
Wohooo, that was what I was looking for. Genius. Thanks a lot, DeShon
Awesome! thanks Peter
Wow !! Great video DeShon. Thank you very much.
Glad you liked it!, thanks for watching John!
That is clever work DeShon, thank you for sharing.
Thank you Paulie... learning a lot from your channel as well
Perfect! Thanks!
A salve from Brazil :)
You're welcome! Thank you for watching!
Excellent way to explain forall and this record the same video! Congrats
Thank you Afonso! Thanks again for watching
Your video was help me to sort my long term issue
glad it helped! this was a tricky one and took me many cycles to find a decent pattern. Much needed technique to limit users in a "people picker"
Thank you this tip!
You're so welcome!
Sir, thank you very very much! I spent almost all day losing my sanity over this, was about to smash something.
Glad I could help!
Superb... Keep upload such power apps tricks ....
Thanks again for watching
@@DeShonClark hello sir . I want to fetch second list date colomn data in my first list date colomn in power apps , but I used filters lookup etc nothing was helpful pls make vdo on it thnx. ?
Very helpul content.
Is there a way to hardcode the condition instead of having onchange in another datacard? I want to exactly what you did, but people will always be the same. Filter function is only giving me records.
Thanks in advance.
Great question. Of the collection will always be the same, I would create the collection on app start ...and set it for each drop-down that needs it
Muchísimas gracias fue muy util! :)
Hi Clark.
Thanks for the amazing video.
In my sharepoint list the title is not a unique value whereas the team is a unique value. Basically multiple title are there against each team name. What changes should I make for the formula to work.
If you have a different column that uniquely identifies the users, update that filter query with your specific column name and value...let me know if we need to jump on a screen share
Awesome! Let´s goooooo!
Thank you so much Eduardo!!!
Works great! Thank you so much!
Hi DeShon, Thanks for the video - very helpful!! When I used this technique on a PowerApps list form the filtered people picker field lost the search functionality (i.e. options for the people field were filtered, but the control now lost the text box to allow for searching the filtered options. Do you know is this an issue related specifically to powerapps SharePoint list forms? Thanks
Thanks for watching... here's the latest version on LinkedIn
www.linkedin.com/feed/update/urn:li:activity:7146122658978381825?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7146122658978381825%29
Thanks, subscribed
This looks great! How can I do this with the Office365Users connection? For example, to get only people under a certain person in the dropdown.
hey Edwin, did you figure this out?
@@DeShonClark Yes, I added Office365Users.DirectReportsV2("MANAGEREMAIL").value to the Items property of a dropdown and it gets me the list. Getting it back to a person field in SharePoint gets a little more complicated, what I settled with is adding a drop down with the list on top of the default one (effectively hiding it) and pointing the original one to the fields of what's selected in the one on top (between brackets, using Record format).
Not sure if it's the more practical way of doing it, but it's the simpler one I found that works and avoids circular references.
Any feedback is appreciated!
hi this is great. i was able to do the same on my multi select people picker that is coming from a sahrepoint config table for people. however , the i am getting error while saving the data back to sharepoint. Will you show how to patch( if it is an app) or update ( for customized sharepoint app) this multi select people column in sharepoint. TIA!
let me take a closer look and see if I can replicate this. It has been a while sense I filmed this video and since came-up with some more efficient patterns to solve for this...it actually may be time for an updated video around this topic.
This is amazing! Thank you! :) I’m guessing we can use the second list like a SP permission Group with multiple users defined for each group. For example, HR with HR folks, Finance with Finance folks. Then we can show/hide elements and sections in the app to those users (admins) based on their function. I can’t use Azure groups to do this unfortunately, that’s for IT staff and I’m on the business side. Any possibility of making a video on this as a part 2? That would be awesome 😅
Thank you for your comment! I'm glad you found the video helpful. Yes, you can definitely use the second list like an SP permission group with multiple users defined for each group. That's a great idea!
As for your suggestion of making a video on showing/hiding elements and sections in the app based on user roles and functions, that sounds like a great topic for a part 2 video. I will definitely take that into consideration and try to create a video on that in the future. Thank you for the suggestion! Stay tuned for more videos.
Hello Deshon, Is it possible to create a people picker from a SharePoint list and not from the entire organisation directory. So if my SharePoint list has only 25 people than the people picker should show only those 25 only.
This is possible, though not straight forward...I'll shoot a video on the technique
Can you show dropdown displaying team names automatically without doing selection from 'AssignedTo' drop down during run time?
Yes, this would be the default collection set on the control
how to display that list of user automatically in that dropdown(AssignTo) when Technology is selected.
this should be a filter on the list of people mapped to the technology category. The best way (that's less error prone) is to use a collection for the drop-down, and when the category changes, ClearCollect that collection with the new list of users. Hopefully this makes sense.
You rock! Just subscribe your channel!
Thank you so much! I appreciate the support. Don't forget to hit the notification bell so you never miss a video. Have a great day!
Hi I am trying to achieve the similar result .But the formula to filter is throwing error. I have 2 SharePoint Lists. 1st SharePoint list has 'Assigned To' column that shows user from the whole AZ directory. The 2nd config SP list has title column and TeamMember column. In power app I have added two SP list. On the form, I have only Assigned to people picker Column. How can I filter this column to only show users where Title = 'ABC'. Many many thanks for such a useful content.
I am using only one column on the form 'Assigned To' and I am hard coding the second list's Title value as "ABC"
Assinged to, Item formula : ColInternalUser
Assigne to , On change formula :
Clear(ColInternalUser);
ForAll(Filter('Internal teams', Title = "ABC"),
ForAll(ThisRecord.'Internal User',Collect(ColInternalUser,ThisRecord)));
My Assigned to drop down is still empty ?How can populate the data here without having the second column on the form ?
God knows what I'm doing so wrong but I keep getting errors.
Sorry to hear...check out the 2024 version on LinkedIn
www.linkedin.com/feed/update/urn:li:activity:7146122658978381825?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7146122658978381825%29
are you God?
no, just his most trustworthy servant.