I apologize for the long thread in advance!!!😂
I have a strange situation with a Power Automate and I am hoping someone might see where I am going wrong with it. I will do my best to explain, provide some pictures, and can provide more details for any questions.
I have a Sharepoint list that has a variety of fields, but only a couple control the Workflow. Here are the fields and their types:
Status - Single line of text
BU Approver Check - Yes/No (Toggle)
Finance Approver Check - Yes/No (Toggle)
Controller Approver Check - Yes/No (Toggle)
ApproverCnt_Ref - Single line of text
I have a Power App that ensures each field above gets the necessary information for the workflow.
Now here is the flow:
Steps 1 & 2
At Step 3 I have a Switch which checks the "ApproverCnt_Ref" field for a number from 1 to 3.
Based on the number stored in that field, it takes action to Start and wait for an approval. The count in that field is based on the 3 toggles noted above. The Power App does a count of them and stores that number in 2 different fields. One is actually a Number field which did not play nice with this Switch since they are stored as "Floats" and for some reason the int() function would not work to convert them. So to work around it, I adjusted my Power App to store the number as text in the Single line of text field as well and it seems to work. Here is where the problem comes in.
See figures 1&2 below as a reference. It gets past step 2, goes to the switch in step 3 and correctly hits Case 1 in my testing, and then bombs when it tries to work the Approval process.
So here are important points.
- This is in a new Environment in my Power Platform and Approvals have not been provisioned. The first run of this flow should provision it.
- I exported the flow and took it to my Default Environment where Approvals are provisioned and have run just fine in the past, but I still get the same errors.
Now, I also tried running this flow with a 2 approver count and something different happened which was strange as well. Use the below images as a point of reference as well. In the first image, you can see the input and I have the three toggles. So in the second image you will see Case 2 where I have a condition testing specifically for what two toggles are set as "True" at the same time. In screen number 3 you see the test run and it shows "No inputs" for the condition.
