HI @shebeerahmmed ：
Do you want to use SharePoint as your data source instead of Office365Users?
Could you tell me whether these fields you mentioned have any special requirements for the data type, or only need the program to run correctly.
I’ve made a test for your reference:
1\Add a list('SP TicketList')
I assume that the data type is configured in the following way.
In addition,ID, Author, Editor, Modified, Created, Created By, Modified By are the default fields of SharePoint list, do not need us to customize
2\Modify the list
I have listed as many detailed steps as possible, but the actual operation is only to replace the data source and adjust some value reference. For specific operations, you can follow the guidance of APP Checker.
MyTicketsScreen(Screen)：
MyTicketsScreenGallery-Items:
If(isAdmin,Sort('SP TicketList',ID,Descending),Sort(Filter('SP TicketList',Author.Email = MyProfile.Mail ),ID,Descending))
MyTicketsScreenGalleryId-Text:
ThisItem.ID
ViewTicketScreen(Screen):
ViewTicketScreenCanvas
ViewTicketScreenDataCard
ViewTicketScreenId-Text:
SelectedTicket.ID
ViewTicketScreenModifiedBy-Text:
Coalesce(First(Office365Users.SearchUser({searchTerm:Text(SelectedTicket.Editor.Email)})).DisplayName, SelectedTicket.Editor.Email)
ViewTicketScreenCreatedBy-Text:
Coalesce(First(Office365Users.SearchUser({searchTerm:Text(SelectedTicket.Author.Email)})).DisplayName, SelectedTicket.Author.Email)
CreateTicketScreen(Screen):
CreateTicketScreenCreateButton-Items:
Patch('SP TicketList',Defaults('SP TicketList'),{
Title:CreateTicketScreenTitleText.Text,
Priority: CreateTicketScreenPriorityDropDown.SelectedText.Value,
TaskStatus:"NOT STARTED",
PercentComplete: "0",
AssignedTO:"",
Description:CreateTicketScreenTaskDescription.Text,
Category:CreateTicketScreenCategoryDropDown.SelectedText.Value});
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Navigate(ConfirmSubmitScreen,None)
ConfirmationDeleteScreen(Screen):
ConfirmationDeleteScreenDeleteButton-OnSelect:
Remove('SP TicketList',LookUp('SP TicketList',ID =TicketToDelete.ID));
Navigate(MyTicketsScreen,ScreenTransition.None)
EditTicketScreen(Screen):
EditTicketScreenCanvas
EditTicketScreenDataCard
EditTicketScreenHeaderTickerNumber-Text:
SelectedTicket.ID
EditTicketScreenHeaderTickerCreatedBy- Text :
Coalesce(First(Office365Users.SearchUser({searchTerm:Text(SelectedTicket.Author.Email)})).DisplayName, SelectedTicket.Author.Email)
EditTicketScreenHeaderTickerModifiedBy- Text :
Coalesce(First(Office365Users.SearchUser({searchTerm:Text(SelectedTicket.Editor.Email)})).DisplayName, SelectedTicket.Editor.Email)
EditTicketScreenUpdateButton-OnSelect:
If(isAdmin,
Patch(TicketList,LookUp(TicketList,Id=SelectedTicket.ID),{
Priority:EditTicketScreenPriorityDropDown.SelectedText.Value,
Category:EditTicketScreenCategoryDropDown.SelectedText.Value,
TaskStatus:EditTicketScreenStatusDropdown.SelectedText.Value,
PercentComplete:EditTicketScreenCompletedSlider.Value/100,
AssignedTO:AssignedToUserDisplayName,
Editor:MyProfile.Mail,
Modified:Now(),
Description:EditTicketScreenDescriptionInput.Text
}),
Patch(TicketList,LookUp(TicketList,Id = SelectedTicket.ID),{
Priority:EditTicketScreenPriorityDropDown.SelectedText.Value,
Category:EditTicketScreenCategoryDropDown.SelectedText.Value,
Editor:MyProfile.Mail,
Modified:Now(),
Description:EditTicketScreenDescriptionInput.Text
}
));
Reset(EditTicketScreenCompletedSlider);
Reset(EditTicketScreenStatusDropdown);
Navigate(MyTicketsScreen,None)
Best Regards,
Bof
