Awesome, very useful and much needed functionality, thank you so much. Can we do using container as well (container and all the controls inside the container)...?
Do you know how you could create this but the gallery only displays items which consist of all selected values. E.g., I have a column which is multiple selection and contains IT, Finance, Marketing on a single item. I select, IT, Finance, and Marketing in the filter - I only want to show items with all 3 values
How would you do it if for example Peter Parker works in multiple areas (more than 1 choice) in your sharepoint database. Would the filterprograming be different?
I get stuck after the first bit, once I have the image placeholder in place and I type in varBreadcrumbs my images don't show up. Any idea what I might be doing wrong?
Hi thanks for explaining in detail. However, I tried following steps as explained by you. But I'm facing issue I'm getting multiple emails. Say I have three entries on particular date. I'm receiving three emails with all three entries in each email.
Hello, Just awesome Could you helpme out please It seems when i press the minus it hides everything exept the first one? What do i wrong, i want the other data still visible With( {WMST: myData}; SortByColumns( Filter( WMST; ( Len("john doe") = 0 || "john doe" in CUSTOMER && TYPE = "PICKUP" && ADDED = Blank() ) && Or( frmSearchBox1 in Notes.Value && TYPE = "PICKUP" && ADDED = Blank(); frmSearchBox1 in DateText && TYPE = "PICKUP" && ADDED = Blank(); frmSearchBox1 in 'ITEM NAME' && TYPE = "PICKUP" && ADDED = Blank(); frmSearchBox1 in CUSTOMER && TYPE = "PICKUP" && ADDED = Blank() )&& If(CUSTOMER exactin colCollapsetExpandGroup.CUSTOMER And Not('Id (ID)' exactin colCollapsetExpandGroup.'Id (ID)'); false; true ) ); "Title"; If( SortOrder.Descending; SortOrder.Ascending ) ) Thank you
Hi Arslan, can we expand the same concept one level down? so we group under the sale rep and then under different projects/products he is selling? if Yes, can you share with me the code for expanding the items ?
Hi, im tryng to implemt the scroolbar, but when i go to the property X of the label and put the formula Label.X it say that its wrong, and in the property list from the label that open below a cant find that X property. Could u help me?
Hi Arslan, thank you for this video. However, I encountered an issue. Where my flow is triggering the mail every day and for all the items in the list regardless of the due date. I did exactly as you showed here. Can you help me with this please?
Nice Video. Thanks for posting. I do have an question I want to expand and shrink based on two columns say Sales Rep and Region. Assume Region is a date field. How to perform it. Any pointers I highly appreciate it.
Excellent! This and Part 1. Is there any way to calculate the height of a flexible height gallery? Or do I just have to overestimate it and put up with the extra white space at the bottom? Thank you.
until the data source is set to None form works fine in preview mode or able to preview the form, when connect to data source in sharepoint list. preview mode doesnt shows anything "No display"
Hi, this was useful, how about saving this data to sharepoint list? how you connect this for to sharepoint list.. I prepared this entire data, and when I connected to sharepoint list.. in preview mode nothing shows up.. also display mode is set to Edit.. there is no option of New. how we can save this data to sharepoint list? also how to sum up the amount in amount column?
what about when the reminder is for different people, how do you add them in the filter, so each one get an email just with the items assigned to them?
Hi Carolina, for this I recommend you add a sharepoint list of all the people to notify (if possible) and loop through the list, then get their items that you want to notify them on by adding another clause in the filter query of get items. Finally, you have their items, you can send an email with their table of items or skip sending an email if they have no items to be notified of. If it's too difficult to create a sharepoint list of these people (understandable because you may not want to maintain this haha), then pull the items you want to notify people of and use the logic in the video linked below to pull distinct people from that list (This will give you a list of users that should be notified. Note that you may want to enable pagination in the list items here to pull more items as you may not get a full list of users if too many items need to be notified on). Now you have the list of users you can do the above and take it from there! Get distinct users: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tp0jLnmKcEs.html
Really helpful. But,in my case, whenever applying Patch function on On select property of rejected button getting 'Record type' error. Please guide me what to do Sir