cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
thomas_d Kudo Collector
Kudo Collector

Flow with Sharepoint and Forms / Column-types in SP

Hi Community,

 

I have a short question about using Flow with Sharepoint and Forms. I created a SharePoint list with some columns (Type: Numbers).

 

So, the flow should work like this: Someone fill out the form --> flow create a item in a sharepointlist.

 

That is normally no problem, but i've seen that when a column in the SPlist is with the "type numbers", i can't match it in flow with the right forms field. (see picture)

 

 

Flow.JPG

 

When i change the Sp-Column to "Single Text line" it works. So that means it shows all fields from the forms.

How can i use a Number column in the SharePoint?

 

thanks for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Flow with Sharepoint and Forms / Column-types in SP

Hi @thomas_d,

 

I have made a test on my side and the issue is confirmed on my side.

 

Please add a Compose in your flow to save the number answer, the screenshot of the flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

Best regards,

Alice

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Flow with Sharepoint and Forms / Column-types in SP

@thomas_d:

 

You might try entering the Form response "column" directly by going to the Expressions tab.

 

Your entry will look something like this:

body('Get_response_details')?['r012ea19261d9436b86d32bc6d96da3c2']
 
An easy way to find this reference in to select an expression and then select the particular form response from Dynamic properties. Then just copy what you need and paste it in.
 
I successfully added a number response from a Formk to a SharePoint number column using this technique.
 
If this solves your issue, please amrk your post as solved.
 
Scott
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Community Support
Community Support

Re: Flow with Sharepoint and Forms / Column-types in SP

Hi @thomas_d,

 

I have made a test on my side and the issue is confirmed on my side.

 

Please add a Compose in your flow to save the number answer, the screenshot of the flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

Best regards,

Alice

View solution in original post

George_Lego
Regular Visitor

Re: Flow with Sharepoint and Forms / Column-types in SP

I have a survey where most of my questions need to be numbers for the output, do I need to do this for every question indvidually? 

Super User
Super User

Re: Flow with Sharepoint and Forms / Column-types in SP

@George_Lego:

 

As opposed to using the compose action for the values returned for each question, you might consider using one of the conversion expressions like int() or float() when in the column in the create item action.  That might be a lot easier to implemented.  I haven't test this but it should work.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
George_Lego
Regular Visitor

Re: Flow with Sharepoint and Forms / Column-types in SP

I think I got it working in a more uncovential way. I did not expect it to work but it did.  I used a text field to populate the reponse I wanted in a number field, so for example in the "Title" field I populated reponse for "Out of 10 how did I do?" then copy and pasted that response into the correct field.  No formula needed just cut and paste.  Worked like a charm. I even gone back to the SharePoint list and made changes and then to the form and made changes, it's still solid.  I was pleantly suprised. 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,813)