Editable table excel look gallery

(0) Share

Report

Posted on by AnoojDev513

Hi,

I have a problem which I am not able to solve for quite some time.

I have created a gallery editable table referring to the link: https://www.youtube.com/watch?v=mj4mKS1hS7M

But here I have a different scenario. I created a dropdown for Title, and when I select the title from dropdown, The gallery should display only the data with the title selected. And, I should be able to add/delete/edit the record for the selected Title and save it. And, If there is only Title field exits and remaining columns are empty in the SharePoint it should show the same and should be editable in the future.

The below screenshot showing up all the records from the data source (SharePoint) where I selected the “Test” in the dropdown.

Under the Title it is showing Test everywhere because I defaulted to display the dropdown selected value using Dropdown.SelectedText.Value on default.

For all other Role Description, DoITS Team, DoITS Role, Hours, I have given ThisItem.ColumnName on default.

It will be great help if someone can solve this for me.

Thank You!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@AnoojDev513

Please post the Items property for your gallery. Also do not use Dropdown.SelectedText.Value, Use Dropdown.Selected.Value instead.

Was this reply helpful? Yes No
AnoojDev513 9 on at

Like (0)

Report
Copy link

Link copied!

I have given the TableName under the Items for gallery

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@AnoojDev513

You need to filter it by the selection in your dropdown.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @AnoojDev513，

Have you solved your problem?

Do you want to filter the Gallery based on the Dropdown selected?

Could you please share more about your need?

The Drop down box will always display the first item within by default if you do not select any other item, to avoid this, you could set the AllowEmptySelection as true.

Set the Items of the Gallery as below:

If(!IsBlank(Dropdown1.Selected.Title),Filter(List,Title=Dropdown1.Selected.Title),List)

Note that I assume that you set the Dropdown Items with List.Title, if you set the Dropdown Items with other formula , please clarify it.

Was this reply helpful? Yes No
AnoojDev513 9 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response, I am able to filter it out successfully.

I used Filter(TableName, Title = Dropdown1.Selected.Result)

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AnoojDev513,

Glad that you have solved the problem.

Please mark the solution as answer.

Thanks for your co-operation.

Was this reply helpful? Yes No