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

Cognito Entry number appearing incorrect in excel

So I have a flow that adds rows into an excel sheet on One Drive from a Cognito form entry. It's a successful flow, adds everything i'd like. My problem is that when it inputs the entry number from another form it adds numbers before it.  Under FCCActionPlan i'd like it to read 10, but it inputs as 116-10. Is there any way I can change is?? 

Doc1.jpg

 

 
3 REPLIES 3
v-bacao-msft
Community Support
Community Support

 

Hi @MSFlowFCC ,

 

Could you share the configuration of Flow and the approximate process of your testing?

I'm afraid I can't reproduce the problem you mentioned based on your description.

Please provide more details so that we can provide a suitable method.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi

So it's when a new entry is added to Cognito is adds a row to an excel file on OneDrive. The FCCActionPlan column is taking it's information from FCCActionPlan(ID) through the flow. (I seem unable to insert a screenshot for some reason).

 

I can see on other documents we have that the same thing occurs.

Hi @v-bacao-msft 

It has now allowed me to upload a screen shot for you.

Add a row.jpg

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,629)