cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mantastg08876
Responsive Resident
Responsive Resident

Is it possible to set a default selected value in the Canvas App field which items include SharePoint group members?

Hi all, 

I came across an unusual scenario regarding the Person or Group type of column in the SharePoint list. Could someone please advise if it possible to a default value to logged in person's details for such field in the Canvas app? Perhaps PowerAutomate is a better option for this objective?

 

Tried this configuration for field's configuration in the Canvas App:

  • Items = Choices([@SPListName].SharePointGroup_members);
  • DefaultSeclectedItems = User().FullName

This configuration shows the error: Expected Table Value. 


 

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

Hi @mantastg08876 ,

 

Multi select field use:

 

Table({
Claims: Concatenate(
"i:0#.f|membership|",
User().Email // Person email
),
Department: "",
DisplayName: User().FullName,
Email: User().Email, // Person email
JobTitle: "",
Picture: ""
})

 

 

Single select person column use:

{
Claims: Concatenate(
"i:0#.f|membership|",
User().Email // Person email
),
Department: "",
DisplayName: User().FullName,
Email: User().Email, // Person email
JobTitle: "",
Picture: ""
}

 

https://rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/ 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

View solution in original post

3 REPLIES 3
RezaDorrani
Dual Super User II
Dual Super User II

Hi @mantastg08876 ,

 

Multi select field use:

 

Table({
Claims: Concatenate(
"i:0#.f|membership|",
User().Email // Person email
),
Department: "",
DisplayName: User().FullName,
Email: User().Email, // Person email
JobTitle: "",
Picture: ""
})

 

 

Single select person column use:

{
Claims: Concatenate(
"i:0#.f|membership|",
User().Email // Person email
),
Department: "",
DisplayName: User().FullName,
Email: User().Email, // Person email
JobTitle: "",
Picture: ""
}

 

https://rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/ 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

View solution in original post

Hi @RezaDorrani

Thanks a heap! Also, thank you for your amazing Youtube videos!

@mantastg08876 Most welcome!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (58,346)