@17:40 Shane: "be brave!" --- I now tell this to myself everytime i get intimidated by codes i dont understand and have no choice but to learn it myself coz im supposed to be the powerapps 'expert' in my org (but srsly it's all just thanks to shane's videos!). Thank you so much !
@ShanesCows
2 жыл бұрын
I love this! Thanks for sharing.
@ricardobunge5957
2 жыл бұрын
Always learn new tips watching your videos... Today it was typing a name that's not showing in Dynamic Content and having it served up. Awesome! Thanks as always... keep up the great work.
@ShanesCows
2 жыл бұрын
Awesome! :)
@ally1708
Жыл бұрын
YOURE PERFECT SHANE
@ShanesCows
Жыл бұрын
Thanks 😊
@texian2112
2 жыл бұрын
friggin amazing video. I've been struggling with this for a few weeks and watching a few times solved the problem. Woohoo.
@rami4942
2 жыл бұрын
Perfect as usual, we need more about power automate.
@ShanesCows
2 жыл бұрын
Working on it! 😀
@asimrehan73
2 жыл бұрын
You make it so simple 😎 Thank you
@ShanesCows
2 жыл бұрын
My pleasure 😊
@coolhool2
2 жыл бұрын
this has been so helpful!
@ShanesCows
2 жыл бұрын
Awesome! Glad it helped. 🐶
@sueamin2788
Жыл бұрын
Hi Shane: Thank you for clearly explaining this complex process. It really helped! Truly appreciate it. Also, I have a case where for each department there are users listed as rows (not columns) in SP list A. I like to copy and save in another list B in a single multi user (person field allowing multiple selections) field for the record where the department is matched. Do you have a video explaining the process? If so, can you please direct me to that? As always, Thank you for sharing your knowledge! SueA.
@ShanesCows
Жыл бұрын
The rows of people will be a table. You will need to put that table in the format the multi-choice column is looking for. kzitem.info/news/bejne/w2p8yGltjqV7f34 shows you that format. :)
@sueamin2788
Жыл бұрын
@@ShanesCows Thank you for your reply. The suggested video shows "how to" with hard coded values. In my case source values are dynamic and thus I am unable to use the Hard code approach. It does explain the Table function concept very well. Thank you for that. Any suggestion on how to pull all the eight people listed as eight rows each with department Math in List A and copied on to List B in a single row with a multi People field in List B having Department Math? If Get HTTP method then what could be the Uri for that be? Thank you for your consideration.
@isaacsogunro5179
2 жыл бұрын
Hi Shane, When I get to the part where you Parse JSON, when I copy the 'body' out of the Content box and paste it in the expression box, I get "@{body('Send_an_HTTP_......" but in your video you had "@(outputs('Send_an_HTTP_....". Why am I seeing 'body' instead of 'outputs'. It's been driving me bananas since last week. Thanks for any help you can provide.
@Worrelpa
2 жыл бұрын
Watch out for those semicolon delimiters. Flow has a bug where sometimes it does not save the delimiter on you. You save got back and its not there. Mostly we use nested Azure Ad group other than users in SharePoint groups. We can use the Office group connector to get the group members that way which is cool.
@ShanesCows
2 жыл бұрын
Good stuff!
@oddreonuhh
2 жыл бұрын
@5:25 my flow ran successfully but when I go to the outputs, it only gives me a link Click to Download. I'm guessing this is because my list of group members that the flow is pulling, is pretty long. I downloaded it but it doesn't look anything like what you have. any ideas on if I'm doing something wrong?
@ShanesCows
2 жыл бұрын
I don’t. If you called it correctly it should look the same no matter the volume. Maybe check the headers for api call?
@oddreonuhh
2 жыл бұрын
ok, I re-watched carefully a handful of times...and it worked! then I hit the issue of null UserId and I added the null...it wasn't working. Rewatched a bunch of times and finally realized I accidentally forgot the comma after the square. I'm working on a big list of people, so I put the email addresses in the body of the text to test it out first. ta-da!! thanks for such an incredibly helpful video and going over the potential errors you will face.
@estherlopeznavarro6100
Жыл бұрын
Hi Shane, is it possible to remove all the users from a SharePoint Group at once with Power Automate? Thanks!
@cristobalandrescerongaldam6186
Жыл бұрын
Excelent!. Do you have any video where you are using this in power apps? ... maybe something like initial user validation using "OnStart" ???
@vvv3448
Ай бұрын
Great Video. Is there a way to add a column to say what SharePoint group they are in?
@mayelasanchez560
2 жыл бұрын
Hi Shane this was life saver. Only one problem, I have 5 people in the group. It sends the first email with the first 2 names on the group, then send second email with the first 3 names and so on. So getting duplicate emails. How can I correct this?
@nsgaming1928
2 жыл бұрын
Hi Shane, Your videos are so awesome. Can you please create one on adding Functional accounts on Flows.
@ShanesCows
2 жыл бұрын
That is a good idea. :) I like it and will add it to the list. Thanks
@nsgaming1928
2 жыл бұрын
@@ShanesCows Thank you so much
@reivaxsevy
2 жыл бұрын
Thanks for sharing this video very helpful. Is there a way to access SharePoint groups even without having access to a certain SharePoint site? This is what I've tried so far, I have a separate account, used that account to publish the Flow, have that account to have full control access to the site. So when I check the connection it is using that separate account with full control access to the site. But then if other users with no permission to the site run this flow, it's giving an access denied error. TIA.
@DavidKilgallon
Жыл бұрын
This video is a lifesaver, i have gone through this video over and over, but i am still getting the following error: InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.
@ShanesCows
Жыл бұрын
David if you look at the ParseJSON schema that it autogenerated for you at the bottom if a required section. Remove Content and then rerun it.
@DavidKilgallon
Жыл бұрын
@@ShanesCows thank you for replying so quick, upon looking at the schema, unfortunately the required section doesnt show content for some reason, so no idea why its looking for it :( under required i have the following: "__metadata", "Alerts", "Groups", "Id", "IsHiddenInUI", "LoginName", "Title", "PrincipalType", "Email", "Expiration", "IsEmailAuthenticationGuestUser", "IsShareByEmailGuestUser", "IsSiteAdmin", "UserId", "UserPrincipalName" Could it be one of these that is the issue?
@essakhader485
2 жыл бұрын
Adding Records to Dynamics 365 Finance and Operations from a Canvas App. I have created an application on Canvas and I want to send the data to my Dynamic 365, and I am saving it in Dataverse, so I need help with that. but I don't know how to do that, can you explain this issue in the video?
@kevinmendones1878
2 жыл бұрын
Hi Shane, if possible how can I integrate the power automate in my Web base application outside of office 365 Thank you in advance
@ShanesCows
2 жыл бұрын
Power Automate flow has an HTTP trigger endpoint you can call.
@rjespi3863
2 жыл бұрын
Hi Shane, thank you for your very informative video, i have a query , how can we dynamically get the sharepoint group of a document using powerapps ?
@ShanesCows
2 жыл бұрын
I don't know that one. Sorry
@ginohobbs4342
2 жыл бұрын
What the best solution to pull users from multiple Sharepoint groups?
@ShanesCows
2 жыл бұрын
You would have to take this concept and loop through all of the groups I think.
@MerlinVac
2 жыл бұрын
Shane this is a great video and very useful. Do you have a video that can explain how to read a CSV file and push a items to a SharePoint list? Since this in MS GCC HIGH we can't use third party plugins or anything not supported by GCC High.
@ShanesCows
2 жыл бұрын
Check this video out on pulling in Excel data and saving it to SharePoint. Maybe it will give you some ideas. kzitem.info/news/bejne/spmN0HWqcIOHoWk OR this video on cut and paste should let you do it also kzitem.info/news/bejne/x6V9x4Ooe6yHf5g 😀
@GreyDob
2 жыл бұрын
Hi Shane, thanks again for another great video. It seems I run in the same problem again as in my other previous attempts. The send HTTP request is working. In step 3, Parse JSON, Content when I insert [body] and copy paste the content in a text editor the format is like this ... @{body('Send_an_HTTP_request_to_SharePoint')} ... Completely different from yours. I have tried several possible changes but nothing works. Seems like my result is never a string.
@ShanesCows
2 жыл бұрын
YOu can email a screen shot or two and I will try to take a look. shane at powerapps911 dot com
@aysanhaghani5271
2 жыл бұрын
Great video Shane! thank you! I am wondering if it`s possible to manage this list ( group members) in power apps? let`s say the SharePoint group is going to be the admins of an app and I want to give the admins option to manage the group from the power app
@fchalbert
2 жыл бұрын
Shane, perfect, thank you! Can this be expanded to multiple SharePoint Groups as part of an approval action where several fields are SharePoint Groups selected (drop down choices) by a user in selecting the "path" their list item must travel to become approved? Thanks again!!
@alexlee4340
2 жыл бұрын
Hi Shane, thanks for all the amazing content as always. Can you demonstrate using a flow to compare, e.g. a Sharepoint Document Library with a List? I'm trying to write a flow that will compare folder titles to a bunch of list items and update the folder metadata on any matches--but haven't been able to find anybody online doing that specific thing (and obvs can't figure it out myself). Thanks!
@traceyagate9578
2 жыл бұрын
Hi Shane, I'm really new to PowerAutomate and PowerApps but have found your videos really helpful and easy to follow, thank you. Could you use the logic in this video to get details from a MS Teams Group? I need to write a flow that removes members from a Teams group. Each time I get close I get an error 'Resource '6b6acd92-e52c-450f-b624-cfe5fcf213d3' does not exist or one of its queried reference-property objects are not present' The comparison data is held in a SharePoint list. I'm using the UPN which in this case is an email address but keep getting the error. Thanks :)
@SUNNYDSAM1
2 жыл бұрын
Hi Shane, Thank you for all your informative videos. Can you please create a video on Filter or Look up data between 2 SharePoint where they have same column names. The main issue is I can't do "Title = Title". I didn't find any information with respect to this over internet.
@SkarpHedinn
2 жыл бұрын
Could you post an example of a lookup/filter you're using? In one of my apps I have two separate SharePoint lists in an effort to have a list of items in an inventory that relate to a list that corresponds with check-in or check-out events. The way you query is dependent on what list is the source of the lookup. For example if my list of inventory items is MyInventoryList and my list that has check-in and check-out events is MyInventoryTrackingList, and I want to see all the check in/check out history for a particular inventory item, it would look like this to filter for it: Filter('MyInventoryTrackingList', Title = 'MyInventoryList'.Title) I am filtering the MyInventoryTrackingList on SharePoint where the column 'Title' matches the MyInventoryList on SharePoint. So the column you are using that is outside of the source you are filtering by requires the listname followed by a dot, and the column name. If this filter were placed in a gallery as items, it would list all the items on the tracking list with an ID that matches the item in the MyInventoryList.
@arrosari
2 жыл бұрын
Have you tried this with Group(0)?
@arrosari
2 жыл бұрын
Disregard...I should have used "/_api/web/siteusers?"
@ShanesCows
2 жыл бұрын
Glad you got it!
@lukebarron8468
2 жыл бұрын
You could get the same output without having to parse the JSON and only use expressions. In your Apply to Each control use the expression outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'] as the output from a previous step. Then in your Append to Variable step use the expression items('Apply_to_each')?['email'] as the Value. Also remembering to include the semicolon in the Append to Variable value.
@ShanesCows
2 жыл бұрын
Very true Luke. 🤩 The challenge is that is a lot of hand coding that makes it super hard for non-IT people, so I also look for the way to do it with the least amount of "code". Great tip!
Пікірлер: 56