cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Perez
Helper IV
Helper IV

PoawrAppsID in flow results

Hi,

I’m new to the flow and power apps capabilities and will be happy to get assist with this issue i encountered:

I built a flow that get a form results and update it into an excel sheet.

the flow is ending successfully but when looking at the result it is not was quite what i was expecting.

1. on the excel one new column was added: "__PowerAppsId__" (I didn’t define it as part of my form or my flow)

2. this new row contains 465 rows with values and only after it my data showed.

 

other than data was ok, as expected, only it appears in line 465...

Not sure why it is happening and would appreciate your help.

 

Thanks in advance

Eyal

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

 

Hi @ bangorkeith,

 

Once you create a connection to an Excel table in microsoft flow,your table will create a  "__PowerAppsId__" column automatically, this is the ID for that row, that you can later specify the row in a Flow.

 

You could refer to link below to learn more about the "__PowerAppsId__" column:

https://powerusers.microsoft.com/t5/Connecting-to-Data/Generate-ID-values/td-p/26713

 

 

Regards,
Alice Zhang

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

 

Hi @ bangorkeith,

 

Once you create a connection to an Excel table in microsoft flow,your table will create a  "__PowerAppsId__" column automatically, this is the ID for that row, that you can later specify the row in a Flow.

 

You could refer to link below to learn more about the "__PowerAppsId__" column:

https://powerusers.microsoft.com/t5/Connecting-to-Data/Generate-ID-values/td-p/26713

 

 

Regards,
Alice Zhang

View solution in original post

Hi @v-yuazh-msft

thanks for your reply.

it helped a lot.

i understood that the issue was becouse my inital table was with 450 empty rows and the flow just created the new row starting at 451.

 much appreciated.

 

Eyal

 

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 (70,791)