You’re offline. This is a read only version of the page.
Hi all,
Can anyone advise on the best way to get data into Dataverse from a public facing form?
I could try MS Forms but would need some transformation into the process.
Is there a more efficient direct way?
Thanks in advance for your help!
Hi @WebPortal ,
If you were utilizing Power Pages you would just be having the individual complete a new participant form in whatever event you showing. They could select the event from a dropdown (i.e. a Choice column) from the front-end to register for the correct event.
You could pass the event name with other approaches as well (i.e. Jotform, Microsoft Form, etc.) to register the participant for the right event.
Ok, didn't know about Event Management component, will have a look.
I don't need dynamic fields for the forms, since they're identical to all participants. I do need a column with EventID to link to Dataverse Events table. Thus, I need to know to which event the response belongs to. Any way to achieve this with Power Pages, Cards, or any other solution?
By adding a parameter to the page URL, maybe, would that be possible?
Thanks a lot for your help!
Ok, didn't know about Event Management component, will have a look.
I don't need dynamic fields for the forms, since they're identical to all participants. I do need a column with EventID to link to Dataverse Events table. Thus, I need to know to which event the response belongs to. Any way to achieve this with Power Pages, Cards, or any other solution?
By adding a parameter to the page URL, maybe, would that be possible?
Thanks a lot for your help!
Hi @WebPortal ,
Thinking through what you are trying to do here with Dataverse... Dataverse provides a relational model where you can setup a table for your events and this could have start date / end date / capacity / venue / etc. Note, Dynamics 365 for Marketing actually has an Event Management component (https://learn.microsoft.com/en-us/dynamics365/marketing/event-management).
Dynamically adding different fields for each event would be a bit challenging unless you created all the fields in your event table and only displayed what you would want to fill out for each event. Another thing to note is that Power Pages does not support business rules to hide / show fields etc. you would need to use code to do this.
If you do get this setup and you want to send to a specific person to complete the registration, you can setup your Power App to integrate to Exchange Online and send emails directly from the application to your user (maybe building email templates to simplify) that would contain the link to the Power Pages page for registration. This way it would track the email in Power Apps as well on who you sent to and when. Just a thought...
Thanks, that sure helps a lot to decide which way to go!
I'd rather stay with a full "Power Platform" solution, if that is feasible from a cost perspective.
Would this be the cost scenario for a Power Apps, Power Automate, Dataverse solution?:
From the technical perspective, the challenge is to let the app user build a form for each event (this is an events app), from a template and send it to the unauthenticated users to fill in. This isn't possible to do, is it?
HI @WebPortal ,
Agreed.
The Power Automate license would be a list price of $15 per user / month and you would realistically need 1 license if you fit within the limits (40K requests per day).
Dataverse licenses (full Dataverse, not Dataverse for Teams) comes with Power Apps Per App ($5 per user / month) or Power Apps Per User ($20 per user / month) licenses. Any organizational users utilizing a Power App that works with the data in the Dataverse would need one of these two licenses. If you were exposing to end users and wanted to utilize Power Pages then this has a different licensing structure (authenticated and unauthenticated users).
Hi @dpoggemann
Thanks for your help, I'll have a look at Jotform.
One of the main issues when making these decisions is to understand the associated costs, especially with Power Automate / Dataverse. And the cost of maintenance.
Hi @WebPortal ,
One thing I have done a lot in the past is utilized JotForm (www.jotform.com) as a form solution that I could embed in websites etc. This is a low cost solution with great capabilities within the form to have conditional fields, integration to payment providers and much more. You can connect to the webhook with Power Automate (https://www.jotform.com/blog/microsoft-flow-integration/)
Microsoft has Power Pages as well that you can utilize which will allow you to expose Dataverse forms directly to a Power Pages portal but this does have a higher price tag then Jotform and Power Automate combination.
If you want to utilize Microsoft Forms there is a connector directly in Power Automate to take the submitted form information and then you can use the Dataverse connector again with this approach.
#1
WarrenBelz
146,513
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,681
Most Valuable Professional
Share
Report
All responses (
Answers (