Hi all,
New to powerapps and having a bit of a nightmare with lists currently.. would really appreciate help.
I have a list called 'Risk Event Actions' where several actions are linked to the same ID number, which is pulled in via lookup from another sheet.
I'm trying to create a dropdown list in powerapps that pulls in the individual ID numbers, and then will filter a gallery to show the actions associated with that ID number.
So far I have a dropdown that has the formula Choices([@'Risk Actions Sheet'.'Risk ID') which seems to be successfully pulling through the individual IDs from the Risk actions sheet as Values.
Next I have a gallery which has a column labelled 'PulledinID' with the formula ThisItem. 'Risk ID', and then several other columns pulling info. The Dropdown is called 'ActionsFilter'.
In the gallery I've tried the formula Filter('Risk Actions Sheet',PulledinID=ActionsFilter.Selected.Value). And am now getting the error that control and text cant be compared.
I'd really appreciate some guidance on a gallery formula to make this work, or if I've missed something along the way to allow IDs to correctly pull in info?
