web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How do set value on em...
Power Automate
Unanswered

How do set value on empty if the value not found?

(0) ShareShare
ReportReport
Posted on by 2

I create a PA action feed that fetches information from a specific website from certain sections on the website (e.g. company name, company's email, company's phone, name of the CEO etc.). This feed loops according to the list of company names in Excel. Sometimes there are items (company information) whereas some of that information not presented, for example, there's no phone number. Now, instead to leave the phone field empty in the Excel where PA writes that information, it puts there the last phone number it fetched from the last record where the number was present in the company information. Thus that creates list of wrong information. 

What I should do to get that feed to work properly - i.e if there's no certain information or section presented in the record it'll render an empty space instead of the last recorded item?

Categories:
I have the same question (0)
  • TYL Profile Picture
    1,091 Super User 2024 Season 2 on at

    @TaaviM  Do you work with variables? If yes, you can reset a variable at the end of each loop run. This will give you a fresh variable to work with in the next run.

  • TaaviM Profile Picture
    2 on at

    Thanks! That resetting part was indistinct for me as I didn't know where to set it but finally, I managed to find a separate command "clear the list" or something like that. As I use Estonian language version I don't know its precise moniker.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard