You’re offline. This is a read only version of the page.
Am creating a simple flow to populate an excel file with the details of people that have access to a PowerApp. I want their email address, their roleName and the createdOn date.
Above image shows the flow structure and it works fine for Email and roleName and the excel file is updated correctly, so the Compose and Compose 2 steps work okay.
However, because createdOn doesn't appear as an option in the Get App Role Assignments list, I tried using a dynamic expression for Compose 3:
Share
Reportitems('Apply_to_each')?['properties/createdOn']
But saving throws this error:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Compose_3' are not defined in the template.'.'.
This is a copy of the first record of the JSON for the array so you can see the items:
So createdOn is there within the properties part, but for some reason I can't access it like I can others. I can even get the scope and the notifyShareTargetOption, but not the createdOn or createdBy.
Am I missing something here? Anyone explain how I can extract the createdOn date ?
Thanks
I'm an idiot !
I overlooked the correct name of the Apply_to_each step. In my example it should have been:
All responses (
Answers (
items('Apply_to_each_2')?['properties/createdOn'] and not
items('Apply_to_each')?['properties/createdOn']
Thanks for the help though 🙂
Hi @DaveMack
Pls try this:
items('Apply_to_each')?['properties']?['createdOn']
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Hi @DaveMack
Correction, Ofcourse it is within the properties so like @ManishSolanki mentioned use that. I clearly didn't looked into it. 😂
items('Apply_to_each')?[properties]?['createdOn']
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
