Видео

Hi there! Here’s a fix for your issue that I’ve given to a couple people. I’ve been using this for a couple months since I’ve always had problems with it re-selecting when the screen loads. 1. In your OnSelect property, add this to the end of your current formula: UpdateContext({ctxTableFix: true});UpdateContext({ctxTableFix: false}) 2. In your table’s Items property, add this as one of your Filter function arguments: ctxTableFix = true || ctxTableFix = false || IsBlank(ctxTableFix) Doing these two things will create a context variable called ctxTableFix, and adding this to your filter will basically cause the table to force an update whenever you select a record (because ctxTableFix will change from either blank to true or false to true, then right back to false). Forcing that update will deselect the current record (which you won’t have seen since you’ve navigated away), and when you return back to the screen it should no longer have a record selected. Let me know if that works for you!

@PowerAppsGuy Hey there. thanks for the reply. I have already put this and has been working for me. But now when i have edited the app and republished, it some times takes couple of seconds to refresh the table with true/false, by that time i get redirected to forms screen. Very frustrating. I should have gone with gallery for production app but this table control was very interesting

Glad it was helpful! Thank you for commenting 🙏

You bet! Thanks for the support!

Glad you enjoyed, I hope you get to use it in an app!

I have not tested this in Model Driven Pages, but I can’t think of anything that would prevent this from working there! I’d say give it a shot!

@@PowerAppsGuy I shall indeed. Thanks for getting back.

Glad you liked it!

Glad you enjoyed! :)

You are so welcome! The next video will definitely be a fun one. :-) It’s unfortunate that we can’t use components like this inside galleries, but we’ll work around that as you are probably doing!

@@PowerAppsGuy That was exactly what I discovered. I am developing a safety app for employees. It will have a small overview section with some stats at the top, then I wanted to load random fluent tiles with dynamic data on them from a SharePoint list that contain application tips and safety tips. I didn't want to load them all and I wanted them to be random like real apps.

Hello! Glad you enjoyed the video. Sorry for the late response. You can indeed send a dynamic image to insert into the word template. You would need to add a placeholder to your Word document for where your image should be inserted (so something like {contosoImage} in your header and footer depending on the image from your Sharepoint list). You would then pass in the image data when you populated the Word template. You would add the following to the JSON that populates the template: contosoImage: { type: "image", source: JSON(<insert your image here>, JSONFormat.IncludeBinaryData), format: "image/png", width: <width in px>, height: <height in px> } Where I have "insert your image here", you would need to reference your image field from your Sharepoint list. If you're selecting something from a gallery or table, you might use something like Table.Selected.ImageField. I hope that helps!

Hello! There’s no select all option on the table yet when viewed in the desktop version. You can select one item, hold shift on your keyboard, then select another row lower in the table to select all the rows in between. With that in mind you can select the first row in the table, hold shift on your keyboard, then select the last row of the table to select all the rows at once. Hope that helps!

Hello there! I just tested this out and see the same issue you are having with a multi-select person column having the values disappear in the table control. One workaround I've just done is to do the following: In the items property of your table control, use the AddColumns function to add a new column containing the information you want to display from your person column. In this case we'll also use the Concat function to concatenate all the display names from our selected Persons. AddColumns(datasource, personDisplayName, Concat(ThisRecord.personColumn, DisplayName,", ")) In the above formula: datasource = your Sharepoint list personDisplayName = the name of your new column that you're adding with the AddColumns function. You can change this to whatever you like. ThisRecord.personColumn = this should be the column in your Sharepoint list that contains the multi-select person field. DisplayName = this is the field from the person column that you want to expose. In this case, I just wanted to show the display name of the person. After inputting this into your table items field, you'll then need to add the new column to your table to display it. This avoids having to create a calculated column in Sharepoint and does it all within the Power App. The selection features in the table should work properly with this method as well. Thanks!

@ Thank you for your prompt response. However, my issue was not displaying the multi-person column in my table. I managed to do that. My problem is that as soon as I change the Items property-such as using an AddColumns or something similar to display the column-my rows are no longer counted. So, when I select multiple items on the left, I can’t see how many rows were selected. The CountRows function for this table then no longer works.

There are many bugs still with the modern controls but they are fixing more and more every week. Hope you enjoyed the video!

Hey there, I unfortunately experience the same issue. This is being caused by a cell in the table being selected (which you can tell once you click on a row that the cell has a black border). There isn't currently a way to clear this while staying on the same screen. The only way I have found to fix this is to have something in your OnSelect property of the table that takes you away from the current screen. Think of something like selecting a row taking you to another screen to edit that row on a form. When you return back to your screen with the table, the cell should be unselected. This also has a side effect of triggering the OnSelect of the table when you navigate back to the table screen, so you'll need to add two lines of code to your table: 1. In your OnSelect property, add "UpdateContext({ctxTableFix: true}); UpdateContext({ctxTableFix: false})". This creates a context variable and sets it to true, then immediately sets it to false. You can put this after whatever action you take in your OnSelect property, so if you're navigating to a different screen you could put this after your navigate function. 2. In the Items property of your table, assuming you're using a filter function on a data source, you'll want to add the following as one of your filter function arguments: "ctxTableFix = true || ctxTableFix = false || IsBlank(ctxTableFix)" This will cause the table control to refresh itself when ctxTableFix changes in value, so basically it will unselect the row that you clicked on since it sees the value changing to true then back to false. This will stop the OnSelect function of the table from being triggered when you navigate back to the screen containing your table. I know that's a lot of hoops to jump through but I hope that helps!

@PowerAppsGuy not as crazy as ChatGPT though. It's workarounds for similar problems are using timers, it proposed timers for double click action on a row as well 😅 But thanks for looking into it. I'll try and describe the problem as well as I can to MS support. Same functionality in combination with the classic table does work as you'd expect it to.

@@svenmeyer2901 Glad you liked the video! Here’s a fix for your issue with the OnSelect property. I’ve been using this for a couple months since I’ve always had problems with it re-selecting when the screen loads. 1. In your OnSelect property, add this to the end of your current formula: UpdateContext({ctxTableFix: true});UpdateContext({ctxTableFix: false}) 2. In your table’s Items property, add this as one of your Filter function arguments: ctxTableFix = true || ctxTableFix = false || IsBlank(ctxTableFix) Doing these two things will create a context variable called ctxTableFix, and adding this to your filter will basically cause the table to force an update whenever you select a record (because ctxTableFix will change from either blank to true or false to true, then right back to false). Forcing that update will deselect the current record (which you won’t have seen since you’ve navigated away), and when you return back to the screen it should no longer have a record selected. Let me know if that works for you!

Hey there! You’ll need the format of the column in your data source to be currency. In this case it is a column in Dataverse set as currency. Keep in mind you introduce complexity using the currency column type, so I would almost recommend against utilizing it unless you have a specific use case.

Glad you enjoyed it!

Hey there! I've just uploaded a new video walking through this. It was added in an update this week, and I review some of the changes to the control that this update brought including the multi-select property. ruclips.net/video/E0SefPwLFuM/видео.html

@@PowerAppsGuy Thank you!