Unanswered

Retrieving data from the Azure Table Storage

(0) Share

Report

Posted on by Community Power Pla...

I have been using power virtual agent and using power automate to insert the entities from the user input and storing to the azure table.

I managed to use "Insert Entity" and able to store the information into the table storage. Now I want to query the table and get the entities based on some condition.

i.e. getting FIRSTNAME, LASTNAME where PARTITIONKEY="nsw" and ROWKEY="bai001"

Went through lot of community discussions and documentation, I am getting errors. I am just using some dummy entities in my table but the real business logic is to display information of users based on some condition.

Here are my screenshots of the table data and the get entity . What I want is to get those values and store into some variables and return it to PVA. I tried many steps

Thank you.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

edguerre Microsoft Employee on at

Like (0)

Report

@Anonymous : what's the output of the first action card? Thanks!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sorry fro the delay reply @edguerre I was getting a message on the "Get Entity" action card indicating "Select query for the column to be returned as shown in the figure". And that is why i gave FIRSTNAME and LASTNAME as i made use of that fields to store the names as shown in the table storage. I am not sure if i can take input from the first action card or directly feed the FIRSTNAME and LASTNAME in the "GetEntity
action card itself.

Was this reply helpful? Yes No