Hi Folks!
I want to set an If Statement every time a user attach a file and check it it is an excel file it will trigger a power automate code.
That is a completely different question and not straight-forward (it would be quite easy using the last attachment as I posted earlier).
This was a brain-bender and my best effort is below (and I cannot test it beyond it being valid code) - it should set your Variable to the content of the last attachment with an Excel extension
With(
{
wExt:
ForAll(
AttachControlName.Attachments,
{
Ext:
Last(
Split(
Name,
"."
)
).Result
}
)
},
With(
{
wPos:
ForAll(
Sequence(CountRows(wExt)),
Patch(
Last(
FirstN(
wExt,
Value
)
),
{RowNo: Value}
)
)
},
Set(
varAttachment,
Index(
AttachControlName.Attachments,
LookUp(
Sort(
wPos,
RowNo,
Descending
),
Ext = "xlsx"
).RowNo
).Value
)
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @philifova ,
You asked for every time a user attach a file - so that checks them as they attach. You would have to run this before you save the form
If(
CountRows(
Filter(
AttachControlName.Attachments,
Last(
Split(
Name,
"."
)
).Result = "xlxs"
)
) > 0,
RunYourFlow . . .
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @WarrenBelz
The user have ability to attach multiple files at the same time. They can also attach a PDF file. I tried the code you provided. It didn't trigger the flow it is because the excel file is in the second row.
Hi @philifova ,
Something like this OnAddFile
If(
Last(
Split(
Last(Self.Attachments).Name,
"."
)
).Result = "xlsx",
RunYourFlow
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps