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
Solved! Go to Solution.
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())
Best Regards,
Bof
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
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.
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())
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
180 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
266 | |
91 | |
78 | |
68 | |
67 |