Unanswered

Get custom properties from Azure Table Storage using AzureTableStorage.GetEntities

(0) Share

Report

Posted on by panterra

207

I am creating a simple form that uses the Azure Table Storage as a data source. I have successfully connected to the Table in Azure Blob Storage.

Here is what the table looks like:

I would like to bind this table's Region property to the Drop Down List. I am able to use the AzureTableStorage.GetEntities function to return all values from the table and display the Row Key in the Drop Down List using this function.

Here is the formula I'm using for this: Formula: AzureTableStorage.GetEntities("DemoRegions", {NextPartitionKey:"R1"}).value

Does anyone know how I can show the values from the Region column / property instead?

PowerApps Formula and DDL.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

v-monli-msft on at

Like (0)

Report

Hi @panterra,

I will try to escalate your issue as I couldn't find any documentation on how Azure Table Storage works with PowerApps. If I got further information, will update here.

Regards,

Mona

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

Hi @panterra
The answer is simple and in your screenshot. You see there is a Value property just below Items?
Just change that from 'RowKey' to the column you want displayed.
Please let me know if this helps.

Was this reply helpful? Yes No
panterra 207 on at

Like (0)

Report
@Meneghino and @v-monli-msft

Thank you for your responses!

I am able to use the value property to change what is presented to me. However, the choices are limited. I am able to choose:

"Additional Properties"
"Partition Key"
"Row Key"
The custom properties I have added are not available for selection.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

If you added the properties after having added the data source to your app, then you may need to refresh the data source (from the list of sources in design mode) to show these properties.

Was this reply helpful? Yes No
Michael90 12 on at

Like (0)

Report

I am having the same issue. refreshing the connector didnt help. it was only possible to display the value of rowkey and particionkey did you find a solution?

Was this reply helpful? Yes No
tddrob 2 on at

Like (0)

Report

@Michael90 I have this same problem, but no easy solution. This connector isn't really usable if we can't get to the additional properties and I'm stuck exactly where you are.

I'm thinking about writing an Azure function that calls to Azure Table and returns it as JSON and then doing a custom connector from PowerApps side.

Was this reply helpful? Yes No
hf2 2 on at

Like (0)

Report

This issue is still not solved - i can not access custom columns in a Azure Table.
An other workaround is to use a flow. In a flow the custom properties are accessable.

Was this reply helpful? Yes No