cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (59,514)