Timeline for How to set up data for cascading dropdown in SharePoint list without 1:1 filter criteria?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 24, 2022 at 16:24 | comment | added | Darryl | Thanks, Dylan. It looks like the only workaround I can find is to use Flow to retrieve the list of schools that offer the specified course and then put that into a multi-line text field (the values will be too long in some cases for a single-line text). I can then show that in the list; it won't dynamically filter the options for users, but it will at least give them an easy reference to know which ones are valid choices. | |
| Jan 21, 2022 at 18:44 | comment | added | Dylan Cristy | @Darryl unfortunately Power Automate/Flow will not really help you in this situation. Power Automate/Flow is useful to set up automatic processes that respond to triggers, such as when a new item is created in a SharePoint list, or when an item is updated, and you want something else to happen automatically. You can't really use it to customize forms. | |
| Jan 21, 2022 at 16:58 | comment | added | Darryl | Thank you, and I apologize - I discovered something after posting this but didn't get back to update it before you responded: I don't have access to Power Apps (organizational constraint), so need to find a way to make it work just with SharePoint and Power Automate. Do you know if there is still a way? Or, if I can't restrict what appears in my School dropdown field, can I use conditional formatting in one list to check another list? That way I could at least indicate if a selection was invalid after someone entered it. | |
| Jan 21, 2022 at 12:13 | history | answered | RuneBH | CC BY-SA 4.0 |