Power Platform Community Forum Thread Details

Unsaved changes triggering a flow

I'm a novice PAer with a very, very simple flow, and yet...

Two steps - The trigger: When an item or file is modified; the action: Send an email to the person who originated the item.

A person completes a Form in their Teams channel, and in another flow, responses from this flow populate various fields to create an item in a List. Then, I create the PDF of a report which (among other things) includes the data from these fields, and upload it to a Sharepoint folder of these reports. Then, a link to this PDF as well as the name of this linked report are added to two other fields in this item's List line. For now, these two fields are manually populated using 'Edit in Grid View' - to try to avoid triggering the same notification email twice (once after each field is added), since the List apparently requires me to 'Save' my changes to this item. But, it doesn't wait for me to Save; it sends the notification email of the unsaved first modification to the originator of the item (letting them know that the report based on their item is now complete and ready for viewing in their Teams channel) before I can add and save the second modification I've made to the same item. So, unsaved changes are accepted by PA as gospel. How do I solve this? Furthermore, if I were to realize that my work was incorrect and I hit Cancel instead of Save, it will have already sent these unsaved incorrect changes.

Hello,

Business related question: how many times during the whole process you expect a certain item to be modified?

If the answer is that only after you upload the link and the name of the file should be triggered than i would say:

after the trigger you implement a "Get Changes for an item or file"
check if the last column you modify in the manual process - let's assume it's the name of the pdf, - you check if "PDF Name" has changed since "Modified". Usually the answer should be "no" for the unsaved changes until you actually modify the last column you need.

Other solution would be to implement a "pdf provided" column and only trigger the flow if you have true on this column.

If the flow is more complicated and you need to send notifications at many steps in the process, i would suggest:

build item-state column with "Yes/No" like "PDF provided" or different steps you have in the process.
make your flow paralel and a branch for every different state the item can be found
check if item-state column was modified in one branch with Get Changes for an item or file and for each branch you check your defined columns. you if should ask the question : has been "PDF provided" column modified right now, when this run triggered?" if yes, send the notification that your "PDF is ready".

Something like this!

For when you do a mistake, the "PDF provided" "yes/no" should act like a check for you, "Am i sure that what i wrote here is corect?" check the column and only then the notification will be submitted.

Good luck!

Quick Links

Leaderboard