Skip to main content

Notifications

Copilot Studio - General
Unanswered

Remove unwanted characters from list rows present in a table;

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:
  • adilei Profile Picture
    adilei on at
    Re: Remove unwanted characters from list rows present in a table;

    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.

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 137,998

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,059

Leaderboard