web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Data from Dataverse ta...
Power Apps
Answered

Data from Dataverse table not showing in Collection

(0) ShareShare
ReportReport
Posted on by 4
Hi Community,
 
I am developing a power app for the Approval of timesheet. My datasource here is a dynamic dataverse table. In my Power app, i am using a Multi-selection table for selecting and viewing the Time entries, When I click any records and click the button to Approve, it is taking those Time Entries to the Excel Sheet.
 
The issue I am facing here is I have defined a collection for the Selected items in the table and also I am defining another collection which has other columns as well to be added in the Excel sheet( since I am showing only few columns in the table in power app, I want to show other columns as well in my excel sheet, So I am using another collection to show those columns). Here, in the second collection, it is not showing any data for me. I also have Unique column for Identification as well in dataverse table, still the collection is not showing data. How to resolve this?
 
The query I used is below:
 
UpdateIf(
    'Sweden_News',
    ThisRecord.'RecId' in Table2.SelectedItems.RecId,
    {
        ApprovalStatus: "Approved",
        ApprovalDate: Today()
    }
);
// Initializing collection for passing the selected entries
ClearCollect(
    SelectedEntries,
    Table2.SelectedItems
);
//for loop with selected entries and refer Sweden New table for other columns
ClearCollect(
    CollectionWithAllRequiredColumns,
    ShowColumns(
        Filter(
            'Sweden_News',
            'RecId' in Table2.SelectedItems.RecId
        ),
        EmployeeName,
        EmployeeKey,
        ProjectName,
        CostCenterProject,
        ProjTransDate,
        'Week',
        Hours,
        HoursAbsence,
        HoursDirect,
        HoursIndirect,
        PayRollExpenseCode,
        ApprovalDate
    )
);
// Pass Collection to flow
ExportExcel.Run(
    JSON(
        CollectionWithAllRequiredColumns,
        JSONFormat.IgnoreUnsupportedTypes
    ),
    User().Email
);
Categories:
  • Verified answer
    vipuljain03 Profile Picture
    703 Super User 2026 Season 1 on at
     The issue seems to arise due to the mismatch or problem in filtering data in the second collection, particularly with the RecId field.
     
    Issue Analysis:
    • The in operator in Power Apps is case-sensitive. Ensure that the RecId field from Table2.SelectedItems.RecId and Sweden_News should be same.
    • You can add a temporary collection to see the matching results, check the value of DebugCollection:
      ClearCollect(
          DebugCollection,
          Filter(
              'Sweden_News',
              'RecId' in Table2.SelectedItems.RecId
          )
      );
       
    • If RecId is a GUID, then convert it explicitly:
      Filter(
          'Sweden_News',
          Text('RecId') in Table2.SelectedItems.'RecId'
      )
       
    • Ensure all the fields in the ShowColumns function exist and are correctly named.
    • Break down the logic into smaller steps to validate intermediate results.
    • To confirm if RecId is causing the issue, test with a static filter
      ClearCollect(
          CollectionWithAllRequiredColumns,
          ShowColumns(
              Filter(
                  'Sweden_News',
                  'RecId' = "SomeKnownRecIdValue"
              ),
              EmployeeName,
              EmployeeKey,
              ProjectName,
              CostCenterProject,
              ProjTransDate,
              'Week',
              Hours,
              HoursAbsence,
              HoursDirect,
              HoursIndirect,
              PayRollExpenseCode,
              ApprovalDate
          )
      );

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 188 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 120

Last 30 days Overall leaderboard