PowerApps: how to display real value from table in Canvas app
I'm working with my first Canvas App to display filtered data from Dataverse table. I decided to go with Canvas tape as I need to add more functionality to this view.
Can see on the pic my structure, in real Current Cases table I have human readable text for Contact and Supervisor, but here I have their IDs, tried to play with format, removing *id portion, wrap it around Text, nothing helped.
Is this a bug? How I can solve this problem. This is canvas app with DataTable which I connected to Dataverse table.
ALso is it possible to create dynamic Filter on Modified On column, to display only rows where modified ON older then 14 days, or any filter at all ?
Thanks
added sample of raw data
The data table control allows you to choose exactly which property of the related entity you want to display, so for the 'Contact_Column1' column, you can update the expression to something like ThisItem.Contact.'Full Name' (or some other column which has the data you want displayed).
If you want to use the modern table control, it will automatically pick the primary key column from the related table, so it will show something more meaningful than a GUID. Notice that that control is still in preview.
As far as filtering the table, you can update the Items property of the data table itself with a Filter expression - for example Filter('Current Cases', 'Modified On' < DateAdd(Today(), -14, TimeUnit.Days)) - where 'Current Cases' would be the name of your table.
- PowerApps: how to display real value from table in Canvas app
- How to report on PowerApps dataverse metadata ? Is this possible
- Update the form field when button clicked in powerapps
- Power Apps Component - Table Property Issue
- Power Apps how to create a Nested Collection from multiple SharePoint Lists then create a nested JSON Collection
- I want to add an action for pressing the Enter key (the same as for the button), in powerapps
- Power apps modern controls combobox show a specific field
- Have 2 sets of colors used within a Title Formula
- How to use a Global Variable within an Object
- Connecting Microsoft Partner Center to Microsoft Power Apps Using A Custom Build API
- Can a Custom Connector work with a client_credentials grant flow?
- Is it possible to show ribbon button on home grid based on the result of async operation?
- How to use Global Variable in Cloud Flow in Power Apps
- Powerapps - Make a single field editable and all fields viewable in a Form
- SetFocus on unfilled fields in form
- How to clear a Text Input in Powerapp?
- PowerApps - Email not being sent on button submission
- PowerApps - Obtain DisplayName
- How can I create a visually distinct double border around focused input controls in a PowerApps canvas app?
- Rest API calls with PowerApps
- Calling a custom action from power apps component
- How do I update a duplicate entries in Powerapps
- Power Apps: Collection passed through JSON function dropping columns with null values
- Navigate to another screen based on the dropdown item in Powerapps - Formula not working
- Edit model driven app web resource (jscript) with visual studio
- Power apps cannot use barcode scanner function
- Business Central AL enum returning Unicode
- PowerApps: Format Table to JSON
- Powerapps: ClearCollect() is not showing all columns filled from Dataverse and showing with schematic name and not real col-header
- Can Microsoft PowerApps create public facing apps