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.
