Thank you sir, for the tutorial. i have a little issue here, im building a birthday app and i have a sharepoint list hooked up to the app, but i want to use the Office 365 connector for the Image alone, but it give a "This formula uses scope, which is not presently supported for evaluation." error. Any help on that?
Your Video is helpful. I just have one question. Can we use this way to get the users birthdays? How can we filter the birthday to show one week upcoming birthday. A suggestion would be apprerciated
i need help on the filter. I want to filter the office365user search based on a column "Email" in a sharepoint list, meaning only those office365user listed in this Email column will show up, how to do that?
Great Video! I built an Employee Directory by myself and i have one Problem. I can't search my co-workers by their office phone numbers, only by their mobile numbers. Do you have a solution for this Problem?
Very great tutorial sir i watch all your videos but i am trying to make an app for my company just say New asset request Form app in power apps i built it by using sharepoint list item as data source so now user can fill form and submit its going to create list item and also after submit it will go to peninput signature page and send for approval button here the problem is filled details are creating in list and signature creating in document folder as file .jpg but what i need i want to compose html in flow to concert that list item and this image into single pdf and send for manager approval. its all process is not to store user signature. can you help me please sir that would be great Thanks.
Great tutorial. I want to take this to the next step and then when you click on the employee the next screen will show all of their details in a form - how do I do that? I am having issues with the form grabbing the employee i selected from the first screen.
Hi @Tommy, you can use the same connector to use the .Profile expression to pull any property you wish. What I would likely due is bring all those properties into a gallery showing one record and position it however you want.
@@PragmaticWorks Thanks for the quick reply, but I am not understanding what you mean. I guess I am not understanding how to pass the selected employee profile from screen 1 to screen 2 to then display the list of properties I want. More reading and studying for me! Thanks anyway
@@AGELOK666 As with most things, there are a million ways to do any one thing. The simplest way to implement what you're trying to do is use the same example in this video. Once you select the employee to have one additional gallery or a series of text boxes. For that gallery point to (from my video for example) galEmployeeList.Selected.GivenName and galEmpoyeeList.Selected.CIty and so on. This can work cross-screen too. :) Hope that gets you going - Brian
One way is to add each user into a local collection by selecting each one (almost like a shopping cart). Then use ForAll to loop over the collection and email each one. -- Brian
@@PragmaticWorks thanks sir, it is done... excellent suggestion. can i ask u one more thing... how will i reset all inputs on loading of screen? i tried onvisible function, it is not working
Good Day, and thank you for the materials and ongoing knowledge transfer. I have 1 question where I'm getting an error when I get the user manager in Employee Directory if the manager is not set in AAD. I have tried many workarounds including filtering blank manager records, with no solution. This is also happening fo profile picture. Can you support me. Filter( Office365Users.SearchUser({searchTerm: txtPplSearch.Text, top:100}), AccountEnabled = true, !IsBlankOrError(Office365Users.ManagerV2(Id).displayName), !IsBlankOrError(Office365Users.UserPhotoV2(Id)) )
Ray Rivera You could do that if you have active directory and office 365 integration. But if not he won’t be able to do that. There is azure ad integration as a connector also that could easily get you there
Your idea is very interesting, actually I want to adopt it (if you don't mind) but starting I have the first challenge, I'm using Office 365 and in the formula Office365User.UserPhoto(ThisItem.Id) I'm getting the error: The methodo 'UserPhoto' has an invalid value for parameter 'userId). How do I solve it? Thanks in advance.
Typically that means the person you['re displaying a photo for doesn't have a photo. So you'll need to wrap that in a IfEmpty check. You can also try doing UserPhoto2, which has slightly better error handling.
Great tutorial. Would you know how I can can filter service accounts from O365?
Thank you sir, for the tutorial. i have a little issue here, im building a birthday app and i have a sharepoint list hooked up to the app, but i want to use the Office 365 connector for the Image alone, but it give a "This formula uses scope, which is not presently supported for evaluation." error. Any help on that?
Your Video is helpful. I just have one question. Can we use this way to get the users birthdays? How can we filter the birthday to show one week upcoming birthday. A suggestion would be apprerciated
Great tutorial... I followed the video, but when I click on a user in my organization none of their information comes up?
If we add the connector, will all the users in the selected connector "Office365Users" get an email as soon as i add the connector?
i need help on the filter. I want to filter the office365user search based on a column "Email" in a sharepoint list, meaning only those office365user listed in this Email column will show up, how to do that?
Can I use the location to find out the employees only in my location?
Great Video! I built an Employee Directory by myself and i have one Problem. I can't search my co-workers by their office phone numbers, only by their mobile numbers. Do you have a solution for this Problem?
Hi Daniel
How did you get it to search by the office numbers? :)
Requrst you to help connection of office 365 users in model driven app
Very great tutorial sir i watch all your videos but i am trying to make an app for my company just say New asset request Form app in power apps i built it by using sharepoint list item as data source so now user can fill form and submit its going to create list item and also after submit it will go to peninput signature page and send for approval button here the problem is filled details are creating in list and signature creating in document folder as file .jpg but what i need i want to compose html in flow to concert that list item and this image into single pdf and send for manager approval. its all process is not to store user signature. can you help me please sir that would be great Thanks.
Great tutorial. I want to take this to the next step and then when you click on the employee the next screen will show all of their details in a form - how do I do that? I am having issues with the form grabbing the employee i selected from the first screen.
Hi @Tommy, you can use the same connector to use the .Profile expression to pull any property you wish. What I would likely due is bring all those properties into a gallery showing one record and position it however you want.
@@PragmaticWorks Thanks for the quick reply, but I am not understanding what you mean. I guess I am not understanding how to pass the selected employee profile from screen 1 to screen 2 to then display the list of properties I want. More reading and studying for me! Thanks anyway
@@AGELOK666 As with most things, there are a million ways to do any one thing. The simplest way to implement what you're trying to do is use the same example in this video. Once you select the employee to have one additional gallery or a series of text boxes. For that gallery point to (from my video for example) galEmployeeList.Selected.GivenName and galEmpoyeeList.Selected.CIty and so on. This can work cross-screen too. :) Hope that gets you going - Brian
@@PragmaticWorks Awesome! I think I was trying to be too sophisticated. Simplicity works, cheers!
thank u sir... how can i select multiple users from this list gallery for mailing
One way is to add each user into a local collection by selecting each one (almost like a shopping cart). Then use ForAll to loop over the collection and email each one. -- Brian
@@PragmaticWorks thanks sir, it is done... excellent suggestion. can i ask u one more thing... how will i reset all inputs on loading of screen? i tried onvisible function, it is not working
Thanks in a million.
Good Day, and thank you for the materials and ongoing knowledge transfer. I have 1 question where I'm getting an error when I get the user manager in Employee Directory if the manager is not set in AAD. I have tried many workarounds including filtering blank manager records, with no solution. This is also happening fo profile picture. Can you support me.
Filter(
Office365Users.SearchUser({searchTerm: txtPplSearch.Text, top:100}),
AccountEnabled = true,
!IsBlankOrError(Office365Users.ManagerV2(Id).displayName),
!IsBlankOrError(Office365Users.UserPhotoV2(Id))
)
is it possible to also get the user's windows login name?
Are you referring to their active directory account?
yes, if possible.
Ray Rivera You could do that if you have active directory and office 365 integration. But if not he won’t be able to do that. There is azure ad integration as a connector also that could easily get you there
perfect
Your idea is very interesting, actually I want to adopt it (if you don't mind) but starting I have the first challenge, I'm using Office 365 and in the formula Office365User.UserPhoto(ThisItem.Id) I'm getting the error: The methodo 'UserPhoto' has an invalid value for parameter 'userId). How do I solve it? Thanks in advance.
Typically that means the person you['re displaying a photo for doesn't have a photo. So you'll need to wrap that in a IfEmpty check. You can also try doing UserPhoto2, which has slightly better error handling.