You’re offline. This is a read only version of the page.
Announcements
89
Hello all,
I have reached to a stage where I store to a Text Column in SharePoint a compact JSON by using patch:
Patch('Purchase Requisition',{PRDetails1:JSON(colSubmit,JSONFormat.Compact)});
In the Text Column is stored text like the Below:
[{"ColumnType":"Text","Data":"16/02/2023","Required":{"Value":"No"},"Title":"Item Description"},{"Choices":"N/A","ColumnType":"Text","Data":"1abc","Required":{"Value":"No"},"Title":"GL Code"},{"Choices":"N/A","ColumnType":"Number","Data":"15","Required":{"Value":"No"},"Title":"Quantity"},{"Choices":"Each;Pack;Days;Kg;Meters;Liters","ColumnType":"Choice","Data":"Each","Required":{"Value":"No"},"Title":"UOM"},{"Choices":"N/A","ColumnType":"Number","Data":"50","Required":{"Value":"No"},"Title":"Unit Price (VAT exc)"},{"Choices":"N/A","ColumnType":"Number","Data":"650","Required":{"Value":"No"},"Title":"Total Price (VAT exc)"}]
The only variables are the texts after "Data":
How can I extract from this text (in a dynamic way) a collection which will have as columns: "Title" & "Data" and in rows their values.
For example based on the text I need:
| Title | Data |
| Item Description | 16/02/2023 |
| GL Code | 1abc |
| Quantity | 15 |
| UOM | Each |
| Unit Price (VAT exc) | 50 |
| Total Price (VAT exc) | 650 |
Share
Report
All responses (
Answers (
