Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Office365Users connector error

Posted on 10 Dec 2024 06:12:20 by 4
Hello
 
When trying to load app Office365Users connector failed error keep showing.
 
It's mostly runtime error, and I tried to fix it but it's not working.
 
I think this issue was due to loading time because these all below error would be gone after few seconds or few minutes.
 
But I would like to not show these below error when loading app.
 
Could you please share any ideas with me?
 
 
  • Suggested answer
    WarrenBelz Profile Picture
    WarrenBelz 143,595 on 15 Dec 2024 at 01:36:23
    Office365Users connector error
    Hi @AY-10120606-0​​​​​​​
    I have consolidated a bit so it is easier to see any possible issue - try this for a start. Also please confirm the contents of DataCardValue116 and 79 as they need to contain email addresses that are in your Tenant Entra. The error on GetManager is not related to this code as you are not calling that function here (so it must be somewhere else).
    With(
       {
          _User1: Office365Users.UserProfileV2(DataCardValue116.Value).value,
          _User2: Office365Users.UserProfileV2(DataCardValue79.Value).value,
          _Mode2: ApprovalForm5.Mode = 2,
          _Status: 
          LookUp(
             ColFinARCData,
             ID = Value(DataCardValue102.Value),
             Status.Value
          ),
          _Updated:
          CountRows(
             Filter(
                DeptStatusCheck,
                Status.Value <> "Updated"
             )
          )
       },
       Table(
          {
             Step: 1,
             Name: 
             If(
                _Mode2,
                _User1.DisplayName,
                VarUserDispName
             ),
             Title: 
             If(
                _Mode2,
                _User1.JobTitle,
                VarUserJobTitle
             ),
             Email: 
             If(
                _Mode2,
                _User1.Mail,
                UserEmail
             ),
             Status: 
             Switch(
                _Status,
                "Submitted",
                1,
                "Pending",
                1,
                "Rejected",
                1,
                "Cancelled",
                2,
                3
             ),    
             Current: ApprovalForm5.Mode = 1
          },
          {
             Step: 2,
             Name: DataCardValue96.Value,
             Title: "",
             Email: "",
             Status: 
             If(
                And(
                   _Mode2,
                   _Updated = 0
                ),
                1,
                3
             ),
             Current:
             And(
                _Mode2,
                _Updated <> 0
             )
          },
          {
             Step: 3,
             Name: _User2.DisplayName,
             Title: _User2.JobTitle,
             Email: _User2.Mail,
             Status: 
             Switch(
                _Status,
                "Pending",
                3,
                "Approved",
                1,
                "Rejected",
                2,
                3
             ),
             Current:
             And(
                _Mode2,
                _Updated = 0,
                _Status = "Pending"
             )
          }
       )
    )
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • AY-10120606-0 Profile Picture
    AY-10120606-0 4 on 11 Dec 2024 at 02:29:50
    Office365Users connector error
    Hi, 
     
    I have a gallery on screen and code on items' property is below. please see below....
     
    DataCardValue116 is requester email address from form.
    DatacardValue79 is also approver's email address from form.
     
    [
        {
            Step: 1,
            Name: If(ApprovalForm5.Mode=2,Office365Users.UserProfile(DataCardValue116.Value).DisplayName,VarUserDispName),
            Title: If(ApprovalForm5.Mode=2,Office365Users.UserProfile(DataCardValue116.Value).JobTitle,VarUserJobTitle),
            Email: If(ApprovalForm5.Mode=2,Office365Users.UserProfile(DataCardValue116.Value).Mail,UserEmail),
            Status: Switch(LookUp(ColFinARCData,ID=Value(DataCardValue102.Value),Status.Value),"Submitted",1,"Pending",1,"Rejected",1,"Cancelled",2,3),    
            Current: If(ApprovalForm5.Mode=1,true,false)
        },
        {
            Step: 2,
            Name: DataCardValue96.Value,
            Title: "",
            Email: "",
            Status: If(And(ApprovalForm5.Mode=2,CountRows(Filter(DeptStatusCheck,Status.Value <> "Updated"))=0),1,3),
            Current:If(And(ApprovalForm5.Mode=2,CountRows(Filter(DeptStatusCheck,Status.Value <> "Updated"))<>0),true,false)
        },
        {
            Step: 3,
            Name: Office365Users.UserProfile(DataCardValue79.Value).DisplayName,
            Title: Office365Users.UserProfile(DataCardValue79.Value).JobTitle,
            Email: Office365Users.UserProfile(DataCardValue79.Value).Mail,
            Status: Switch(LookUp(ColFinARCData,ID=Value(DataCardValue102.Value),Status.Value),"Pending",3,"Approved",1,"Rejected",2,3),
            Current:If(And(ApprovalForm5.Mode=2,CountRows(Filter(DeptStatusCheck,Status.Value <> "Updated"))=0,LookUp(ColFinARCData,ID=Value(DataCardValue102.Value),Status.Value)="Pending"),true,false)
        }
    ]
  • WarrenBelz Profile Picture
    WarrenBelz 143,595 on 11 Dec 2024 at 01:13:38
    Office365Users connector error
    Can you please post the code (in Text) that is generating this error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,595

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,098

Leaderboard