web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Remove unwanted charac...
Copilot Studio
Unanswered

Remove unwanted characters from list rows present in a table;

(0) ShareShare
ReportReport
Posted on by 6

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.

Categories:
I have the same question (0)
  • adilei Profile Picture
    on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 261 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 198 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 93 Moderator

Last 30 days Overall leaderboard