Extract one column data from a dataset in power automate flow

[PoorMens_Bravo]

Hi all,

I have a dataset in a workspace to which i have Member permissions. Now, i am creating a scheduled cloud flow in Power automate and then would want to get a columns data from this dataset, i am using the connector "Run a Query against a Dataset"(PowerBi), firstly is this correct?

And secondly, I am running this query to pull that column data, column name is userid:

DEFINE
Var userid = SUMMARIZECOLUMNS ("UserlD")
EVALUATE
userid

And I am getting Status Code 400 error:

"Query (2, 32) Column 'UserlD' added by the 'SUMMARIZECOLUMNS' function must have the scalar expression specified."

[PoorMens_Bravo]

Thank you very much @AlexisOlson that simply worked!!

[AlexisOlson · Accepted solution]

Try this:

EVALUATE
SUMMARIZECOLUMNS ( TableName[UserID] )