You’re offline. This is a read only version of the page.
Announcements
6
Hi all,
Currently trying to create a tracker for security badge access requests. When a new response is submitted (MSForms)>Get details (MSForms)>JSON(outputs for AddAccess column, etc)>JSON(outputs for RemoveAccess column, etc)>Create Item (Sharepoint List) with Outputs assigned to the multiple selection questions for Areas Added or Areas Removed.
My trouble comes because of a branching question in the form that either leads to the Add Access Column or the Remove Access Column (this is binary - can only be one or the other). When I run the flow, if I choose Add Access, the Remove Access JSON(...) throws a NULL error. If I choose Remove Access, the Remove Access JSON(...) throws a NULL error. One or the other is expecting an array and not getting it. Is there a way to solve this? I appreciate any help.
Hello @dormire01
I think the flow will do different things if you choose add or remove. So check for that value and if it goes left the one array will be usable and if it goes right the other array will be usable. If both does the same you could use coalesce with both arrays and will get the one that is not null.
Share
Report
All responses (
Answers (
