Great video, I didn't know flows could call one another (service flows - very handy to know), quite a complex process to accomplish a simple task... something that I think many people need... Microsoft should make this into a flow template. Can't wait for more vids.
Fantastic "how-to" video blog Paul ! I will be definitely be testing your service flows as I have a couple scenarios to work out. BTW, good call on making this a video instead of a post. :-)
Hi Paul, thanks for another very helpful contribution. Maybe it is an option to think about the blog in a similar modular way as you have done with the “service workflow” concept. I guess this would be a form of “blogging backwards”. You could just start with a blog about “how to get the access token”. I suppose you have already done that in one of your recent blogs. So I would love to see a blog post about managing item level permissions on SharePoint list through Flow. Both of these blog posts could then be reused in a multitude of scenarios. I very much appreciate the time you put in with these contributions. Andre
Hi Paul, would this also work if I replaced the trigger with 'when a file is created on sharepoint' (assuming i change the trigger object properties where necesary)
Hi Paul, I viewed this again to try and implement - are you able to expand on how you are sending the new role assignments back in the response, and can you expand more of the get access token flow... you didnt open some of the expresssions... also with the client ID and client secret... is client ID what you are referring to as App ID in your variable (in the set oAuth Application ID expression)?
Very nice! My first Flow...kind of hung up on the part where you get back the [access_token] at 17:03 . I do not have that available as a dynamic content. All I have is [Body] and [Status code]. Also, I noticed that on noellawlor's blog that he was going into a Data Operations action - Parse JSON operation whereas you seem to have the access token right out of the http post. Can you expand on this a bit?
Hi Paul - Great video, nicely articulated and explained. I recreated a flow step by step but it seems to be getting stuck at the very point which you skipped :) - "Getting Access Token" (9:11 in the video above). Can you please shed some light into the steps on how to do it with an Office365 SharePointOnline environment. Much appreciated :) thanks
Hi Paul, I add some trouble with the token then I have used 'Send an HTTP request to Sharepoint' instead of a standard 'HTTP' Flow action. With this kind of action, no need of token. The action runs with the developer credentials.
Paul... sat down with you last year when you had a chat to our team about PowerApps and Flow. I was wondering if this is any simpler to do in Flow now? Did you end up blogging the steps in more details?
@@paulculmsee That's awesome Paul... I need to put together a Flow to do this for my current project. Can you give me a hint on how to do it before you post? Cheers!
Hi Paul, would be great to share all flow steps in a blog. Especially the ones you didn't open in the video. I'm trying to get this done, but getting the access token is not a success in my case. Not really clear how this works. Thanks!
Am getting the below error when trying to build get access token "error": "unauthorized_client", "error_description": "AADSTS70001: Application with identifier xxx-xxx was not found in the directory xxx-xx Could you please advice to resolve the error. Tested the post request using the postman and got the above error
I got registered and now am successful in getting the access token. Now when I try to get the user details , I get the below error Access denied. You do not have permission to perform this action or access this resource
Hi Paul, thanks for posting this. Would it be possible to assign permissions to Sharepoint Groups to Doc library files? I could then finally get rid of folders.
If i try to get the item thru REST API api/lists/GetByTitle('zxxxxxx')/items(4) , am getting the error "odata.error": { "code": "-2130575338, System.ArgumentException", "message": { "lang": "en-US", "value": "Item does not exist. It may have been deleted by another user." } } How do I resolve the above issue ?
Hi Shibu, I ran into a similar issue and resolved it by changing the apostrophes ( ' ) with %27. Also, it appears your Item Id parameter is missing the apostrophes altogether. I'd suggest you try modifying it to something like this: api/lists/GetByTitle(%27zxxxxxx%27)/items(%274%27) Don't forget you can always grab the Uri generated by the failed Flow and paste it directly into your browser to see what, if anything, is returned. I played around with it in the Url field until it successfully returned a response and then applied those changes to my REST call. Regards.
Great video, I didn't know flows could call one another (service flows - very handy to know), quite a complex process to accomplish a simple task... something that I think many people need... Microsoft should make this into a flow template.
Can't wait for more vids.
Excellent video, and much needed functionality in Flow. I'd love to have a step-by-step blog post on this as well.
Great video Paul. A blog post on this would be very valuable, thanks.
Fantastic "how-to" video blog Paul ! I will be definitely be testing your service flows as I have a couple scenarios to work out. BTW, good call on making this a video instead of a post. :-)
Hi Paul, this looks very useful. Having it documented woul dbe great. I used user voice to suggets MS creating a workflow action to achieve this too
Hi Paul,
thanks for another very helpful contribution. Maybe it is an option to think about the blog in a similar modular way as you have done with the “service workflow” concept. I guess this would be a form of “blogging backwards”. You could just start with a blog about “how to get the access token”. I suppose you have already done that in one of your recent blogs. So I would love to see a blog post about managing item level permissions on SharePoint list through Flow. Both of these blog posts could then be reused in a multitude of scenarios. I very much appreciate the time you put in with these contributions. Andre
Hi Paul, would this also work if I replaced the trigger with 'when a file is created on sharepoint' (assuming i change the trigger object properties where necesary)
Nice work! Is it possible to use app permissons of Workflow instead of creating new app permissions (for getting access token)?
Hi Paul, I viewed this again to try and implement - are you able to expand on how you are sending the new role assignments back in the response, and can you expand more of the get access token flow... you didnt open some of the expresssions... also with the client ID and client secret... is client ID what you are referring to as App ID in your variable (in the set oAuth Application ID expression)?
Very nice! My first Flow...kind of hung up on the part where you get back the [access_token] at 17:03 . I do not have that available as a dynamic content. All I have is [Body] and [Status code]. Also, I noticed that on noellawlor's blog that he was going into a Data Operations action - Parse JSON operation whereas you seem to have the access token right out of the http post. Can you expand on this a bit?
Thanks for the detailed video. It would be great to have a blog entry with step by step instructions.
now that the HTTP triggers are premium, is there an alternative? Is it possible to do this with SharePoint Http action?
Hi Paul - Great video, nicely articulated and explained. I recreated a flow step by step but it seems to be getting stuck at the very point which you skipped :) - "Getting Access Token" (9:11 in the video above). Can you please shed some light into the steps on how to do it with an Office365 SharePointOnline environment. Much appreciated :) thanks
Could you describe more on the 2nd flow... Request Body JSON Schema
, etc? Do you have this saved anywhere we could have a template copy of it?
Great video Paul. So is there any blog that we can reference ?
What would be the issue if my flow recognises the team sites page on sharepoint but doesn’t recognise the lists on that team site.
Hi Paul, this is exactly what would resolve my issues and allow me to switch off the WF Designer 2010. Can I get more details (steps) - thx
Hi Paul, I add some trouble with the token then I have used 'Send an HTTP request to Sharepoint' instead of a standard 'HTTP' Flow action. With this kind of action, no need of token. The action runs with the developer credentials.
Hey... this vid is out of date... i will record a new one. Now you should do this with the SharePoint HTTP action
Paul... sat down with you last year when you had a chat to our team about PowerApps and Flow. I was wondering if this is any simpler to do in Flow now? Did you end up blogging the steps in more details?
@@paulculmsee That's awesome Paul... I need to put together a Flow to do this for my current project. Can you give me a hint on how to do it before you post? Cheers!
Would you mind share all variables setting, thanks
Hi Paul, would be great to share all flow steps in a blog. Especially the ones you didn't open in the video. I'm trying to get this done, but getting the access token is not a success in my case. Not really clear how this works. Thanks!
Am getting the below error when trying to build get access token
"error": "unauthorized_client",
"error_description": "AADSTS70001: Application with identifier xxx-xxx was not found in the directory xxx-xx
Could you please advice to resolve the error.
Tested the post request using the postman and got the above error
I got registered and now am successful in getting the access token. Now when I try to get the user details , I get the below error
Access denied. You do not have permission to perform this action or access this resource
I tried to use Sharepoint REST many times, usually with no luck. Could You explain all the pieces in detail? Please.
well said
Definetly blog this Paul. You have my Approval! :)
Hi Paul, thanks for posting this. Would it be possible to assign permissions to Sharepoint Groups to Doc library files? I could then finally get rid of folders.
If i try to get the item thru REST API api/lists/GetByTitle('zxxxxxx')/items(4) , am getting the error
"odata.error": {
"code": "-2130575338, System.ArgumentException",
"message": {
"lang": "en-US",
"value": "Item does not exist. It may have been deleted by another user."
}
}
How do I resolve the above issue ?
Hi Shibu,
I ran into a similar issue and resolved it by changing the apostrophes ( ' ) with %27. Also, it appears your Item Id parameter is missing the apostrophes altogether. I'd suggest you try modifying it to something like this:
api/lists/GetByTitle(%27zxxxxxx%27)/items(%274%27)
Don't forget you can always grab the Uri generated by the failed Flow and paste it directly into your browser to see what, if anything, is returned. I played around with it in the Url field until it successfully returned a response and then applied those changes to my REST call.
Regards.
I have exact same issue. I put %27 but its not working .
Did you end up resolving the issue? I'm having the same issue when trying to break inheritence. Thanks!
@@tushargohel3978 Did you end up resolving the issue?