News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Power Automate

Power Automate - Building Flows

Unanswered

Power Automate

(0) Share

Report

Report

Posted on by Ray10

Hello all,
So basically the issue i face is when my repot pulls in 2 parameter values (job id and location), job id pulls because it exists in the database and Location does not due to the fact it was never created in the 2nd table. So how do i tell power automate to filter this out to something like i have below?

How to write expression in power automate in "export to file for Paginated reports" in parameter value using something like, "IF there is no value in the SQL database, use this default value instead."?

Thanks in advance been having trouble with this one for awhile.

All responses Img

All responses (1)

Answers Img

Answers (0)

Unknown geen idee 1,755 on at

Like (0)

Report

Re: Power Automate

Dear Ray,

Without more details, like for example some screenshots, you are unlikely to get any targetted answers to your problem.
In any case, in general, you could just do a filter on the array for locations and replace any blanks with you default value. Just a thought ... but again, since I do not see the flow, I am missing a lot of connections.

Happy flowing,
Koen

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans