I am trying to create a flow that will allow me to move data in a collection from my app to an excel spreadsheet. I have 18 different data points that I need to track.
I was following the instructions from this post here. This says that I need to concatenate all the data from the collection into one string so that I can get it into flow, once it's into flow, then the flow will break it out into its separate components. I was going to do this by using this formula:
Clear(SubmitData); ForAll(InpatientCharges,Collect(SubmitData, {PatientName:PT_NAME.Text, PatientDOB:PT_DOB,PatientStatus:PT_STATUS_COMBO_BOX,RenderingProvider:RENDERING_PROV,TubalConsent:TUBAL_CONSENT,Facility:FACILITY,Transport:TRANSPORT,DateOfService:DATE_OF_SERVICE,GestationalAge:GEST_AGE.Text,Gravida:GRAVIDA.Text,Para:PARA.Text,AdditionalDiagnosisNotes:ADD_NOTES.Text,ReferringPhysician:REF_PROV.Text,ReferringPhysicianPhoneNumber:REF_PROV_PHONE.Text,CPTCodeSelection:CPT,ProcedureSelection:PROCEDURE,UltrasoundSelection:US,OtherSelection:OTHER_CODES}));Output.Run(Concat(SubmitData,PatientName &"#" & PatientDOB & "#" & PatientStatus & "#" & RenderingProvider & "#" & TubalConsent & "#" & Facility & "#" & Transport & "#" & DateOfService & "#" & GestationalAge & "#" & Gravida & "#" & Para & "#" & AdditionalDiagnosisNotes & "#" & ReferringPhysician & "#" & ReferringPhysicianPhoneNumber & "#" & CPTCodeSelection & "#" & ProcedureSelection & "#" & UltrasoundSelection & "#" & OtherSelection:OTHER_CODES)))
However; when I tried to run the formula the following error appeared over the button: "Invalid argument type. Expecting one of the following: Text, Number, Boolean." I don't know what I'm doing wrong. Please help.
