Incomplete explanation 🤔🤔😔😔I came here to get an idea for the assigned to filter and you brushed it off....I have multi select ppl picker in SP and I want to filter in PowerApps using combo box. basically i want to apply the same filter functionality we have in SP . When you go to filter it does display the assigned users in the items and I'd pick myself and it only displays tasks assigned to me. Does your soln work for this requirement ?
How we can get the index dynamicly, in case that we have a combo box of 'N' elements? also how you do the shadow-box design bro?. By the way nice explained man
I don't have a better solution, so the number of selected values is limited to how many you provide. But normally 3-5 is more than sufficient. The "boxes" are html-Textfields with Concat() You can peek at the code here (german): czcams.com/video/TWYZib96rlo/video.html
Hi Robin, kannst du mal irgendwo zeigen, wie du diese unterschiedlich langen Pillen in der Tools-Spalte in der Galerie arrangierst? Das wäre mega, ich bekomme das einfach nicht hin.
Hi, tried using this solution but I am getting the error "the index function cannot be called with an empty table" - any ideas? The filter has nothing selected...and when I do select fewer values than the highest index it does not like it
I was getting the same error as you did and found a solution. Replace the IsBlank function with an IsBlankOrError function and make sure that this part of the statement is placed before the Index part of the statement so that it prevents the Index function from failing when the criteria is not met. In other words flip the statements to start like this: IsBlankOrError(Index(…SelectedItems,1)) Or Index(…SelectedItems,1) in …, etc
I have a german html video, where you can find a similar style. Here is the timestamp: czcams.com/video/TWYZib96rlo/video.htmlsi=54dKNuq694eBApKZ&t=962
@@R2Power went through the video you shared and got to know the idea you have implemented. But I need exact HTML text code you have used here for choice value. It would be helpful if you please text the code over here.
@@R2Power Hi, nein. Wäre es okay, wenn ich dich auf Telegram oder über andere Medien direkt kontaktieren kann? Ich habe ein Projekt von meinem Chef und dazu brauche ich genau deine Hilfe - ich bitte dich.
Delegation warning is not cool. It messes up your app in the long run. This is not a viable option for SharePoint list unfortunately because they cannot delegate the "in" filter.
![[PowerApps] Why YOU should start using ALL CONTAINERS (especially horizontal/vertical)](http://i.ytimg.com/vi/TH97xxP3aHs/mqdefault.jpg)
![[PowerApps] Why YOU should start using ALL CONTAINERS (especially horizontal/vertical)](/img/tr.png)
![[PowerApps QuickTips] I use this NESTED GALLERY in EVERY APP](http://i.ytimg.com/vi/6pf-9MQD-oM/mqdefault.jpg)
![[New in PowerApps] The new PDF() function is a gamechanger](http://i.ytimg.com/vi/qylQgT0dS0Y/mqdefault.jpg)
Well done Robin ! Also like your use of the HTML control
Thanks!
HTML+Concat() is such a powerful tool!
Tolle Idee, gut umgesetzt! Danke Robin!
Danke Peter!
Incomplete explanation 🤔🤔😔😔I came here to get an idea for the assigned to filter and you brushed it off....I have multi select ppl picker in SP and I want to filter in PowerApps using combo box. basically i want to apply the same filter functionality we have in SP . When you go to filter it does display the assigned users in the items and I'd pick myself and it only displays tasks assigned to me. Does your soln work for this requirement ?
How we can get the index dynamicly, in case that we have a combo box of 'N' elements? also how you do the shadow-box design bro?. By the way nice explained man
I don't have a better solution, so the number of selected values is limited to how many you provide. But normally 3-5 is more than sufficient.
The "boxes" are html-Textfields with Concat()
You can peek at the code here (german): czcams.com/video/TWYZib96rlo/video.html
In function is delgeable.
Showing Delegation warning.
Not in SharePoint
Hi Robin, kannst du mal irgendwo zeigen, wie du diese unterschiedlich langen Pillen in der Tools-Spalte in der Galerie arrangierst? Das wäre mega, ich bekomme das einfach nicht hin.
Hier in dem Video ist es das 3. Beispiel
czcams.com/video/TWYZib96rlo/video.html
@@R2Power Danke, das Video kenn ich natürlich. Ich wollte es gerne ohne HTML lösen. Trotzdem vielen Dank für die schnelle Rückmeldung.
Hi, tried using this solution but I am getting the error "the index function cannot be called with an empty table" - any ideas? The filter has nothing selected...and when I do select fewer values than the highest index it does not like it
Sorry, no idea without looking at the code directly
I've used the code in this video but obviously swapping out for my columns and combo box@@R2Power
@@MrOwenjames24 just opened my app in edit mode and it still works, so it seems to be on your side
I was getting the same error as you did and found a solution. Replace the IsBlank function with an IsBlankOrError function and make sure that this part of the statement is placed before the Index part of the statement so that it prevents the Index function from failing when the criteria is not met. In other words flip the statements to start like this: IsBlankOrError(Index(…SelectedItems,1)) Or Index(…SelectedItems,1) in …, etc
Hi Robin! Can you please share HTML text value here for Tools you have used in gallery?
I have a german html video, where you can find a similar style.
Here is the timestamp: czcams.com/video/TWYZib96rlo/video.htmlsi=54dKNuq694eBApKZ&t=962
@@R2Power went through the video you shared and got to know the idea you have implemented. But I need exact HTML text code you have used here for choice value. It would be helpful if you please text the code over here.
Hi, sehr gutes video. Kannst du mir bitte mal zeigen wie ich es mit Sharepoint verknüpfen kann und mit Filtern die Multiauswahl spalte filtern kann
das ist doch exakt was ich in dem Video zeige oder?
@@R2Power Hi, nein. Wäre es okay, wenn ich dich auf Telegram oder über andere Medien direkt kontaktieren kann? Ich habe ein Projekt von meinem Chef und dazu brauche ich genau deine Hilfe - ich bitte dich.
Delegation warning is not cool. It messes up your app in the long run. This is not a viable option for SharePoint list unfortunately because they cannot delegate the "in" filter.
it doesn't "mess" up your app.
It just doesn't work properly for >2000 rows, which are two completely different things