วีดีโอ

Life saver! That's all I have to say. Thank you so much.

Hi, Awesome video! Exactly what I was looking for. I do however have a small issue that you might be able to help with. I have followed all your steps and everything works fine, until the concat step. Power automate states that it's an invalid xpath function. My code is: xpath(outputs('ComposeXML'), concat('sum(//root//values[normalize-space(title)=', item(), ']/enterprise[number(.)=number(.)])')) the "[number(.)=number(-)]" is there because for some reason xpath wont sum unless I define the number as that. The number is a float, so that might be the culprit but I'm not sure. Do you have any advice on how to fix this?

This is great, thank you

Hi, great content... I have similar use, but where I need to show Types or SubTypes from Column5 related and other columns on top in the same (one column) with corresponding numerical fields. I was able to achieve this till column5 using xpath expression as part of json structure, but struggling a lot to get the child values of/from Column5. Name Sales Profit Column1 500 200 Column2 500 200 Column3 500 200 Column4 500 200 Column5 500 200 Type1 200 50 Type2 100 50 Subtype1 100 50 Type3 200 100 Subtype1 100 50 Subtype2 100 50 Any suggestions or help...Thanks in advance.

Idk why, but my SharePoint has totally different layout from yours, none of the parameters are on the same page as you showed here, maybe its an update or im doing something wrong.

been using document sets for 10 years now

What about Power Apps?

I'm trying to apply this to my site pages.. but I can't seem to get it to work..

Sean that is a great video. But, can I use this method without having a Power Apps Premium license (Prod Environment)?

Hi, great content.. I have similar use where I am getting data in Power BI and want to export it to excel using Power Automate button, but here is a point.. I have total around 7-8 categorical or text fields/columns, which are dynamic based on field parameter so I mean sometimes user may select 4 or sometimes 5 or sometimes 8 so all these fields should be group by and come in first column/one column with hierarchical structure like: Name Value Column1 100 Column2 100 Column3 100 Column4 100 Column5 100 Type1 50 Subtype1 20 Subtype1 30 Type2 50 Subtype1 15 Subtype2 35 Till Column5 I was able to achieve using xpath using structure (using variable), but from Type1 I got stuck. Type1 or Type2 are dynamic, sometimes there will be 2 Types or sometimes 10 Types so it should be dynamic. Could you please provide an video and any suggestions sooner will be helpful as I am working on real scenario, but got stuck. Thanks in advance. I have subscribed to your channel :)

Great video, I’m going to try it out later. Could you please send the link to the Group By with 1 ‘Apply to Each’ please?

And make sure that the Doc Set fields are created as site columns, NOT as list columns ( unless you can guarantee that you NEVER will have to use those fields for search)

This is the first time I'm hearing about Doc Sets. Thank you.

I'd love to use Managed Metadata in a List, but cannot figure out how to manipulate it through Power Automate. Request if there is a better solution than 'Send an HTTP request to SharePoint', which I believe has been deprecated by my company's M-365 contract. If not, request what function resides in the purple 'fx: body(...)' box.

Jesus. The chances of an average user being able to get their head around any of this is roughly zero. What an absolute mess of a system it is.

Hey, where i can find the multiplexing video?

Such a good video. very clear.

Looks from the example on the screen that it doesn't work for the current month either? Someone born 10/24/1989 isn't 35 for another fortnight.

Hi, just a few question: If the objects stays in the environment if you delete unmanaged solution (example: solution1 version 1.0.0.10). Then for example, you have a copy of solution1 version 1.0.0.5, THEN, imported it to the same environment and it contains Send Email Flow with 3 actions but the current Send Email Flow in the environment contains 5 actions, does it overwrite the existing flow and make it 3 actions now? Thank you.

Wait this just help me to help another Fortune 500 😂

We always first ask what the use case for the library is. If there’s no need for metadata then we give them a document library and tell them to use no more than 3 levels when using folders. In the other case we could advice document sets but they tend to find it hard to work with. Also, even document sets you could hit the limit for the number of characters for the filename. In that case, activate the document id feature on site collection level. That’ll find the document through its id. Even after moving it to another location it will find it.

Flow running successfully But not creating record in the table. Can you please help what would be the issue? Thanks in advance.

Dude how have I not found your channel sooner? I love the other guys too like Shayne, Daniel, Lisa, Reza etc but also really love how you explain everything and I can tell you use this stuff yourself. Subbed

awesome. this is what i have been looking for, avoiding apply to each.

Thanks for this! Would it be possible to do one for Dataverse bulk delete using POST and asyncoperations? Or a better way if you find one.

I have to ask... looking at all this, it knows my server... HOW does it know the table I'm adding it to? the guid() is a general id... not specific to a particular table... so, were is the table identified? as well, my dataverse submission looks TOTALLY different. It is using pluralized "table names" instead of a long integer/string combination...

Great video! Very helpful. I didn't see the link to the App Registration how-to video that you mentioned, but I muddled through.

Buy if you want to surface a managed metadata column in a canvas app, then there doesn't seem to be any control for that.

So love this channel… “I’m not your guy…” 😂

I’m only 90 seconds into this and I love this stuff. As useful as it is funny. Office gangster!

Could you please prepare a Video on Security Group and O365 Group

Really Very Nice And helping to gain more Knowledge

Thank you! I've been trying to figure out what managed metadata list were for years! Great simple explanation.

hey, where is this video about service accounts?

Never seen such failure for a video. YOu might as well take this video down, this is no longer correct or working. You have 4.5k views for something that doesnt work and cant be implemented. smh. Helped me get a free outlook account though. Thanks.

"Thank you for joining. You don't current qualify for a Microsoft 365 Developer Program sandbox subscription." What the fudge....it said I wasn't qualified? // Update: 1 comment says read pinned comment. Ok. After Update: So....this video is incorrect, and wrong. You can no longer(even 7 months later) create a free developer account?

Way too fast and too many click throughs for a newbie, but good to know there's so much functionality to explore. My org treats SharePoint content as though it were the traditional MS file organization structure: folders > subfolders > files. We're missing a lot of goodies.

love it! just started a new app and going to implement this!!

If I have many lists, how could I automate the process of changing them one by one when we deploy?

Great one, Sean. I was actually looking for this kind of solution as we got people, manually changing sites and list after deployment.

love it, shame in my job, we only have 1 enviroment :D

Can Doc Sets be opened through file explorer (sync or Shortcut in Onedrive)? Most of our folks insist on using this.

Super cool! Thanks

This is awesome. Than you!!

But you still use hardcoded secret of the application user to access the Azure Key Vault, which is still can be accessible by flow editor, so how it is more secure ?

Im not managing to count the items by using a string instaed of a number. I get that the xpath expression is invalid for the following query. xpath(outputs('Create_XML'), concat('count(/root/array[normalize-space(Name)="',item(),'"])')) Any help would be appreciated

Hi I am trying to set look up using Azure Data Factory. And my look up Entity has Alternate Keys consisting of 2 columns. How do I set look up in DataFactory activity using the Alternate Key. MS Docs says sink has to be inline dataset. But we are not using Inline Dataset in Dataflow. Could you help ?

Nice tutorial! I'm going to use this to integrate zoho crm with dataverse

Does this require premium license?

This is such a great explanation. I've created 2 custom connectors with code but your video helped me so much. I actually created my 2nd custom connector the same day as the release of this video. Thank you so much!!