cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ManuelS
Frequent Visitor

Creating a new record in Dataverse

Hi all,

I am building a flow. A Microsoft Form is filled in and when the user press "send" button the flow is triggered. And data is inserted in a existing table in the Dataverse. This is working but..... I am facing the following:

  • When building the flow and the action "Create a new record" in the Dataverse I can see a list of elements of the table but I cannot see all. Due to whatever reason I can only see some of them, so I can fill from the form part of the fields.

  • Additionally, in the "Create a new record" box for few of the visible items, I cannot insert a personalized value, while for the rest of them there are no issue.

Any help or light you can bring here will be much appreciated!

Regards

Manuel

2 ACCEPTED SOLUTIONS

Accepted Solutions
FCGALLEG
Microsoft
Microsoft

Hi Manuels,

 

What connection are you using? Common Data Service or Common Data Service (Current Environment)?

Try to use Common Data Service (Current Environment).

 

I hope it helps you.

 

Javier

View solution in original post

abm
Super User III
Super User III

Hi @ManuelS 

 

You need to use current environment connector (CDS/Dataverse) inorder to see the option set field names.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

7 REPLIES 7
FCGALLEG
Microsoft
Microsoft

Hi Manuels,

 

What connection are you using? Common Data Service or Common Data Service (Current Environment)?

Try to use Common Data Service (Current Environment).

 

I hope it helps you.

 

Javier

View solution in original post

ManuelS
Frequent Visitor

Thanks for your help,

 

your reply has solved part of the problem. Actually the second bullet.

 

I am still in trouble with the first one. The elements I cannot see are actually are the ones whose Data Type is "choices"... Do you know how this could be solved?

 

Thanks!

abm
Super User III
Super User III

Hi @ManuelS 

 

Most likely the issue is with data types. You might be mapping a numeric data types (Dataverse) from Forms. Try to add a compose above the create a new row step. Place the cursor under dynamic properties. You should be able to see all the properties from Forms. So to map to Dataverse you need to use PowerAutomate expressions such as int() or related data conversions.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
ManuelS
Frequent Visitor

Thanks @abm for your reply,

 

I am afraid I am not following you... (probably due to I am too novice here...) Below is the "Create a new record" action. All the elements below are majority of the columns of the table in Dataverse. So from your explanation above, I do not know what do you mean or what should I do.

ManuelS_0-1613979671545.png

If you can provide me some more details will be much appreciated.

 

Thanks

Manuel

abm
Super User III
Super User III

Hi @ManuelS 

 

I was under the impression that you can't see all the Dynamic properties of your Form submissions. Looks like what you are after is not seeing all the columns names from your Dataverse table. In that case could you please check whether the field level securities are enabled or not?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
abm
Super User III
Super User III

Hi @ManuelS 

 

You need to use current environment connector (CDS/Dataverse) inorder to see the option set field names.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

ManuelS
Frequent Visitor

Thanks @abm for your time, explanation and support yesterday. 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (71,897)