HI,
- I have a flow with a Sharepoint get items step. This step name is Shot1Missing
- I successfully filtered the population using "Active eq 1 and Shot1Received eq null"
- Next, I update the sharepoint list item to flag that record to indicate the Teammate needs Shot1
- I will repeat these steps above in the flow for Critical shots, to include shot 2 and the booster , shot 3 , so I want a count of each shot type required
- I will send a formatted HTML table via Sendmail v2 to the office staff to follow up. In this email, I want to have each table in different parts of the email , with a COUNT of each shot type missing in that table header
I have not been able to solve this expression error:
I create a compose step and opened the Expression tab to create this count step.
- Using an example I found online, I copied and pasted his example into the compose as an expression - "@length(body('Get_items')?['value'])"
- I changed Get_items to my specific get items step name above of Shot1Missing "@length(body('Shot1Missing')?['value'])" Expression invalid error received
- I tried building the expression manually: First, using the expression tab, I types @length , added an opening Paren, switched to Dynamic, selected the Shot1Missing value from the list of items, and the expression builder added this: "@length(outputs('Shot1Missing')?['value'])" Expression invalid error received, and cannot see the issue. Saved, quit out, tried again, same error.
What am I missing? Thanks
