I'm building Canvas app and my data source is SharePoint list.
In my SharePoint list, I have column named "CartItems" and I would like to store collection data as JSON format.
With button, I wrote:
Patch('Datasource',{ID:ID},
{Title:MyItems,
MyFavoriteItems:JSON(colMyFavoriteItems,JSONFormat.IndentFour)
}
)
As a result , I have below data in column named "CartItems".
[
{
"ID": 8,
"ItemCategory": "DRINK",
"ItemLinkURL": "https://hogehoge.com",
"ItemPictureURL": "https://picturexxxxxxxxxxxx.jpg",
"ItemCode": "4987035332602",
"MinimumOrderUnit": 1,
"RegularPrice": 3108,
"ShowHide": true,
"Title": "Coke 500ml"
}
]
Then I placed one more button to parse this JSON into collection to show them to the gallery.
ClearCollect(colMyFavoriteItems,
MatchAll(CartItems,"(""ID"":(?<ID>[^""]*),""ItemCategory"":""(?<ItemCategory>[^""]*)"",""ItemLinkURL"":""(?<ItemLinkURL>[^""]*)"",""ItemPictureURL"":""(?<ItemPictureURL>[^""]*)"",""ItemCode"":""(?<ItemCode>[^""]*)"",""MinimumOrderUnit"":""(?<MinimumOrderUnit>[^""]*)"",""RegularPrice"":(?<RegularPrice>[^""]*))"))
but doesn't have any results....
(above is some part of schema)
I'm learning this with this great video https://www.youtube.com/watch?v=M2033jUWqRY&t=1170s
Could someone know what is missing with my code.
Thanks.
@DeepakS this is your video they are referencing, could you help them out?
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
180 | |
52 | |
41 | |
38 | |
28 |
User | Count |
---|---|
255 | |
81 | |
71 | |
68 | |
66 |