Formula write back to datasource?

(0) Share

Report

Posted on by jsmith87

297

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

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jsmith87

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

Like
a
(0)

Report
Copy link

Link copied!

Hey, I've changed dropdown4_1 to start and end1 to end just to make it easier, unfortunately i got this error:
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jsmith87

Put it in a button's OnSelect property.
jsmith87 297 on at

Like
a
(0)

Report
Copy link

Link copied!

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 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jsmith87

Put a ")" between Text and "}"
jsmith87 297 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@jsmith87

Sort(Filter(Table9, Trade = Dropdown3.Selected.Trade), Custom, Ascending)
jsmith87 297 on at

Like
a
(0)

Report
Copy link

Link copied!

Brilliant, thank you!
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jsmith87

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