Hi there,
I have a canvas app which has a gallery "glyApproveQuotation" that show items from a sharepoint list, when an item is selected a button with the following formula navigate to another screen
items property of the button=
Switch(
LookUp(
glyApproveQuotation.AllItems, ID = selectedItemID).AnalysisClass,
"DNA", Navigate('DNA Analysis Overview', ScreenTransition.UnCoverRight, { QuoteSelected: LookUp(
glyApproveQuotation.AllItems, ID = selectedItemID) }),
"RNA", Navigate('RNA Analysis Overview', ScreenTransition.UnCoverRight, { QuoteSelected:
Notify("Class not recognized", NotificationType.Error)
);
the item selected is thenstored in a variable selectedItemID, when navigating to the other screen the controls "Text, dropdown and combobox" display the items selected, all the control shows the items selected with the following formula
If(
IsBlank(QuoteSelected),
"",
QuoteSelected."The Sharepoint column")
except the dropdown which display nothing "just blank"
I set the default property of a dropdown as follow
Default = If(IsBlank(QuoteSelected), "", QuoteSelected.RicGroup)
the SharePoint column in the case of the dropdown is of type singlle line of text
from the screenshot where the arrows are pointing it shows the group "Ric.Tonon" in the Default property pane but the control is blank
The dropdown depends on a Text label and a combobox, the dropdown shows the groups the selected user "from the combox " belong to, it could blank in case the user doesn't belong to any group, or 1-6 option to select from
the schema has to be closely tied to schema of the item property of the item property, the item property has this formula of DataType table
the dropdown Items=
Filter
( GroupDetailsDNAOverview, StartsWith(Lower(displayName), Lower("ric." & txtPILastNameDNAOverview.Text)) || StartsWith(Lower(displayName), Lower("Ric." & txtPILastNameDNAOverview.Text)) )
The dropdown default with this formula which is of data type text
Default = If( IsBlank(QuoteSelected), Blank(), QuoteSelected.RicGroup )
The dropdown depends on to two controls, a combobox and and Text control,
the Variables in the dropdown control are defined in a combobox the Onselect property
OnSelect =
IsBlank(cmbPIEmailDNA.Selected.UserPrincipalName), // Check if a user is selected
"",
UpdateContext({UserGroupsDNA: MicrosoftEntraID.GetMemberGroupsV2(cmbPIEmailDNA.Selected.UserPrincipalName, true)})
);
ClearCollect(
GroupDetailsDNA,
ForAll(
UserGroupsDNA.value,
MicrosoftEntraID.GetGroup(Value)
)
);
The combobox item property show this formula to search users.
Item =
Office365Users.SearchUserV2({searchTerm: Self.SearchText}).value
The Text control displays the user's last name extracted from the combobox.
Text =
If(
IsBlank(cmbPIEmailDNA.Selected), // Check if no user is selected
"", // If no user is selected, display nothing
Office365Users.UserProfile(cmbPIEmailDNA.Selected.UserPrincipalName).Surname // Fetch the surname of the selected user
)
Please Advice
Mogahid