Forum Discussion
Solved
Extract one column data from a dataset in power automate flow
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."
Try this:
EVALUATE SUMMARIZECOLUMNS ( TableName[UserID] )
2 Replies
- AlexisOlson
Super User
Try this:
EVALUATE SUMMARIZECOLUMNS ( TableName[UserID] ) Thank you very much AlexisOlson that simply worked!!
