Formula write back to datasource?

[jsmith87]

Hi all, 

I have a formula in a label that calculates the distance between two postcodes, is it possible to amend this formula so once it's calculated the distance it records that in a column in my table called "Custom"

Formula in label:

BingMaps.GetRouteV3("Driving",Dropdown4_1.Selected.Region,end1.Text,{distanceUnit:"Mile"}).travelDistance

[Drrickryp]

@jsmith87

Patch(datasource, Defaults(datasource), {Custom: BingMaps.GetRouteV3("Driving",Dropdown4_1.Selected.Region,end1.Text,{distanceUnit:"Mile"}).travel Distance}) 

[jsmith87]

Hey, I've changed dropdown4_1 to start and end1 to end just to make it easier, unfortunately i got this error: 

[Drrickryp]

@jsmith87

Put it in a button's OnSelect property. 

[jsmith87]

sorry, i'm super new to this. So when i tried adding the bing code to a button before it took ages to bring up results. i have put in a button and given it this formula:

Custom is the column i want the result to go into. However i'm still getting an error on the button. Calc is the label i want to store in my table. The error on the button is unexpected curly close when expecting parenclose

i'm using a static excel as it allows more than 2000 rows (my table has 2500 rows) 

[Drrickryp]

@jsmith87

Put a ")" between Text and "}" 

[jsmith87]

Thanks! That's resolved that issue but because it's a static excel it wont let me write back, I'll change it to a table in onedrive and just use the first 2000 lines. 

Bit cheeky, but could you help with my next and hopefully final issue......

So Calc is the label with the bing formula which works out the distances between two postcodes, i want this distance to be patched back to my data source in the column "Custom"  i can then sort my gallery based on the column "Custom" to show contractors in ascending order.  

Any idea how i'd do that gallery control? currently it's 

Filter(Table9, Trade = Dropdown3.Selected.Trade) 

Dropdown three is the contractor trades

[Drrickryp · Accepted solution]

@jsmith87

Sort(Filter(Table9, Trade = Dropdown3.Selected.Trade), Custom, Ascending) 

[jsmith87]

Brilliant, thank you!

[Drrickryp]

@jsmith87

I suggest that you move your data to SharePoint. You will have much more flexibility.