Unanswered

Power Apps x Power Automate

(0) Share

Report

Posted on by nmlsanmiguel

Hello Guys,

I would like to seek help on my power apps. I have created Power Automate flow on my SP Lists that will split my datecolumn Year and Month. Unfortunately, when I created an item thru Power Apps, the column Year and Month were not updating. Is there something wrong in my flow created thru power apps?

Thank you for your usual assistance!

Power Apps Sample Flow

My SP List.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

turnerj3 2,039 on at

Like (0)

Report

@nmlsanmiguel ,
Did the flow show that it ran successfully?

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

I think yes?

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report

In power automate, you can click on the flow and see all the successful and failed runs. If one has failed you can click on the failure to see where.
But I have found power automate to be to slow to respond at times and cause issues trying to run back to back.
For your issue at hand I would create a Calculated Field column for Year and Month and use code to pull the Year and Month from the Timestamp without using PA.

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

Thanks for the reply, as much as I wanted to just create a calculated field. I will have a delegation warning. I am creating power apps for my office department which will have thousands of records in the future. So I am trying the very best possible way to have this power apps more flexible given it's restrictions.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report

What if you created variables in PowerApps stripping the Year and Month out of Today(), then patch them over when creating the new list item?

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

How?

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-datetime-parts

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

Hello again, This function is not delegable in powerapps. Thank you.

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

You have a trigger as your first action - but this flow is triggered from Power Apps, so it won't work because the item has already been triggered and then is waiting for another trigger.

You should instead pass the ID of the item that you created in Power Apps as a value to the flow, and just use that for your first action (which should be the Get Item action)

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

Thanks! But Can I know how can I get the LastSubmitted.ID value?

Was this reply helpful? Yes No