Wanting to create a form to generate a unique code, please help!

I am trying to use either PowerApps, Sharepoint lists or Flow (or anything else that will work best) to link an Excel spreadsheet I have which has a campaign code generator based on what data is inputted into the fields on that row.

So I basically want to create an app/simple GUI where you can https://19216811.cam/ easily use a form to enter in details which go into the spreadsheet, and then have the form return what code was generate https://1921681001.id/ d in one of the cells on the same spreadsheet. Is this possible to do? Thanks!

(The code generator is already made with a formula in Excel, so I just need the form to input data from the form live, and return what appears in the code generator cell!)


  • Avadhoot Kulkarni (Progress Software)

    Hi Lizie,

     

    This community forum is to discuss the challenges around data connectivity for different data sources including Microsoft Sharepoint. We at Progress DataDirect are experts on Data Connectivity and Data Access though I dont believe this forum will help you to get answers your are looking for on Microsoft Forms and App Integrations.

     

    You may get better response and answer to your queries here

    https://docs.microsoft.com/en-us/sharepoint/dev/community/community

     

    Hope this helps,