0

We have a requirement to update the content in the JSON Stored as multiline text column in one of the list, when one of the item in the another list is updated we need to update the JSON data stored in the item of the source list.

here is the sample json

    [
{
ClientStoryId:
ClientStoryName:
AssetID:
AssetName:
UserName:
UserEmail:
UserID:
}
{
ClientStoryId:
ClientStoryName:
AssetID:
AssetName:
UserName:
UserEmail:
UserID:
}
{
ClientStoryId:
ClientStoryName:
AssetID:
AssetName:
UserName:
UserEmail:
UserID:
}
]

When a user gets added to the Users List with client story and assetName we need to appropriately update the userdetails in the JSON which will be stored as multiline of text in another list.

Kindly help me.

1
  • In the destination JSON list, are you storing all the users' details in a single item (combined into a single JSON) or storing each user's details in its own item (each user in separate JSON)? Jan 8, 2021 at 16:40

1 Answer 1

0

Please see the screenshots and explanation below. In the example, the source list is UserStory and the destination list is UserStoryJSON, which is linked with the source list [ID] on [UserStoryId]

enter image description here

Detail 1

enter image description here

Detail 2

enter image description here

Detail 3

enter image description here

Expressions 1 & 2

length(outputs('Get_items_-_UserStoryJSON_List')?['body/value'])

first(outputs('Get_items_-_UserStoryJSON_List')?['body/value'])?['ID']

Output of Source and Destination Lists

enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.