Dropdown Choice with an Automatic Reduction of Choices

[poweljj]

Hello,

I am trying to create a safety audit app for my factory that has 10 different work areas. What I would like to do is have a list of the 10 work areas that users can select to audit from a dropdown... easy enough so far.

What I would also like, is that as users complete audits, the list of the 10 different work areas decreases automatically. So that after six work areas have been audited, only four choices are left in the dropdown.

Lastly I would like the app/list to reset at the beginning of a new month.

Has anyone tried anything like this and could offer me some guidance? Thank you!

[TheRobRush]

Make yourself a SharePoint list called checklist or something similar that you like.

In it have two columns. Title, and LastChecked. Title Will Just be exact same text as the 10 items you will check off monthly. LastChecked columns will be a number column, 0 decimal places.

In your app your dropdown will have a be a filter of this list. FIlter(CheckList, LastChecked<>Month(Today())) which will give you a list of any item that doesn't have the month number of today in its lastchecked column. When you submit an audit, you will also write back to this list to update last checked column to Month(Today())

[poweljj]

Thanks @TheRobRush ,

I understand your solution. how do you accomplish the last part though, "When you submit an audit, you will also write back to this list to update last checked column to Month(Today())"???

Thanks!

[TheRobRush]

Patch(ListName, ColumnName=ThisItem.ColumnName, ColumnDate:Month(Today())))

something like that, but with your column names and such put in place. If you cannot get it to work let me know and i will try and make a example in a working app

[poweljj]

Alright, I think I am very close. My LastChecked column in my sharepoint list is set to be a number with zero decimal places, but I am getting an incompatible type error.

Thank you for the assistance @TheRobRush !!!

[TheRobRush]

Sorry, try this instead, was just typing off the cuff without testing

Patch('Std. Work Audit Schedule', ThisItem, {LastChecked:Month(Today())})

[poweljj]

@TheRobRush , still getting some errors. Please excuse my newness, trying to learn though!

[TheRobRush]

This code shouldn't be on the items of a data card, the patch code i gave you should go on the submit button. Items should be the options for that card, and the update value shown in other screenshot should just be set to the column needed to update for that card. Patches etc. go in the submit button, or onsuccess, depending on what you want running when

[poweljj]

Alright @TheRobRush , tell me if this all looks correct:

update of my data card:

Items of the dropdown are my audit areas/title from my sharepoint list:

Patch statement put in the OnSelect of my submit button:

[TheRobRush]

No, UpdateIf can be removed, your update section should have what column that control card should update. Add a generic form and connect it to just whatever datasource, then look at what it defaults to to get what it is supposed to look like. And for your patch, need to click in formula bar and find out which part of it is coming up as name not valid. If it is the lastcheck portion, you need to be sure to add that column to your splist, and then remove and readd the datasource in powerapps so it properly refreshes its column and name layout (don't have to remove/readd it but powerapps is weird sometimes and misses structural changes made on lists, so just easier to do it)