Skip to main content

Notifications

Community site session details

Community site session details

Session Id : SYGDZEdumpcG0Uu35Yy+ua
Power Automate - General Discussion
Unanswered

Avoiding duplicate monthly submissions

Like (1) ShareShare
ReportReport
Posted on 9 Jul 2024 19:21:21 by 4

I was brainstorming the best way for monthly numbers to be submitted via the Microsoft suite of products. This lead me to believe that creating Forms for each unit, utilizing Power Automate to have each Form automatically add a row to a corresponding Excel worksheet. I would like to prevent repeat submissions, however. Instructions state to indicate the month by using the 15th for the day of each submission. I wish the day did not have to be included on the submission, but that is what it is for the sake of Forms and Excel. My next thought, which I thought would be easy, was to create a way to prevent transcription of data for which the date already existed in the worksheet. I have tried to pull the table data, and use an array filter to match the date from the Forms submission. This leads to no output, as I believe the Forms date field is in a (d)d/mm/yyyy format and the Excel table is pulled as the numerical Excel format. I have tried the help offered at https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/, but always get a blank array output. Any advice for this topic would be much appreciated.

 PA.png

PA2.png

  • mikec4 Profile Picture
    4 on 10 Jul 2024 at 15:05:51
    Re: Avoiding duplicate monthly submissions

    Columns in each report are date, then metrics which could easily not be unique over time. These include things total orders, entry errors, etc. Date is the only thing that is guaranteed to be different, except for duplicate entries.

  • creativeopinion Profile Picture
    10,248 Super User 2025 Season 1 on 10 Jul 2024 at 13:12:17
    Re: Avoiding duplicate monthly submissions

    @mikec4 Could you share a screenshot of what a duplicate entry would look like? Would all columns of data be the exact same (except the response ID of course).

  • mikec4 Profile Picture
    4 on 10 Jul 2024 at 12:55:34
    Re: Avoiding duplicate monthly submissions

    Thank you for the resources. I figured I could somehow use the format data type function applied to the Excel table to get the dates in the same format, but I have had no luck. The one time submission does not work, as these Forms are to be used to gather monthly reports. It is possible that someone may forget that they submitted already, or another staff member may duplicate their effort. I could forget this idea, and instead manually review all dozen or so worksheets periodically. 

  • creativeopinion Profile Picture
    10,248 Super User 2025 Season 1 on 09 Jul 2024 at 20:42:34
    Re: Avoiding duplicate monthly submissions

    @mikec4 The is equal to operator looks for an exact match. In your case, the values you are comparing to each other will never match. Can you provide more insight as to how your form is set up and how you would get duplicate submissions? Have you considered setting your form so only one response will be accepted per person? 

     

    In the meantime, you might be interested in these YT Tutorials I've linked below.

     

    How to Get Microsoft Form File Uploads Attached to an Email đź“§

     

    In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

     

    IN THIS VIDEO:

    ‌✅‌ Two types of MS Forms

    ‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    ‌✅‌ Where Microsoft Group Form File Uploads are Saved

    ‌✅‌ How to Add a File Upload Question to an MS Form

    ‌✅‌ How to get a Microsoft Form ID

    ‌✅‌ How to get a Microsoft Form Response

    ‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

    ‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

    ‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

    ‌✅‌ How to Get the File Content from an MS Form File Upload

    ‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

    ‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

    ‌✅‌ How to Create an Email Key

    ‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

    ‌✅‌ How to Create a Dynamic Output Based on Form Selection

     

    -----

    How to Add Microsoft Form File Uploads to a SharePoint List Item

     

    In this Microsoft Power Automate Tutorial I’m going to cover how to add file uploads to a SharePoint list item. First, I’ll show you how to get the file name and content from the File Uploads from your Microsoft Form, then I’ll show you how to add those files to a SharePoint item.

     

    IN THIS VIDEO:

    âś… Two types of MS Forms

    âś… Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    âś… Where Microsoft Group Form File Uploads are Saved

    âś… How to Add a File Upload Question to an MS Form

    âś… How to get a Microsoft Form ID

    âś… How to get a Microsoft Form Response

    âś… How to Get the Dynamic Content Microsoft Form File Upload Content

    âś… How to handle Single and Multiple Microsoft Form File Uploads

    âś… How to use a Scope action to Organize and Group Your Flow Actions

    âś… How to Get the File Content from an MS Form File Upload

    âś… How to Collect All Files from Multiple File Upload Questions

    âś… How to Handle MS Form Response When a File Isn’t Uploaded

    âś… How to Attach an MS Form Single File Upload to a SharePoint List Item

    âś… How to Attach Multiple MS Form File Uploads to a SharePoint List Item

    âś… How to Attach MS Form File Uploads to an Email

     

    -----

     

    How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    IN THIS VIDEO:

    âś… How to get a Microsoft Form Response into SharePoint

    âś… How to get a Microsoft Form ID

    âś… How to get a Microsoft Form response

    âś… How to Build a Microsoft Form with Conditional Fields

    âś… How to used Branching in Microsoft Forms

    âś… How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    âś… How to parse a Microsoft Form multiple choice response as string of text

    âś… How to convert a text response to a number

    âś… How to use the Switch action

    âś… How to create a custom email confirmation for a Microsoft Form submission

    âś… How to Create a Custom View in a SharePoint list

    âś… How to use the Compose Action

    âś… How to write Power Automate Expressions

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a đź‘Ť if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard
Loading complete