You’re offline. This is a read only version of the page.
26
buen día, soy nuevo en power automate, pero tengo que resolver el siguiente problema:
tengo un flujo que tiene una accion "obtener elementos" de una lista de sharepoint la cual me trae este contenido en su body/value......como puedo obtener las propiedades que hay dentro de la propiedad "materiaPrima"?y guardarlas para despues copiarlas en otra lista una por una:
muchas gracias por la ay
[
{
"@odata.etag": "\"3\"",
"ItemInternalId": "1",
"ID": 1,
"nombreReceta_x003A_referencia": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "PR2051-PP"
},
"nombreReceta_x003A_referencia#Id": 2,
"nombreReceta": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "VINAGRETA X LITRO"
},
"nombreReceta#Id": 2,
"materiaPrima": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 30,
"Value": "MP ACEITE POR LITROS"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 31,
"Value": "MP AZUCAR POR KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 32,
"Value": "MP CREMA LECHE POR LITROS"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 33,
"Value": "MP MAYONESA X KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 34,
"Value": "MP VINO BLANCO X LITRO"
}
],
"materiaPrima@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"materiaPrima#Id": [
30,
31,
32,
33,
34
],
"materiaPrima#Id@odata.type": "#Collection(Int64)",
"cantidadReceta": 1,
"cantidad_materiaPrima": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": -1,
"Value": "1.5"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": -1,
"Value": "2.0"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": -1,
"Value": "2.3"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": -1,
"Value": "4.1"
}
],
"cantidad_materiaPrima@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"cantidad_materiaPrima#Id": [
-1,
-1,
-1,
-1
],
"cantidad_materiaPrima#Id@odata.type": "#Collection(Int64)",
"Modified": "2023-11-29T14:18:52Z",
"Created": "2023-11-08T20:27:33Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|caperdomo@panaca.co",
"DisplayName": "Carlos Andres Perdomo Medina",
"Email": "caperdomo@panaca.co",
"Picture": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/UserPhoto.aspx?Size=L&AccountName=caperdomo@panaca.co",
"Department": "Sistemas",
"JobTitle": "Desarrollador"
},
"Author#Claims": "i:0#.f|membership|caperdomo@panaca.co",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|caperdomo@panaca.co",
"DisplayName": "Carlos Andres Perdomo Medina",
"Email": "caperdomo@panaca.co",
"Picture": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/UserPhoto.aspx?Size=L&AccountName=caperdomo@panaca.co",
"Department": "Sistemas",
"JobTitle": "Desarrollador"
},
"Editor#Claims": "i:0#.f|membership|caperdomo@panaca.co",
"{Identifier}": "Lists%252fbdOrdenesFabricacion%252f1_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/listform.aspx?PageType=4&ListId=2a02154c%2Dcc9d%2D448c%2D81e8%2D2e501c7266df&ID=1&ContentTypeID=0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"{Name}": "",
"{FilenameWithExtension}": "",
"{Path}": "Lists/bdOrdenesFabricacion/",
"{FullPath}": "Lists/bdOrdenesFabricacion/1_.000",
"{ContentType}": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
"Id": "0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"Name": "recetas"
},
"{ContentType}#Id": "0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"{HasAttachments}": false,
"{VersionNumber}": "3.0"
},
{
"@odata.etag": "\"1\"",
"ItemInternalId": "2",
"ID": 2,
"nombreReceta_x003A_referencia": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "PR2050-PP "
},
"nombreReceta_x003A_referencia#Id": 1,
"nombreReceta": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "ENSALADA PORCION"
},
"nombreReceta#Id": 1,
"materiaPrima": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 25,
"Value": "MP CEBOLLA DE HUEVO POR KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 26,
"Value": "MP CILANTRO POR KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 27,
"Value": "MP REPOLLO X KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 28,
"Value": "MP ZANAHORIA POR KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 29,
"Value": "PP VINAGRETA X LITRO"
}
],
"materiaPrima@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"materiaPrima#Id": [
25,
26,
27,
28,
29
],
"materiaPrima#Id@odata.type": "#Collection(Int64)",
"cantidadReceta": 4,
"cantidad_materiaPrima": [],
"cantidad_materiaPrima@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"cantidad_materiaPrima#Id": [],
"cantidad_materiaPrima#Id@odata.type": "#Collection(Int64)",
"Modified": "2023-11-09T14:58:04Z",
"Created": "2023-11-09T14:58:04Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|caperdomo@panaca.co",
"DisplayName": "Carlos Andres Perdomo Medina",
"Email": "caperdomo@panaca.co",
"Picture": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/UserPhoto.aspx?Size=L&AccountName=caperdomo@panaca.co",
"Department": "Sistemas",
"JobTitle": "Desarrollador"
},
"Author#Claims": "i:0#.f|membership|caperdomo@panaca.co",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|caperdomo@panaca.co",
"DisplayName": "Carlos Andres Perdomo Medina",
"Email": "caperdomo@panaca.co",
"Picture": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/UserPhoto.aspx?Size=L&AccountName=caperdomo@panaca.co",
"Department": "Sistemas",
"JobTitle": "Desarrollador"
},
"Editor#Claims": "i:0#.f|membership|caperdomo@panaca.co",
"{Identifier}": "Lists%252fbdOrdenesFabricacion%252f2_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/listform.aspx?PageType=4&ListId=2a02154c%2Dcc9d%2D448c%2D81e8%2D2e501c7266df&ID=2&ContentTypeID=0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"{Name}": "",
"{FilenameWithExtension}": "",
"{Path}": "Lists/bdOrdenesFabricacion/",
"{FullPath}": "Lists/bdOrdenesFabricacion/2_.000",
"{ContentType}": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
"Id": "0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"Name": "recetas"
},
"{ContentType}#Id": "0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
},
{
"@odata.etag": "\"1\"",
"ItemInternalId": "3",
"ID": 3,
"nombreReceta_x003A_referencia": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "PR2050-PP "
},
"nombreReceta_x003A_referencia#Id": 1,
"nombreReceta": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "ENSALADA PORCION"
},
"nombreReceta#Id": 1,
"materiaPrima": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 34,
"Value": "MP VINO BLANCO X LITRO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 30,
"Value": "MP ACEITE POR LITROS"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 33,
"Value": "MP MAYONESA X KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 31,
"Value": "MP AZUCAR POR KILO"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 32,
"Value": "MP CREMA LECHE POR LITROS"
}
],
"materiaPrima@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"materiaPrima#Id": [
34,
30,
33,
31,
32
],
"materiaPrima#Id@odata.type": "#Collection(Int64)",
"cantidadReceta": 3,
"cantidad_materiaPrima": [],
"cantidad_materiaPrima@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"cantidad_materiaPrima#Id": [],
"cantidad_materiaPrima#Id@odata.type": "#Collection(Int64)",
"Modified": "2023-11-28T19:39:25Z",
"Created": "2023-11-28T19:39:25Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|caperdomo@panaca.co",
"DisplayName": "Carlos Andres Perdomo Medina",
"Email": "caperdomo@panaca.co",
"Picture": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/UserPhoto.aspx?Size=L&AccountName=caperdomo@panaca.co",
"Department": "Sistemas",
"JobTitle": "Desarrollador"
},
"Author#Claims": "i:0#.f|membership|caperdomo@panaca.co",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|caperdomo@panaca.co",
"DisplayName": "Carlos Andres Perdomo Medina",
"Email": "caperdomo@panaca.co",
"Picture": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/UserPhoto.aspx?Size=L&AccountName=caperdomo@panaca.co",
"Department": "Sistemas",
"JobTitle": "Desarrollador"
},
"Editor#Claims": "i:0#.f|membership|caperdomo@panaca.co",
"{Identifier}": "Lists%252fbdOrdenesFabricacion%252f3_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https://panaca.sharepoint.com/sites/sopeseProduccion/_layouts/15/listform.aspx?PageType=4&ListId=2a02154c%2Dcc9d%2D448c%2D81e8%2D2e501c7266df&ID=3&ContentTypeID=0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"{Name}": "",
"{FilenameWithExtension}": "",
"{Path}": "Lists/bdOrdenesFabricacion/",
"{FullPath}": "Lists/bdOrdenesFabricacion/3_.000",
"{ContentType}": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
"Id": "0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"Name": "recetas"
},
"{ContentType}#Id": "0x0100F54C8D07F93A69439DB4B77231FAF95300FD7B25434468944D80EB28CD00E40AA2",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
}
]
Share
Report
All responses (
Answers (
