cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sumaira
Post Prodigy
Post Prodigy

Office 365 and power apps

Hello community experts 

There is an urgent requirement where I need to update skills details from power apps to office 365.

The client is expecting 4 fields in power app. 

Text field 1

Text field 2

Text field 3 

Text field 4

When the user inputs skills in text field 1 it should be created In skills of office 365

But what I observed is everything is getting replaced 

 

He don't want to enter all fields at a time 

 

He wants to add either 1 or 2 or 3 or all 4 skills whenever he wishes

 

I tried all possible ways 

 

Also if the text fields are blank it shouldn't throw any error 

 

Kindly guide me related to this

 

I really spent lots and lots of time behind this and unfortunately I couldnt find any solution 

 

Kindly guide me 

Best regards 

Sumaira

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Sumaira :

Do you want to use (Text field 1/2/3/4) these four textinput controls to add/edit the user's skills?

I'v made a test for your reference:

1\Set the app's OnStart proeprty to:

 

Set(A,Last(FirstN(Office365Users.MyProfileV2().skills,1)).Value);
Set(B,If(CountRows(Office365Users.MyProfileV2().skills)>=2,Last(FirstN(Office365Users.MyProfileV2().skills,2)).Value));
Set(C,If(CountRows(Office365Users.MyProfileV2().skills)>=3,Last(FirstN(Office365Users.MyProfileV2().skills,3)).Value));
Set(D,If(CountRows(Office365Users.MyProfileV2().skills)>=4,Last(FirstN(Office365Users.MyProfileV2().skills,4)).Value));

 

A,B,C,D is my custom variable

2\Add four TextInputbox controls(Text field 1/2/3/4):
Text field 1-Default

 

A

 

Text field 2-Default

 

B

 

Text field 3-Default

 

C

 

Text field 4-Default

 

D

 

3\Add a button and set it's OnSelect Property to:

 

Clear(TheColelction);  /*TheColelction is my custom collection*/
If(
    !IsBlank('Text field 1'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 1'.Text}
    )
);
If(
    !IsBlank('Text field 2'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 2'.Text}
    )
);
If(
    !IsBlank('Text field 3'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 3'.Text}
    )
);
If(
    !IsBlank('Text field 4'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 4'.Text}
    )
);
Office365Users.UpdateMyProfile({skills: TheColelction})

 

I will check if my profile is modified successfully by creating a collection:

 

ClearCollect(MYTest,Office365Users.MyProfileV2())

 

43.gif

Best Regards,

Bof

View solution in original post

6 REPLIES 6
eka24
Super User
Super User

Please explain further what you expect when you enter in field 1 further. Are you using a form, what is your Datasource excel or SharePoint

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

@eka24 Thanks a lot for the response 

Actually office 365 delve has a field called skills

There we can add the skill details 

And I'm trying to update the skills using power apps 

I have 4 fields 

When I enter data in one field it shouldn't over ride existing values in o365 delve skills 

The data source is office 365

Kindly guide @eka24 

Best regards 

Sumaira 

@Sumaira  

Not very familiar with the usage of the connector but from your previous post, I suggest you watch this video if it will help achieve same result:

https://youtu.be/RE8WqZI8G4o if it does not help, tag another person to help you

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

@eka24 Thanks a lot 

But that didn't solve my problem Still

Kindly guide 

Best regards 

Sumaira 

Hi @Sumaira :

Do you want to use (Text field 1/2/3/4) these four textinput controls to add/edit the user's skills?

I'v made a test for your reference:

1\Set the app's OnStart proeprty to:

 

Set(A,Last(FirstN(Office365Users.MyProfileV2().skills,1)).Value);
Set(B,If(CountRows(Office365Users.MyProfileV2().skills)>=2,Last(FirstN(Office365Users.MyProfileV2().skills,2)).Value));
Set(C,If(CountRows(Office365Users.MyProfileV2().skills)>=3,Last(FirstN(Office365Users.MyProfileV2().skills,3)).Value));
Set(D,If(CountRows(Office365Users.MyProfileV2().skills)>=4,Last(FirstN(Office365Users.MyProfileV2().skills,4)).Value));

 

A,B,C,D is my custom variable

2\Add four TextInputbox controls(Text field 1/2/3/4):
Text field 1-Default

 

A

 

Text field 2-Default

 

B

 

Text field 3-Default

 

C

 

Text field 4-Default

 

D

 

3\Add a button and set it's OnSelect Property to:

 

Clear(TheColelction);  /*TheColelction is my custom collection*/
If(
    !IsBlank('Text field 1'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 1'.Text}
    )
);
If(
    !IsBlank('Text field 2'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 2'.Text}
    )
);
If(
    !IsBlank('Text field 3'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 3'.Text}
    )
);
If(
    !IsBlank('Text field 4'.Text),
    Collect(
        TheColelction,
        {Value: 'Text field 4'.Text}
    )
);
Office365Users.UpdateMyProfile({skills: TheColelction})

 

I will check if my profile is modified successfully by creating a collection:

 

ClearCollect(MYTest,Office365Users.MyProfileV2())

 

43.gif

Best Regards,

Bof

@v-bofeng-msft Many thanks for the help

Thanks a lot for the detailed explanation and help

It solved my problem

Many thanks again

Best Regards,

Sumaira

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,856)