Repeating Letter Issues

Options
2»

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Cheena DeAraujoDesir
    your word doc tempalte is done correctly, with one exception: today's date. This is not going to update itself as you populate the word document from power automate, you will need to create another text field for TodayDate and populate it from power automate.

    next question is what do you mean by “grouping”. In the power automate flow, you are going to use list gift action to get a bunch of gifts desired, then loop through (apply to each) each gift and populate the word template with conditional information.

    • compose action(s) for each different intro paragraph and purpose paragraph
    • list gift
    • Apply to each gift
      • get constituent (using constituent id)
      • get constituent name format (for addressee/salutation)
      • populate word template
        populate the field as needed (i.e. FullName, AddressLines, TodayDate, etc)
        use if() expression to condition on what to populate for intro and purpose paragraph, for example:
        if(equals(letter_code,'abc'), outputs('Compose_Intro_Letter_ABC'), output('Compose_Intro_Letter_Other'))
  • Cheena DeAraujoDesir
    Cheena DeAraujoDesir
    Tenth Anniversary Kudos 1 Name Dropper Participant

    @Alex Wong
    I will update the date field. Thanks for pointing that out.

    As for the rest, 85% of that is created in the automate. Under App2Ea gift, the first 3 bullets are set, but under the second half of populate to word doc is where it gets funny. I don't have them set up this way with that particular expression. Let me go back under the hood. My expression was pulling each letter template like the one I showed you.

Categories