Announcements
Hi, how to make the dropdown for the Manager's Name is based on the Manager column where the choices are Yes or No. For example, if the employee is a manager then the column Manager will become Yes and his name will be displayed in the dropdown for the Manager's Name column. This is a Sharepoint customized form.
Thank you,
Hi @syhrh ,
you could try to set combo box's defaultselecteditems property to:
If( IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected), Filter(Choices([@Employee].'Manager''s Name'),Value=User().FullName), Parent.Default )
Best Regards,
Bof
@v-bofeng-msft
I got these errors
Please try 'value' instead of 'Value'
Hi @v-bofeng-msft, still the same
I've made a test but did not encountered the problem you mentioned.
Please check the return value of Choices([@Employee].'Manager''s Name')
@v-bofeng-msft The Manager's Name is a person column. Is that the reason why?
Yes it is. Please try:
If( (IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected)) && User().Email in ForAll([@Employee].'Manager''s Name','Manager''s Name'.Email), { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", Claims: "i:0#.f|membership|" & User().Email, DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" }, Parent.Default )
Hi @v-bofeng-msft, is this formula to display the current user logged-in in the dropdown values? Because that's what I got. What I require to do is the Manager's Name dropdown values to have names of which the Manager column is a Yes. The Manager column is a choice column with Yes and No choices.
If current user is a manager it will display current user , if not it will show nothing.
Hi @v-bofeng-msft, I'm sorry, but that's not my requirement 😅
My requirement is to make the Manager's Name dropdown values have names from the items in the list in which the Manager column is a Yes.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 294 Most Valuable Professional
11manish 210
Valantis 169
