
Announcements
Hello,
Is there a way to clean the following output from "List rows present in a table"?
{“body”:[{“@odata.etag”:“”,“ItemInternalId”:“62f3089a-90d8-4181-89cf-b24fffb36735”,“groups”:“xxxxxx”,“quantity”:“67”,“name”:“xxxxx”,“group_type”:“xxxxxx”}]}
The output that goes to the end user, should only have the following data:
groups: xxxxxx
quantity: 67
name: xxxxx
group_type: xxxxxx
Any help would be appreciated.
Best Regards,
Gabriel.
1. Use "parse value" on the payload coming back from Dataverse
2. In the following node, use "Set variable value" with a PowerFx ForAll function that will build a new table, specifying only the fields you need.
The basic technique is demonstrated here starting about 10 minutes in.