Power Platform Community Forum Thread Details

Hello,

I am wondering if the power app of the starter kit is customizable so that I can add more columns to the invoices list:

I need to add columns such as "Date", "Bill To", "Tax" etc (in order for the user to be able to see all the invoice fields without having to open each invoice).

Thank you in advance.

Categories:

AI Builder

Hi,

Here is a procedure

1. Edit the "Document Automation Application" that you can find in the Apps menu of Power Apps

2. In the editor go to "OnSelect" property of the "Refresh Button" in the "Document List Screen"

3. Replace this code

ClearCollect(
  DocumentsToDisplay,
  Sort(
    'Document Automation Processings',
    'Created On',
    SortOrder.Descending
  )
);

By this code

ClearCollect(
 DocumentsToDisplayTemp,
 AddColumns(
 Sort(
 'Document Automation Processings',
 'Created On',
 SortOrder.Descending
 ) As DocProcessing,
 "FileName",
 DocProcessing.'File Name',
 "CreateOn",
 DocProcessing.'Created On',
 "ProcessingStatus",
 DocProcessing.'Processing Status',
 "ExtractedData",
 LookUp(
 [@'Document Automation Data'],
 'Document Automation Processing'.Name = DocProcessing.Name
 )
 )
);
ClearCollect(
 DocumentsToDisplay,
 AddColumns(
 DocumentsToDisplayTemp,
 "Data1",
 ExtractedData.Data1,
 "Data2",
 ExtractedData.Data2,
 "Data3",
 ExtractedData.Data3
 )
);