Unanswered

Dropdown action for Task List

(0) Share

Report

Posted on by Dongle12

Hey guys!

I am working on a Task list for an upcoming project and need some assistance. I need the Drop down list to show "Yes, No" as options, default being No once you change it to Yes i would like the record to vanish (NOT deleted from sharepoint data base).

The run down:

I have a form the uppers fill out, at the end of the form they check a box that states the customer is "waiting". In my screenshot you can see in the sharepoint i have it under a "yes/no" category. I have another one called "Customer checked in" also a "yes/no" category. Im wondering if there is a way in the app where i can make it so when the customer gets checked in (by selecting yes in the dropdown) that record in the app vanishes and the next in line people get moved up the list. I have a screenshot of the code I have in the dropbox at the moment, however i am getting a delegation error and the "Yes,No" is not appearing in my preview. Please Help!!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Dongle12 ,

First, you need to set Items of Dropdown3 as below and make Yes/No as choices:

["Yes","No"]

Second, set Default of the Dropdown to the current item value:

If(ThisItem.'Customer checked in',"Yes","No")

Third, if you want to update the SharePoint list item when selecting "Yes" in the Dropdown, set OnChanage to

Patch('TCC Event 1', ThisItem, {'Customer checked in': Dropdown3.Selected.Value = "Yes"})

To hide the item from the Gallery, you need to filter the Items of Gallery:

Filter('TCC Event 1', !'Customer checked in')

Best regards,

Was this reply helpful? Yes No
Dongle12 38 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

Hey Jeff,

Thank you in advance!, This works! however the Item does not hide when changing to "Yes". Did I add the filter code correctly?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Dongle12 ,

It seems you are using the Filter function in a wrong place. Please move it to Items of the Gallery.

Best regards,

Was this reply helpful? Yes No
Dongle12 38 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

I went ahead and moved filter function out of the on select and into my gallery item, but now my data wont populate, any ideas? shows "The FILTER part of this formula might not work correctly on large data sets. I only have 5 inputs on my list and only expect to have max of 20 at a time.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dongle12 ,

The issue is you have two parallel Filter functions within a single SortByColumns function, it's incorrect. You can combine them into one:

SortByColumns(Filter('TCC Event 1', !'Customer checked in' && StartsWith(...)), SortColumns, If(...))

or nested:

SortByColumns(Filter(Filter('TCC Event 1', StartsWith(...)), !'Customer checked in' ), SortColumns, If(...))

Best regards,

Was this reply helpful? Yes No