Query SharePoint list and assign value to variable

[abu_has03]

Hello All,

I am trying to do the below.

v_name_category:Filter('Category list', CategoryCode = category.Text).category

Filtering Sharepoint list "Category list' and assining the value in category column to the variable. Category column has unique value, will return one value.

I am passing v_name_category variable to the nextscreen. When i am assigning the variable to textbox in next screen, i am getting error "The property expects Text values, but this rule produces incompatiable table values".

Thanks for your help !!

[Jeff_Thorpe · Accepted solution]

Try setting the variable using the first function with the filter. It should look something like this:

Set(v_name_category, First(Filter('Category list', CategoryCode = category.Text)).category)

Then you would just use v_name_category in your text box.

[abu_has03]

Thanks it works.