Share
Report
31Hello all,
I'm hoping someone can help me / point me in the right direction with this, I've been struggling for a while on it now and cannot find any real solution online (that works) despite my assumption that this would be a straight forward task.
The Scenario
Each week, I receive the current list of stores active in my organisation (around 800 at any one time) in Excel format. Each row of this Excel is a single store, with columns of data about that store (name, unique store ID, the address of the store, the address of the business that owns the store (can be different to the address of the actual store), etc.)
I have an extensive set of flows that then read in the Excel data, take each store and look at the data in each column for that store, do some text clean-up (removing unwanted characters, capitalising the first letter of each word in some cases, removing extra spaces, converting dates to correct format, etc.)
The "Transform" actions I perform are done through Child Flows, which then return a "cleaned / cleansed" version of the text back to the main flow.
The Goal / Current Challenge
My idea is to encapsulate all the cleaned-up data coming back from each of the Child flows into a JSON object, with nested JSON objects inside it to structure the data in a single Object variable.
My problem is I cannot seem to set data for nested values.
I get various errors and / or unexpected outcomes.
My Test Flow
Because the actual JSON Object is somewhat larger, I have created a test flow (below) to simulate the issue.
Step 1 -I'm triggering the test flow manually, then Initializing an Object variable:
The structure of the Object is as follows. It has 3 nested objects (People, Store and Business):
Step 2 - Set the value of the Street Address for the store in a compose action. I got this method / approach from researching my issue online (set the value in a compose action then set the variable to the outputs of the compose (Step 3):
The Expression used in the above Compose is as follows:
This all runs fine and gives the following result:
The Compose action seems to only provide the output of the Store nested object, so I am assuming it has placed it in the correct fields in the object and inside the Store sub-object?:
Looks a bit confusing, as I would have expected the whole object to be shown with only the values updated as being changed, something like the following:
produces this error, saying the "Business" property doesn't exist:
Unable to process template language expressions in action 'Set_the_value_of_the_Business_address_property' inputs at line '0' and column '0': 'The template language expression 'setProperty(variables('IncomingStore')['Business'],'BizStreet_Address','123 Some Other Street')' cannot be evaluated because property 'Business' doesn't exist, available properties are 'Name, Street_Address'. Please see https://aka.ms/logicexpressions for usage details.'.
All responses (
Answers (
