I have run into a road block and cannot figure the next step out. Help please.
I am trying to concat the filter data (only 1 record) into a Text field within PowerApps
I have a sharepoint list called MySharepointData, which searches for text ("searchtext") in a dropdown ("MyDropdown") and then outputs the column "Notes" that contains a single line text. All of that works and I get my result correctly.
THIS WORKS:
Text = Fx
Concat(
Filter(
'MySharepointData',
"searchtext" in MyDropdown.Value)
),
Notes {remember that Notes is a single line of data and works fine}
)
However,
I cannot seem to find the code that allows me to output the data when I use a dropdown field (only one choice allowed) in place of my single line text field.
Because the filter I know works by itself, I know that concat is the problem and I have tried changing the orange text below:
Text = Fx
Concat(
Filter(
'MySharepointData',
"searchtext" in MyDropdown.Value)
),
AnotherDropdown.Selected.Value or AnotherDropdown.Value or 'AnotherDropdown'.Selected.Value or various other variations
)
Can anyone help me to solve the red text please. What coding should I use?
Cheers Ken
