Manage subscription list using a Form

Like (0) Share

Report

Posted on 1 Aug 2023 18:40:30 by mnc2023

Hi,

A complete novice building my first flow and stuck already. Somebody must have done this before as it's so simple, but I can't figure it out.

I want my users to be able to subscribe / unsubscribe via one Form (with just that one question). This will update a SharePoint list that records the user email and whether Unsubscribe is true or false. Then the flow should send a different email to the user depending on whether they are subscribing (new) / re-subscribing / unsubscribing / not found (but they wanted to unsubscribe anyway). So basically the flow somehow needs to:

1) get the response from the Form (I started with this trigger :-D)

2) get the items from the SharePoint list

3) check if the email address is already in the list

4) create a new item in SharePoint or update the item with the subscribe response

5) send an email based on all of the above

If anyone can point me in the right direction to achieve this I would be very grateful.

Thank you

I have the same question (0)

All responses (6)

Answers (1)

mnc2023 47 on 03 Aug 2023 at 13:49:45

Like (0)

Report

Re: Manage subscription list using a Form

I know what I did wrong now! In case it helps someone else, this is what my flow looks like:

Was this reply helpful? Yes No
mnc2023 47 on 03 Aug 2023 at 11:06:58

Like (0)

Report

Re: Manage subscription list using a Form

@SudeepGhatakNZ I have been trying to get this to work, but running into the same problem that there is 'Apply to each' automatically created which adds confusion and the Get Items step does not filter in the way that you have shown and returns an Invalid error. My SharePoint list has only two columns: Title (email) and Unsubscribed (True or False as string). Any idea what I'm doing wrong?

Was this reply helpful? Yes No
mnc2023 47 on 03 Aug 2023 at 09:13:47

Like (0)

Report

Re: Manage subscription list using a Form

@SudeepGhatakNZ Thank you very much for your suggestion. I'll base my further experiments on this.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,381 Most Valuable Professional on 02 Aug 2023 at 23:53:29

Like (1)

Report

Re: Manage subscription list using a Form

You can just add a switch case under your Create item that sends an email based on the Subscription type

Was this reply helpful? Yes No
mnc2023 47 on 02 Aug 2023 at 08:37:48

Like (0)

Report

Re: Manage subscription list using a Form

Thank you @SudeepGhatakNZ for your swift reply. This is an important step forward!

What's missing is that there are actually 4 different emails I want the flow to send for these scenarios:
1) Subscribed - Completely new user (that's easy, send email comes straight after Create item)
2) Unsubscribed - user email present in the list, Unsubscribed column status is being changed from false to true
3) Re-subscribed - user email present in the list as has previously unsubscribed, (so Unsubscribed column status is being changed from true to false)
4) Not found - user email NOT present in the list, but form response is to Unsubscribe so user may have made a error

How would you suggest I introduce the additional conditions to account for all these scenarios?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on 02 Aug 2023 at 01:54:59

Like (0)

Report

Re: Manage subscription list using a Form

@mnc2023 ,

This should be the overall structure

Please note that I am using a Filter in Get Items action to filter out only the record that belongs to the user filling the form.

If record is found, update the record otherwise create an item.

Hope it helps!

Was this reply helpful? Yes No