Unanswered

Add ID to manual trigger flow run

(0) Share

Report

Posted on by Sherif-Abolsaud

Hi, I have a manual trigger flow where there is no ID field for each flow run.
Please advice how to add auto increment ID to each run in order to include it in the excel action: 'Add a row into a table' along with other fields from the flow run.

All responses (4)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Re: Add ID to manual trigger flow run

Hi @Sherif-Abolsaud ,

It is also a good method, I think there will be no problem. Now the license does not limit the number of Flow run.

Best Regards,
Sherif-Abolsaud 9 on at

Like (0)

Report

Re: Add ID to manual trigger flow run

Thanks.
I found a simple solution that to add share point step'Create item' in a list which has ID column.
It is working fine, but any problem may happen in future? after many records getting recorded around 60 item per day?
v-bacao-msft on at

Like (0)

Report

Re: Add ID to manual trigger flow run

Hi @Sherif-Abolsaud ,

Maybe you could try the following configuration.

Use Order by to get the record with the Max ID, add 1 to this value, and insert it into a new row.

Image reference:

Spoiler (Highlight to read)

Hope this helps.

Best Regards,
yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: Add ID to manual trigger flow run

Hi @Sherif-Abolsaud

For a manually triggered flow, you can use the expression to get the request ID and use that: @{triggerOutputs()?['headers']?['x-ms-client-request-id']}

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!