Hello,
I'm new to writing Expressions in flow and am trying to use an if statement to populate data in a list item.
Using Microsoft Forms, I collect the following data:
- Funding Source 1 Name - Text
- Funding Source 1 Speedchart - Text
- Funding Source 1 % - Number
- Funding Source 1 State or Federal - Radio choice of State or Federal
If Federal is selected, the following information is also collected
- Funding Source 1 Activities Justification - Text
- Funding Source 1 Time and Effort Justification - Text
- Funding Source 1 Grant Manager Email - Email
This data is replicated for up to 3 potential funding sources.
I have a Flow that when this form is submitted, a new item is created in a List
I have a separate, approval flow that starts when a new item is added in that List.
Once approvals are completed and statuses updated, this data is used to populate other forms.
When flowing from the form to the list, I pipe in all that data as it stands and it maps pretty cleanly 1:1. However, I also need to (when applicable) feed the federal data to a second set of fields (that aren't on the form) like Federal Source 1 Name, Federal Source 1 Speedchart etc. etc.
If a user lists 3 funding sources on a form and all are state, these fields won't be needed in the list item. If the first two funding sources are state and the third is federal, then all the fields related to the 3rd source also need to become the data for all the federal source 1 fields.
I'm basically trying to write an expression to fill in the data of Federal Source 1 Name that says "If Funding Source 1 State or Federal = Federal, fill this with Funding Source 1 Name, else leave blank." I just don't know the syntax of how to do this at all. Can anyone assist?
Thank you!
