Hello guys,
I have a question. I'm trying to do this https://www.netwoven.com/2020/11/03/set-item-level-permission-in-sharepoint-list-using-power-automat... but I facing some errors on step5
ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON_2')?['properties']?['d']?['properties']?['Last']?['properties']?['results']' is of type 'Null'. The result must be a valid array.
Do you have any suggestions. Sorry I'm newbie.
Many Thanks
Hi @Bold
Check your flow run history and see what its returned. Looks like you have got no results for body('Parse_JSON_2')?['properties']?['d']?['properties']?['Last']?['properties']?['results']
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi abm!
Thank you for your reply.
1st of all I'm not really sure that I parsed JSON correctly.
2nd I checked the raw outputs and seeing this
Hi @Bold
Copy the above JSON Data and generate the Parse JSON Schema. Let me know how it goes?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHello Abm,
User | Count |
---|---|
102 | |
39 | |
29 | |
24 | |
16 |
User | Count |
---|---|
132 | |
52 | |
51 | |
37 | |
26 |