Leave-Request Template: Request Details ist not visible after I change DataSource from Excel to SharePoint

[bjamal]

Hi

I am working in PowerApps "leave-Request". I changed Data Sources from Excel to Sharepoint List ( My App was first connected with Excel). I have one Problem: Request Details ist not visible (see Picture). I can't approve or decline the request.

anyone has any Idea ?

[PriyankaGeethik]

Hi @bjamal ,

Could you please share more details ?

Formula used in the label field 

Your SharePoint Request Details column type. 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[bjamal]

I create first Lists in SharePoint. Then I create the Template Leave request and I choose  to save data in Excel. All work fine. Then I add Sharepoint Lists ( as in Excel: Leave, Holidays, Balance) as Data Source. I compare alle formulas wiht normal App, alle are the same.

leave

[PriyankaGeethik]

Could you please share what formula you added in the label ?  

[bjamal]

ok.. In wich Label exact ?

[PriyankaGeethik]

Hi @bjamal ,

The one which is selected in the screenshot. 

I have one Problem: Request Details ist not visible (see Picture).

[bjamal]

GalleryRequestDetails (Items):

 //table of data specific to selected leave request item. Dynamically updates based on user selection from GalleryRequests
If(_managerView; 
    Table(
        {Header: "Total time requested"; 
         Value: _requestedDays & " day(s)";
         Image:Basel_Clock}; 
        {Header: "Leave type"; 
         Value: _selectedLeaveItem.LeaveType;
         Image: LookUp(LeaveTypeCollection; type=_selectedLeaveItem.LeaveType).icon};
         {Header: "Leave details"; 
         Value: _selectedLeaveItem.Detail;
         Image: Basel_detail_list};
         If(CountRows(RequestOverlaps) > 0; 
         {Header: Upper("Overlaps with other requests (" & CountRows(RequestOverlaps) & ")");
          Value: _requestOverlapMessage;
          Image: "null"})
         ); 
    Table(
        {Header: "Total time requested"; 
         Value: _requestedDays & " day(s)";
         Image: Basel_Clock}; 
        {Header: "Leave type"; 
         Value: _selectedLeaveItem.LeaveType;
         Image: LookUp(LeaveTypeCollection; type=_selectedLeaveItem.LeaveType).icon};
        {Header: "Request sent to"; 
         Value: _selectedApprover.DisplayName;
         Image: _selectedApproverPhoto}))

[PriyankaGeethik]

Hi @bjamal ,

If in both case there is data added in the gallery there should be data. Could you please also share the GalleryRequestDetails Visible property ? 

[bjamal]

Visible Propoerty: 

_showDetails

I am comparing it with App that work fine. all Formulas are the same. I think the probelem related with SharePoint List ? 

[bjamal · Accepted solution]

I find the Problem. PowerApps take the original Name in SharePoint List (Balance)  Title ( as EmployeeEmail"  in SharePointList) is created as a Title. Even I renamed It in SharePoint to "EmployeeEmail".  The Problem was "GalleyRequests" in On select Probperty.