Hi I have a powerapp bringing in data about a task list from a sharepoint site. To do this, I am using a flow to populate tasks information of a task list. Shown below is the sample schema.
{
"type": "array",
"items": {
"type": "object",
"properties": {
"WebUrl": {
"type": "string"
},
"ParentReference": {
"type": "object",
"properties": {
"listId": {
"type": "string"
},
"siteId": {
"type": "string"
}
}
},
"Fields": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"@@odata.id": {
"type": "string"
},
"@@odata.etag": {
"type": "string"
},
"@@odata.editLink": {
"type": "string"
},
"Title": {
"type": "string"
},
"Predecessors": {
"type": "array"
},
"Priority": {
"type": "string"
},
"Status": {
"type": "string"
},
"PercentComplete": {
"type": "integer"
},
"AssignedTo": {
"type": "array",
"items": {
"type": "object",
"properties": {
"LookupId": {
"type": "integer"
},
"LookupValue": {
"type": "string"
},
"Email": {
"type": "string"
}
},
"required": [
"LookupId",
"LookupValue",
"Email"
]
}
},
"Body": {
"type": "string"
},
"StartDate": {
"type": "string"
},
"DueDate": {
"type": "string"
},
"Checkmark": {
"type": "string"
},
"n7m2LookupId": {
"type": "string"
},
"ID": {
"type": "integer"
},
"ContentType": {
"type": "string"
},
"Modified": {
"type": "string"
},
"Created": {
"type": "string"
},
"AuthorLookupId": {
"type": "string"
},
"EditorLookupId": {
"type": "string"
},
"_UIVersionString": {
"type": "string"
},
"Attachments": {
"type": "boolean"
},
"Edit": {
"type": "string"
},
"LinkTitleNoMenu": {
"type": "string"
},
"LinkTitle": {
"type": "string"
},
"ItemChildCount": {
"type": "string"
},
"FolderChildCount": {
"type": "string"
},
"_ComplianceFlags": {
"type": "string"
},
"_ComplianceTag": {
"type": "string"
},
"_ComplianceTagWrittenTime": {
"type": "string"
},
"_ComplianceTagUserId": {
"type": "string"
}
}
},
"FieldsArray": {
"type": "array",
"items": {
"type": "string"
}
},
"CreatedBy": {
"type": "object",
"properties": {
"user": {
"type": "object",
"properties": {
"email": {
"type": "string"
},
"id": {
"type": "string"
},
"displayName": {
"type": "string"
}
}
}
}
},
"LastModifiedBy": {
"type": "object",
"properties": {
"user": {
"type": "object",
"properties": {
"email": {
"type": "string"
},
"id": {
"type": "string"
},
"displayName": {
"type": "string"
}
}
}
}
},
"CreatedDateTime": {
"type": "string"
},
"Version": {
"type": "string"
},
"Name": {
"type": "string"
},
"SiteId": {
"type": "string"
},
"ListId": {
"type": "string"
},
"LastModifiedDateTime": {
"type": "string"
},
"Attachments": {
"type": "boolean"
},
"ContentType": {
"type": "string"
},
"Id": {
"type": "string"
},
"OdataNextLink": {},
"StartDate": {
"type": "string"
},
"DueDate": {
"type": "string"
},
"PercentComplete": {
"type": "integer"
}
},
"required": [
"WebUrl",
"ParentReference",
"Fields",
"FieldsArray",
"CreatedBy",
"LastModifiedBy",
"CreatedDateTime",
"Version",
"Name",
"SiteId",
"ListId",
"LastModifiedDateTime",
"Attachments",
"ContentType",
"Id",
"OdataNextLink",
"StartDate",
"DueDate",
"PercentComplete"
]
}
}
Unfortunately, the flow runs but only some of the values actually come through to the powerapp. shown below is the collection.
The most important values I need are "StartDate", "DueDate" and "PercentComplete" but I am unable to retrieve these from the flow.
What I tried
They are found under "fields" record so I tried to access them directly as you can see in my sample schema but I still cant access their values inside the powerapp collection. Any suggestions?
